Try the IS_MEMBER function.

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

jason.nodarse (2/21/2012)

---

When I do a sp_configure it does not list out the max in memory Can someone give me the command so I can see if I already have...

You can set the max server memory to 20 GB for SQL by executing...

It will take approximately the same amount of time to compress an index as it does to rebuild it.

In Active Directory, create a service account for SQL. Then in the account properties, select the account tab, and check "Password never expires" under account options.

Is the SQL Server Browser service started?

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

You might be running into this bug if you are on SP4.

http://support.microsoft.com/kb/899761

Run the code below with results to text. It will generate the statements to transfer schemas.

SELECT 'ALTER SCHEMA TheNewSchema TRANSFER ' + S.name + '.' +T.name +';'

FROM sys.tables as T...

If nothing was returned by DBCC TRACESTATUS then you don't have any trace flags enabled.

Right click on the linked server and select “Script Linked Server as”

For trace flags, you can use DBCC TRACESTATUS

A few other things you may want to script out or keep track of if they apply:

•sp_configure

•Alerts

•Operators

•Jobs

•SQL Agent config

•Database Mail config

•Trace Flags

•Linked Servers

•Replication publications or subscriptions

If you know when the CPU spikes occurred, you can use the view ReportServer.dbo.ExecutionLog2 to go back and see which reports were running during that time. I use the queries...

You might have to change the environment variables.

Right click Computer / Properties / Advanced system settings / Environment variables

In the “path” system variable make sure:

C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn

Comes...

My apologies, I had lost track of the original post.

Richard Moore-400646 (11/22/2011)

---

If all of the logs are already current, all you have to do is issue the command I previoulsy listed. Otherwise, you need to apply any outstanding...