Viewing 15 posts - 32,266 through 32,280 (of 39,748 total)
Good suggestions above, I'd be sure you get a server class machine, use RAID, at least RAID 5 for the data storage. If you can afford to add in 2...
April 10, 2007 at 7:34 am
The worksheet name is the table name, so if you name your worksheet and then create the table to match, it works fine. I've also done the "drop table" as...
April 10, 2007 at 7:30 am
I've heard great things about sqlSentry and people do seem to love it, but it can get expensive.
Reporting a negative is something I've done on a homemade exception report. I...
April 10, 2007 at 7:29 am
Thanks for the notes and those 3 (2150, 2153, 3054) have been added.
Also added a CSV to the article so you can download the list. I'll try to keep it...
April 10, 2007 at 7:21 am
Better to have two Steve's and let them watch each other.
And if anyone needs an escort at a conference, grab myself, Andy, Brian, or one of our well known authors...
April 9, 2007 at 3:32 pm
Adam,
Haven't taken it, but pass percentages seem to be about 850 or so and the # of questions is usually 52. I took the 444 exam and it was standard...
April 9, 2007 at 9:15 am
You can also use the FileSystemObject in DTS (ActiveX) task to do this.
April 8, 2007 at 4:42 pm
I think you can make this person an owner of the dbo schema as well.
April 8, 2007 at 4:41 pm
Search this forum and the MS one and you'll likely find some interesting problems to solve. There are also a few DTS articles on this site you can read.
April 8, 2007 at 4:40 pm
I tried it years ago in the floppy era and it worked a few times for me. Haven't messed with it since then.
April 7, 2007 at 12:32 pm
sp_help_revlogin from Microsoft. Search for it there for 2005. I think we might have the original version for 2000 here.
Yep, saved it: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1711
The syntax changed slightly for 2005.
Use this on...
April 6, 2007 at 7:31 am
Jeff's got great advice here and I agree with him. If this server is used by a few people it might be ok, but 1GB of RAM is pretty low....
April 6, 2007 at 7:30 am
Biggest thing for me is on-site shower. Nice to be able to run/bike/basketball/soccer, etc. and get clean after lunch.
April 5, 2007 at 8:01 pm
Sorry, I know I saw it somewhere, but I must have grabbed the wrong URL. Still looking.
April 5, 2007 at 8:00 pm
Sorry for missing this the other day.
We did it by creating two tables. One for things you add from the site and one for things we add, like purchased products....
April 5, 2007 at 2:17 pm
Viewing 15 posts - 32,266 through 32,280 (of 39,748 total)