I'm trying to use the tuning advisor to fix some VERY slow stored procs.
Unfortunately they contain code that creates temp tables and when I run the
analysis, it fails with the error
E000    exec cmt_common_measurements_org @quest_id=561        1    [Microsoft][SQL

Last week, we had an auditor came in to audit our SQL Server security
settings. He specifically checks if we set developers as sysadmin server
role on our development servers. Our data on dev servers are scrambled,
including name, phone, ssn, bank account numbers, addresses etc.

   I have just recently started having performance issues on my
biggest Sql Server.  Jobs that had been taking 10 minutes are now
taking 90 minutes to complete.  At first I thought it might be a CPU
issue but when I monitor the usage on the server it rarely goes above

I am using SQL Server 2005
I have a full backup from midnight and a differential backup from 8 am.
I restored the full backup from midnight to a new database, say called
NewDB.

I am VERY new at SQL and trying to fix code to get something to work.
I keep getting this message?  Does anyone know what I need to do to
problem solve?
Thanks -

.. on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.

Someone else asked this and got referred to a Discussion that didn't
address the question so I'm going to ask again.
If you have a column that typically is going to be less than 12
characters in length, the obvious choice would be to use a

I have a database on a SQL Server 2005 Express. I want to copy this
database along with all its data into another server which is a SQL
Server 2005 (full edition). I can't seem to figure out an easy way to
do this. I tried backing up and restoring database but it told me that

We have problem with SQL Server 2000 : there something in the
application that cause the server out of memory. I suspect this is
because an inefficient and heavy query.
In Oracle we have TOP SQL from Enterprise Manager to see what query

I have a sql script that I use to reorganize indexes with more than 5%
fragmentation and rebuild indexes (ONLINE OFF) with more than 30%
fragmentation. On running this, I found that, the script was working fine but
every iteration updated about 550 indexes. After a run, if I ...

how frequent you guy verify database backup from tape ?
What is the procedure? do you restore from tape and attach to database
Cheers,

Hi, I am going to start as the only DBA in a company, very nervous, since
there is no peer at the company and no transition from the job, could someone
told me when I start, what would be the initial steps to take for starting? I
read some article about daily activities on the ...

Is it possible to specify a server in a backup script & likewise specify a
restore to a different server e.g.
BACKUP DATABASE 'LIVESERVER..' + @DBName
    TO DISK = @Path

My SQL Server Log shows a ton of records starting up two different
databases.  One of them was an old test database of mine, so I deleted it.
However, the other is a production database, recovery mode set to simple.
Can someone tell me why these particular databases were / are ...

I recently took responsibility for a sharepoint 2003 server & corresponding
SQL 2000 server.  The backups are working through a maintenance plan, but
I'd like to implement a richer plan and am having difficulties developing
the best approach.  understand I've not done much care & ...