Viewing 15 posts - 29,941 through 29,955 (of 39,769 total)
I think I'd do something similar to what you're doing. I might create a real table, populate with the data + SPID perhaps, extract batches of 300 from there. Maybe...
January 9, 2008 at 7:09 am
This should be a list of options set for the database. Is there something set differently on that database?
You can look at the code for this proc in master to...
January 9, 2008 at 6:45 am
You could set some things up, like DDL triggers, but a sysadmin could disable them.
Remove them from sysadmin access if you need to.
January 9, 2008 at 6:40 am
The above is correct. Once you've done this, you require a full backup to be able to restore. This should not be a standard practice in production. The TRUNCATE ONLY...
January 9, 2008 at 6:39 am
Can you explain what you mean by combine? Run both of them together? Run one of them based on Z?
January 9, 2008 at 6:38 am
Please don't cross post.
Answered here: http://www.sqlservercentral.com/Forums/Topic440533-338-1.aspx
January 9, 2008 at 6:37 am
Any of the 2005 books are fine. I like the one from Brian Knight, but I know him and he's a business partner.
January 9, 2008 at 6:36 am
That's really the only way to make this work. The trigger will always execute as the person updating the table, and it would need rights to the other database if...
January 9, 2008 at 6:35 am
Inside SQL Server is here: http://corporate.books24x7.com/home2.asp
January 8, 2008 at 12:52 pm
I like to stay fairly current, but if I couldn't thoroughly test, I'd wait for SP3. I would recommend if you have an issue fixed in a cumulative pack, get...
January 8, 2008 at 12:49 pm
I haven't messed with the maintenance plans much in BIDS, but you should be able to open them in SSMS, under the Management folder. There is a subset of SSIS...
January 8, 2008 at 12:47 pm
Typically named pipes is disabled on SQL Server. I think W2K used that as the default, XP uses TCP/IP. Change the Win2K machines to TCP or allow named pipes on...
January 8, 2008 at 9:28 am
RAID 5 isn't recommended. I'd really look at R1 or R10 for this, they will give you better performance.
When you say temporary files, do you mean temp tables in tempdb...
January 8, 2008 at 9:26 am
First, why do you use those values in the HAVING clause instead of the WHERE clause?
Also, it's not really clear what's not working. If you get extra rows, then you...
January 8, 2008 at 9:24 am
Viewing 15 posts - 29,941 through 29,955 (of 39,769 total)