What about using DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS?

What shows up when you open up SQL Server Configuration Manager and check the services section?

This sounds similar to what MS wants to do with data-tier applications in SQL 2008 R2.

Understanding Data-tier Applications

I think this may not be working because foreach-object needs to reference an array object to work like foreach-object {<$object> in...

With Windows Server 2003 using /PAE and AWE you can address up to 64GB of RAM. I would say at least 2-3GB would be needed for the OS leaving whatever...

If this is the case then you should stress to your management that the...

I agree with Dan. We still have some operational 2000 instances that we have not been able to migrate to 2008 yet, and with our SAN vendor we can increase...

Have you applied SQL 2000 SP4 on your workstation? If not I would try that and then try connecting again.

Alternatively, since you have a SQL 2005 instance also deployed, why...

Run dbcc (<db name>) updateusage to update the page count and then rerun dbcc checkdb (<db name>) with no_infomsgs, all_errormsgs to ensure that there are no more errors in the...

Something I just forgot. Make sure that the powershell environment is setup to run scripts. By default scripts are disabled in powershell. You need to make sure that the execution...

What do you get when you run the following:

dbcc checkdb (dbname) with no_infomsgs, all_errormsgs

If powershell is installed on the server, just create a cmdexec step and in the command box just type the following:

"c:\windows\system32\windows powershell\v1.0\powershell.exe" -file <file>

Where <file> is the location/name of your...

Just for clarification, are the e-mails actually getting sent out to the intended recipients? It almost sounds like the SMTP server the job is using is rejecting to send the...

I do not think comparing fullname to surname like that would be wise, because even if the data was correct it would come up as true. For example 'John Smith'...

Well, since you are loading your dev environment with your production environment if replication breaks down and you cannot get it back up you can reinitialize replication.

You could do...