CREATE TABLE t1 (

c1 CHAR(1),

c2 INT)

GO

INSERT INTO t1

VALUES ('A',10)

INSERT INTO t1

VALUES ('A',22)

INSERT INTO t1

VALUES ...

Your application(s) has DROP TABLE permission???

Scary.

You can't downgrade from Enterprise to Standard edition. You need to remove the enterprise edition and then install standard. The same for the upgrade to 2005. You cannot upgrade from...

The location for Backup Devices is stored in the sysdevices table in master. But instead of updating this table you better recreate them in the new location.

If you like to...

There are several third-paerty tools available for this but. Try Lumigent LogExplorer , Red-Gate Log Rescue or ApexSqlLog. Not sure about all of them, but I think you can downoad...

I don't think you can change the database owner of a mirror database. The mirror is in a non-recovered state so you can't run any statements against it.

You could change...

Daniel,

which check which roles your users are a member of. By default sysadmins can access any object in any database and db_owners can access any object within the database. Deny...

Configuration Manager is a client tool like...

It won't help you now, but SQL 2008 implements the possibility to pass a table paramter to a stored procedure.

They are service accounts you can find more information about them and which permission they need here:

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

and

http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/

Markus

You can find maintenance plan specific information in msdb.dbo.sysdbmaintplan_history. But since a maintenace plan results in one or more jobs you can also use msdb.dbo.sysjobhistory.

Markus

Not sure if this applies to your case but I once had a situation with a cluster, there after removing the Builtin/admins the cluster won't start anymore. I had to...

First thing I'd like to know is what are the autogrowth settings for this database.

Then check what all this new space is used for. Is it just empty space or...

Where do you see those errors?

In the eventviewer or somewhere else.

From my experience when you start the SQLH2 Performance Collector, for each counter one or more entries show in...

Withoput having your extended procedure it's almost impossible to tell what you can do and how. But if you're just interested in information about backups like files, size, date etc....