Viewing 15 posts - 29,371 through 29,385 (of 39,771 total)
You can install the client tools only. I believe all you need is a CAL for the server to be licensed.
February 29, 2008 at 12:42 pm
Perhaps you have duplicates in the source data.
February 29, 2008 at 12:40 pm
Thanks and this is an interesting feature.
February 29, 2008 at 10:07 am
Confirmed and I have a final note from MS:
===
We have recently discovered an issue with SQL Server 2008 CTPs that result
in SQL Server 2008 not starting or installing on...
February 29, 2008 at 10:06 am
Someone mentioned that you should report this on Connect as something to get fixed/changed. Or moved to a DMV.
February 29, 2008 at 8:59 am
Also check for open transactions. I've seen those cause issues.
Look for someone building large temp tables as well.
February 29, 2008 at 8:57 am
If you need a basic plan to check for integrity, use the Database Plan Maintenance Wizard.
February 29, 2008 at 8:34 am
I could go either way, though I tend to favor Matt's view.
Communicate with them and work it out with managers. Let managers know that there are dangers, and that if...
February 29, 2008 at 8:32 am
I like the 1 file per core rule as a guideline. Each separate file should get a separate thread to handle it's IO work, so if you go with that,...
February 29, 2008 at 8:29 am
Sorry, the only thing I've hard back is use a CLR procedure to log this information, which seems overly complicated.
I can get the data out in SQLCMD, but I get...
February 29, 2008 at 8:27 am
The person in the article didn't necessarily want to get promoted. They weren't that type of person. It didn't have to do with overtime.
It's hard to say why this person...
February 29, 2008 at 7:50 am
Please explain the details of what you did as Scott asked.
I'm not sure the service account needs SA rights, especially the SQLAgent account, but it does need rights to connect...
February 28, 2008 at 9:16 pm
I prefer detach/attach, but I agree with Tim, either will work.
February 28, 2008 at 9:13 pm
I've usually just randomized names, take 100 last names, randomly replace existing data in there.
Phone numbers can be sequenced, all 555-0000, 555-0001, etc.
Other stuff, just need to move it around....
February 28, 2008 at 2:24 pm
Viewing 15 posts - 29,371 through 29,385 (of 39,771 total)