Check your client network utility and also see how other PCs are connected to this server, such as named instance and port number. Keep trying.

Technically, I cannot see anything impossible. But you need to make sure to install all components of SQL Server, binary and databases, on local drives on each node, rather than...

Did you try this one?

UPDATE msdb..sysdtspackages SET owner = 'sa' WHERE name = 'PackageName'

Or you may try

DECLARE @sql VARCHAR(1000)

SELECT @sql = 'EXEC sp_reassign_dtspackageowner ''' + name + ''', ''' +...

I work in a company as a DBA with several thousand IT employees. I have both SQL admin and OS admin on each database server box.

One of our obligations is...

Here is my cent.

As far as I know, the profiler is the only built-in tool in SQL to do this task. You are right. We cannot afford running the profiler...

If the recovery mode of your database is set to Full, you may try to restore your database to the point just before you deleted your record.

Here is my cent.

Static or dynamic setting depends on applications on your server. If there is more than one application on your server and SQL Server is more important than...

You may change the account to start SQL Server services, such as use local system account. After accesing the SQL Server, you can reset your password.

Hopefully, the attached link will help.

http://support.microsoft.com/kb/890755

Here is my cent.

A DBA needs local administration privilege because he needs to do something on the OS level, such as

check what (application) eats up disk space;

check what (application) eats...

Agree with Jeff.:P

You may try the following script:

SELECT su.uid, su.name, so.name FROM sysusers su, sysobjects so WHERE su.uid = so.uid AND su.uid <> 1 AND su.name = 'userName'

How about update master..sysxlogins?

UPDATE master..sysxlogins SET dbid = ? WHERE ...

Backup over network is normally not recommended. The reasons are:

1. It is slower than backups on a local machine. The performance of this server is affected during the backup over...

You may try to break the connections between tables before making changes on data type.