Viewing 15 posts - 30,001 through 30,015 (of 39,763 total)
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'')...
January 3, 2008 at 9:52 am
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...
January 3, 2008 at 9:49 am
You are doing a cross tab report, moving columns to rows. Search for cross tab and check out code examples.
January 3, 2008 at 9:46 am
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,...
January 3, 2008 at 9:45 am
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...
January 3, 2008 at 9:39 am
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...
January 3, 2008 at 9:36 am
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...
January 3, 2008 at 9:33 am
Please don't cross post.
Discussion is here: http://www.sqlservercentral.com/Forums/Topic438427-149-1.aspx
January 3, 2008 at 9:32 am
I still think Profiler is the best choice for something like this. You might be able to get this into the SSRS log.
January 3, 2008 at 9:25 am
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...
January 3, 2008 at 9:23 am
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,...
January 3, 2008 at 8:34 am
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...
January 3, 2008 at 8:33 am
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...
January 3, 2008 at 8:31 am
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...
January 3, 2008 at 8:30 am
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...
January 2, 2008 at 7:55 pm
Viewing 15 posts - 30,001 through 30,015 (of 39,763 total)