Viewing 15 posts - 27,706 through 27,720 (of 39,803 total)
You could have another bug in there.
The scheduler in SQL Server manages threads just like the scheduler in the OS does, but this one managers the SQL processes. If...
July 26, 2008 at 10:07 am
This sounds like a test or interview questions, as Gail mentioned, and we don't solve those for you.
Please put in questions that you have, but show some effort to have...
July 26, 2008 at 10:06 am
If you have a question, please list it. We do not want statements only posted here. You should have asked if what you think is true and not just left...
July 26, 2008 at 10:05 am
Use parameters in your client side code as well. Don't
Myvar.Execute "myproc " & myparam
Use the proper parameter client side methods (add to the call as methods, not concatenations) when calling...
July 25, 2008 at 6:33 pm
Service accounts are administrator level functions, usually, so I, or another admin, changes the password if it's needed. So we never store them for that reason.
I also never share them....
July 25, 2008 at 4:50 pm
Actually that's a great question and probably worth an article or two. If Jeff/anyone else if up for it, send me a draft. I'm sure people are intereseted. Likewise Mr/Ms...
July 25, 2008 at 11:50 am
You DO NOT want to grow on demand. You want to set a size that will be used over the next 3-6 months, as Tom mentioned. Do it during periods...
July 25, 2008 at 11:15 am
How are you adding to the DB? I don't see any place in there where you need to shut down the db file. You should be inserting into the database...
July 25, 2008 at 11:14 am
Unless the log is directly after the backup, you can't.
The way this works is (over time):
full backup 1
- log 1
- log 2
full backup 2
- log 3
- log 4
If you have...
July 25, 2008 at 11:12 am
sp_help_revlogin, script out logins, add them back.
Might need to script roles out on the server level, not sure where that's kept in 2005 and how easy it is to pull...
July 25, 2008 at 11:09 am
What's stable enough?
Haven't seen any news about issues with it. I know that SS2K might not be supported on W2K8, they tend to support only 2 versions backwards (the Windows...
July 25, 2008 at 11:09 am
This wasn't database mirrroring was it? I believe replication and mirroring, while similar, function differently.
Truncate not being tracked in DDL triggers is a problem. I hope this is fixed in...
July 25, 2008 at 11:08 am
I think Jack has the only good way to do this in 2000.
July 25, 2008 at 11:06 am
Viewing 15 posts - 27,706 through 27,720 (of 39,803 total)