Server Configuration

Lock pages in memory greyed out
I have a server running 64bit SQl 2008 standard and the application we have to run on it needs to be able to lock pages in memory. I tried to do this via the local policies but the add users is greyed out and I'm stuck. Currently without that setting i'm using 11.8Gb of memory of the 12 and i'm told this is n... 4 May 2010 14:35

Lock pages in memory greyed out
I am trying to give the ability to a user to "Lock pages in memory" via local policy, and for some reason it's greyed out. I can't change this and it is needed on a version of our software running on SQL standard 2008 64. I've tried all of the ways listed on the internet but it's continued to be greyed out. ... 3 May 2010 16:30

SQL Job sending a file to a network directory?
Hi, I am trying to create a Job in SQL Server 2005 and have an output file being sent to a local directory. I can do this no problem by sending the file to a local directory, but when I try to send this to a Network directory, the process still runs successfully but the file does not show in the specificed netw... 7 May 2010 14:32

sqlserver to mysql data transfer of image column
we are copying a sqlserver 2005 data to mysql using perl dbd (freetds for sql server and standard dbd/dbi for perl). We are having problems with image column of a sql server table. this contains jpeg data and the application can not view it on mysql side. We also used bcp of sqlserver and same problem there too. i... 3 May 2010 14:16

Statistics on SQL 2005
It appears that outside of statistcs name, sql server allows you to create duplicate statistics. How does sql server handle statistics update when this happens? Also, is there a difference in having single create statistics statement for two columns compared to two create statistics statements for one column ea... 2 May 2010 13:09

Log Errors BCP
Hi. I am using the BCP utility to import more than 10,000 files using the following command for %%f in (D:\Ixport\*) do bcp db.dbo.tbl_file in "%%f" -c -T -t\t -r\n Is there any method to log the text file name or row which have errors while importing. Regards, Muhammad Bilal ... 12 May 2010 14:45

Get all FKs with their table names, PK/FK fields
Check out: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/c33aa736-3303-4968-b1fb-8308d935148f Erland Sommarskog wrote: Re: Table & Column Name 03-Oct-09 Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes: Not sure that I understand what you are looking for, but this lit... 1 May 2010 03:20

US-MD-Silver Spring: SQL VMWare TV Network DBA
<http://www.filcro.com/SQL-Database.html> � Installing, configuring, troubleshooting and maintaining MS SQL environments � Experience working with VMWare (ESX 4.0 preferred) � Strong SQL / scripting skills � This position is approximately 75% Database Administration and 25% Systems � Strong Active Directory an... 30 Apr 2010 21:53

Run Query from a Column Value
Hi Let if I have a tb1 with col1 CREATE TABLE tbl1 ( Col1 VARCHAR(500) ) INSERT INTO tbl1 VALUES('SELECT * FROM tbl1') INSERT INTO tbl1 VALUES('SELECT Query FROM tbl1') In col1 I have inseted a query as a string. How can I run the query stored in col1. Regards, Muhammad Bilal ... 1 May 2010 05:29

BCP Qusetion
Hi. Is it possible to execute a procedure from a BCP Batch file for SQL Server 2000. Regrds, Muhammad Bilal ... 1 May 2010 12:04