Viewing 15 posts - 23,881 through 23,895 (of 39,919 total)
Parag Mehta (5/19/2009)
I didn't understand the purpose of this article. These things existed in the last century as well 🙂
Not everyone has been using SQL Server for more than one...
May 19, 2009 at 7:45 am
A backup of the database does not affect the log file. You need to schedule a log backup separately.
You need to know what files are "changing" size, not which is...
May 18, 2009 at 10:29 pm
Write the query as you would if they were two tables in the same database and fully qualify both tables.
So include the database name and owner with the table. As...
May 18, 2009 at 5:08 pm
You need to better explain what happened and what you are doing.
What do you mean by user data in master? What did you do to put it there? And in...
May 18, 2009 at 5:03 pm
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
Viewing 15 posts - 23,881 through 23,895 (of 39,919 total)