No idea. I typically post a note if I move a topic.

They should be. We've had over 300 posts today.

There is some minor caching, but after you post, you should see a note at the top of the thread that the...

Thanks for the feedback.

A lot of people have liked the TOC on the right, so I'm not sure we'll change it. A few things. If you click a link, you...

Made me smile, Charles!

Glad to see people enjoying their jobs. I've always enjoyed it myself.

Read these:

http://www.sqlservercentral.com/articles/Administration/61680/

http://www.sqlservercentral.com/articles/Administration/61681/

Yep, I did 🙁

I'll change that.

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.