Viewing 15 posts - 23,806 through 23,820 (of 39,919 total)
Florian Reischl (5/22/2009)
There is anybody watching soccer in the US? I didn't suspect this.
Sure, Lynn watches his ten year old pros every Saturday 😛
May 22, 2009 at 10:36 am
truncate will remove all data AND reset the identity to it's starting value, whatever that was. It doesn't have to be 1.
DBCC RESEED will reset it to the value you...
May 22, 2009 at 10:34 am
Let me know, it will be worth the $10 to see how Grant meets his end!
May 22, 2009 at 10:27 am
You still will likely need to edit the startup parameters for the service. You can do that in the services applet. Configuration Manager also allows this on the advanced tab...
May 22, 2009 at 10:26 am
A salute from me as well.
Sadly, I tried to join the Navy, 4H (bad ear) and too young (and prideful) to accept being turned down by the submariners.
May 22, 2009 at 10:21 am
Lynn Pettis (5/22/2009)
I like watching professional soccer. You rarely see the coaches getting angry on the touchline with the officials (not saying the don't).
You rarely see anything happen in...
May 22, 2009 at 10:18 am
John,
Thanks, and there are a few people here in scouts. Grant Fritchey leads a Cub Scout group. Congratulations to you on your Eagle as well. Something to be very proud...
May 22, 2009 at 10:10 am
I don't think it's more or less efficient storing the value in a table.
Calculating it is a function call, no I/O, minimal CPU to perform.
The query writing to a table...
May 22, 2009 at 9:59 am
The only way I know of for the plan in 2000 is a screen shot, and if it doesn't fit on one, multiple ones.
The text plans are harder to read,...
May 22, 2009 at 9:51 am
Grant Fritchey (5/22/2009)
May 22, 2009 at 9:50 am
You would have to go into more detail. not just the script, but how does the file get there? Is it copied? Perhaps it's not completely copied when the procedure...
May 21, 2009 at 9:42 pm
I've taken an opposite tact. Often I've just tracked the file sizes of backups.
Either way works, just be consistent.
May 21, 2009 at 5:58 pm
Didn't think of that, Greg, and it's not bad. It is maintenance if you change the job, though you could abstract things with stored procedures.
Adding/removing a day means just adding...
May 21, 2009 at 5:37 pm
It fails in some places, with some keywords, but you are right. For the most part, SQL Server can figure it out.
However, it also messes up color coding, and confuses...
May 21, 2009 at 5:32 pm
So the access used to work with people being members of Group1?
Are you sure it wasn't through some other method that got revoked?
I'm not enough of an AD guru to...
May 21, 2009 at 5:28 pm
Viewing 15 posts - 23,806 through 23,820 (of 39,919 total)