Viewing 15 posts - 23,911 through 23,925 (of 39,944 total)
Check the command you are running in xp_cmdshell. Get that code and run it in a command prompt to see if it runs. Chances are there is something wrong with...
May 18, 2009 at 4:57 pm
What you should do is run Profiler against your EM session and determine which XP is causing the error. That will help you determine what is wrong.
May 18, 2009 at 4:56 pm
SQL Server doesn't export the entire database. You can
- back it up, if you need to transfer it somewhere.
- script out the schema (object definitions, permissions, keys, etc)
- export...
May 18, 2009 at 4:47 pm
I'd argue the DBA's job is to do what his boss wants, as long as it is not illegal. If someone is paying you to do a job, you should...
May 18, 2009 at 12:04 pm
I think there was a question on 2005 Enterprise, which was 50 (above the usual 16 in 2000)
May 18, 2009 at 12:00 pm
Change the EXEC() to SELECT, get the statements, check and see if they execute.
May 18, 2009 at 10:14 am
I'll pass. I'm certainly not going to install
51 on Enterprise
51 on standard (or 17 if it fails)
17 on Workgroup.
Perhaps Ed Vassie, with his automated install utility will try.
May 18, 2009 at 10:14 am
I know some people that have been using these for some time, in RAID. They are very happy with Fusion.
May 18, 2009 at 9:39 am
The sys user is a system user, used for system tables and databases. You are risking trashing your database if you remove these.
Information_schema is an ANSI standard. It doesn't hurt...
May 18, 2009 at 9:21 am
What does make me see red, though, is any attempt by the software manufacturer to make their licencing structure deliberately difficult to understand,
I agree. This is almost always a deliberate...
May 18, 2009 at 9:15 am
Mathew,
Thanks for the note, and I think you have a good business. 37 Signals does business like this, and I think there is some good value for many companies...
May 18, 2009 at 9:14 am
A couple things.
First, can you post the backup command?
Second, does this run interactively? If you run from SSMS?
Last, backups to remove drives (shares) are problematic, and flaky. The backup process...
May 18, 2009 at 9:00 am
It's harder to maintain things as they grow, and this is a good example. BOL is built by a team, and my guess is someone copied the documentation from 2005,...
May 18, 2009 at 8:57 am
TheSQLGuru has the advice I would give. You need to determine where your space is being taken up. We can't help you until you determine if this is an audit...
May 18, 2009 at 8:47 am
You can remove the guest user. DO NOT remove the others.
May 18, 2009 at 8:37 am
Viewing 15 posts - 23,911 through 23,925 (of 39,944 total)