ms_foreachtalbe only works on system tables.

You can open this in the master database and look at the code. It just runs a cursor that grabs each user table.

where OBJECTPROPERTY(o.id, N''IsUserTable'')...

If you are planning on consolidating servers, there aren't any great resources I've seen. It's very diverse to move server names, determine resource usage, application impact, so any articles I've...

You are doing a cross tab report, moving columns to rows. Search for cross tab and check out code examples.

It's not necessarily bad to have things in the primary filegroup. I know some people prefer to have the system data in a separate filegroup, but especially for small databases,...

You can right click a database, select "export data" and then walk through the wizard to copy data and objects back. It's similar to the copy database wizard in DTS.

You...

You have the basic case statement above in your code.

case when xxx then yyy

when zzz then iiii

else jjjj

end

so

case

when...

Embedded SQL is SQL code in your application. So your code on the client does something like

str="select * from MyTable where ID = " + strID

You want to get this...

Please don't cross post.

Discussion is here: http://www.sqlservercentral.com/Forums/Topic438427-149-1.aspx

I still think Profiler is the best choice for something like this. You might be able to get this into the SSRS log.

Thanks for the complements and I'm glad to finally get it. I told a few friends, but I didn't want to make a big announcement.

Quite of few of you should...

This is a setting for files on your system. When you install SQL Server 2005 tools, the .sql extension is linked to Management Studio. Note that this is a tool,...

We do not condone or post dumps from exams. That violates the NDA you have with taking the exam and if you receive a brain dump and use it, you...

You can use SSIS to "roll back" a SQL 2005 database, but why would you? Why not just install another instance of 2000 temporarily if you need to?

Once you upgrade...

Not sure about the 64-bit to 32-bit move. Both of these require a full backup and you can easily test that to see if it works.

If you are doing reporting...

You're two service packs behind, but I'm surprised. Is this the same on other workstations servers if you connect to this server? I don't remember a bug for this, but...