Viewing 15 posts - 36,226 through 36,240 (of 39,717 total)
This is probably the best way. Simple and easy. I do something similar, but have DTS to migrate a bunch of this data to one server for a daily report....
June 9, 2003 at 8:40 am
I don't think so, but you'd have to try it. Not sure if there is anything in the multi-server code that would stop this.
Steve Jones
June 9, 2003 at 8:35 am
We have hundreds of servers (600+) here, over 100 SQL Servers, who knows how many dbs. In Operations we manage about 55 servers (about because we only do backups on...
June 6, 2003 at 11:43 am
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
also parts 2 and 3
Steve Jones
June 4, 2003 at 9:49 am
don't remove the pk. delete the rows and reimport them without set identity_insert to give them new values.
if that's not possible, you can remove the identity (Requires a table...
June 4, 2003 at 9:39 am
Someone else needs to verify, but as far as I remember, if you use PAE, you do not use AWE.
sorry, i missed the 3gb in your first post.
Steve Jones
June 4, 2003 at 9:28 am
search sp_help_revlogin on technet. use this to script out the logins. Then change pwds and if you want, delete 1 a week after trying to find where they are used....
June 4, 2003 at 9:25 am
Excellent list of lessons learned that everyone should follow. Whether you are a PM or a developer. My wife follows these as a consultant, often having PMs that don't, and...
June 4, 2003 at 9:22 am
they have a low end version that just reads for around US$400. The higher end version will undo transactions by generating a script to undo the action.
I thought lockwood was...
June 3, 2003 at 3:52 pm
strange. sounds like a bug somewhere. Is this ss2k? service pack?
Steve Jones
June 3, 2003 at 3:50 pm
space maybe? Only local disks should show up. What does xp_fixeddrives return?
You can also just type the path.
Steve Jones
June 3, 2003 at 3:49 pm
First, I would care about the log file. It's easy to throw away if you don't need it, but if younever capture it, you may be asking for trboule.
second, if...
June 3, 2003 at 3:48 pm
If I were interested and I read the post, I'd be turned off. It sounds like they want everything and don't want to give anything. The explanation given later is...
June 3, 2003 at 3:43 pm
create trigger mytrig on tableA for update, delete as
insert mytable
select id, name, etc
from deleted
Steve Jones
June 3, 2003 at 3:37 pm
June 3, 2003 at 3:34 pm
Viewing 15 posts - 36,226 through 36,240 (of 39,717 total)