Viewing 15 posts - 24,391 through 24,405 (of 39,919 total)
It's likely causing issues. SQL allows many characters in object names, some of which cause issues in other products, or in things like XML documents.
April 16, 2009 at 11:13 am
I can't explain the registry, and honestly you're not supposed to muck in there. The SSMS tool reads the registry, but it may be reading a different place than you're...
April 16, 2009 at 10:39 am
This seems more like production database administrator to me. Keeping dbs up, tuning them, that's production work.
April 16, 2009 at 10:37 am
Gus has a great point. You can't expect anyone else to challenge a legal issue for you.
However if you want to challenge it, what's the likelihood that your DBA will...
April 16, 2009 at 10:29 am
Yes, however you want the virtuals on separate physical servers if this is a production server.
also , be sure you have good IO. If you are making two VMs and...
April 16, 2009 at 10:28 am
It looks like you're barely shrinking it. What's the file size on disk? I might try to shrink it closer to the 13 or 14GB
April 16, 2009 at 10:26 am
Chicken thread for the soul?
The Threadinator?
I suspect this one will never get caught.
April 16, 2009 at 10:23 am
There's always a security tab for 2005 instances. You select the server instance, right click, properties. The dialog that appears has choices on the left. Security is one of those.
April 16, 2009 at 10:19 am
I haven't seen it either, but it looks like security. Can you run a DIR from that server (using xp_cmdshell or the service account)?
also, backups to network drives are a...
April 16, 2009 at 10:15 am
You should have credit now. Let me know if that's not the case.
April 16, 2009 at 10:13 am
It's the recovery model, and you would find this in the database properties, option tab.
From T-SQL,
SELECT DATABASEPROPERTYEX('msdb','Recovery')
April 16, 2009 at 10:12 am
The VSTS tool is Red Gate's under license.
There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.
April 16, 2009 at 10:08 am
It's possible, but not necessarily. You'd have to check on what the load is on the server and if there are enough writes to cause a problem.
It's also a poor...
April 16, 2009 at 10:07 am
The key is dependent on which instance you are looking at. SSMS should read it from the registry, so I'm thinking that you're looking at the wrong key. Whatever is...
April 16, 2009 at 10:05 am
How are you checking this? The error log?
What is the setting in SSMS? All logins?
April 16, 2009 at 9:52 am
Viewing 15 posts - 24,391 through 24,405 (of 39,919 total)