Isn't Lock pages in memory Enterprise Edition only? Also, isn't it strange though that it has 13 GB left on the system to allocate, but the page file says...

We put a cap at about 14 GB leaving about 6 GB left of the 20 total.

I noticed the same behavior as well. I thought well maybe if the CASCADE DELETE or UPDATE options were not set it might prevent records from being modified or...

Thanks, yeah there are no conditional statments just simple exe spsProc.

Idera has a BETA of the Admin Tool belt. It can document and save config info for the servers and databases. You can define groups and document all...

Do you have Microsoft Operations Manger in your enviroment? I've found that product and new Systems Center much more robust for handling that kind of reporting. It's a...

Why do you not like the SQL Native Client? It is actually just the updated version of the MDAC dll's for OLE DB and ODBC in one DLL. ...

Here is an article talking about renaming SQL Servers:

http://msdn.microsoft.com/en-us/library/ms143799.aspx

I don't know what type of security you have setup on your server, but remember that when you convert from workgroup to...

I'd need more info about your error you receive. If I understand correctly your trying to set a SPN for the MSSQLService account?

If you type:

setspn -L "ServerName"

You should see...

1. RedGate Tools are some of the best in my opinion

2. SQL Management Studio - Home grown scripts

3. Periscope (Performance Monitoring, not as robust as Idera, but better price)

4. MOM!!!...

I believe you can accomplish this by using the SQL Server Configuration Manager tool.

Start > All Programs > Microsoft SQL 2005 > Configuration Tools> SQL Configuration Manager

Select the instance name...

Are you using a "Domain User" acount as the Agent for access to the share? Verify your NTFS permissions allow access too. You could change the snapshot location...

Your Distribution Agent needs to be able to "READ" the file share where your storing the snapshot otherwise your going to get an error. The windows account your using...

Thanks for the link, but that...

Thanks for the info. I feel the same way, and wanted to hear what other DBA's were saying, and any facts they have heard.

I've already heard lots of develpers...