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...

No and No.

The system tables contain information that keeps the server running. Logins, users, databases, etc. are contained there.

Why do you want to mess with the system tables?

Thanks:blush:

I'm a little confused and concerned. First don't use Sa or equivalent for something like Cold Fusion. Create an account and work through the rights.

Second, the current security context will...

You add a new conneciton in the Data Sources (ODBC) control panel. Enter the server name/instance name and your credentials. It will connect.

http://support.microsoft.com/kb/943656, looks like you need to submit a request to get the download.