Viewing 15 posts - 9,571 through 9,585 (of 9,725 total)
When we installed SQL 2005, we were unable to split the .mdf and .ldf files. We could change the base location of the DBs, but couldn't split up the files. ...
July 19, 2007 at 5:56 am
Okay, now that's just weird. I had never noticed this behavior from SQL Server 2005, but you are absolutely correct. When I only specific one column in the SELECT (out of...
July 19, 2007 at 5:54 am
I haven't tried this, but you might investigate setting up a DDL trigger on the certification events. Or check the other DDL Events and Event Groups to see if something...
July 19, 2007 at 5:51 am
I can see your point, but I still quibble with the word "scam". The way I understand a scam to be is that you pay money, get nothing in return...
July 19, 2007 at 5:46 am
But the last time I checked, you couldn't really log into the actual server (OS) with the SA account, even though the SA account has those privledges. You have to...
July 19, 2007 at 5:30 am
There are hundreds of domain registry companies in existance, most of them legit. They compete for business, sending out emails and snailmail about their services. The name and address information...
July 19, 2007 at 5:08 am
Unfortunately, I see events like this all the time. They're called Vendor Shows. It doesn't matter what industry you're in (software, hardware, rental, industrial, etc.), everyone holds a yearly event...
July 19, 2007 at 4:59 am
The problem with applying things through GPOs is that while many DBAs may have local Windows Admin permissions, rarely --if ever-- does a DBA have Domain Admin permissions or Admin...
July 18, 2007 at 8:59 am
To have jobs run across multiple servers, you don't need Admin access. You need a plain vanilla domain user (not domain admin) account for the SQL Services to use and...
July 17, 2007 at 7:47 am
Another instance when a DBA may have local admin rights on a box is when the DBA is responsible for "soft" server administration support. This has been the case in...
July 17, 2007 at 4:14 am
If you're not talking about a Database Restore, please be more specific in what you're trying to do.
July 16, 2007 at 4:53 am
Carsten,
We have a job (which I cannot post because I did not write it) which monitors our job execution times. It tracks the average run time of each job in...
July 16, 2007 at 4:51 am
Someone else suggested Computer Associate's Erwin diagram tool. I ditto this as it has a great feature I really enjoy using. Once you model your database, you can reverse engineer...
July 16, 2007 at 4:20 am
Ah. Okay. Sorry about the misinterpretation.
At least you got it working.
July 13, 2007 at 4:03 am
Ah-ha! That actually makes sense. And explains why it keeps resetting everytime I look at it.
Thanks, Crispin. I'm mailing out your cookie now. @=)
July 12, 2007 at 10:49 am
Viewing 15 posts - 9,571 through 9,585 (of 9,725 total)