[font="Verdana"]I agree with Jeffery :).. Setting SPN will solve the problem, coz the connection will use Kerberos authentication.[/font]

[font="Verdana"]You can enable agent xp's from SAC or through sp_configure.[/font]

[font="Verdana"]Checkout the script below

Kill all DB Connections/SPIDS[/font]

[font="Verdana"]In SQL Server you need to use % symbol

SELECT NAME from employee where name like '%kumar%'

The above query will return all the names from employee table which has kumar in...

[font="Verdana"]You can refer the below script too.

Kill all DB Connections/SPIDS[/font]

[font="Verdana"]Try the below code.

SELECT sum((size*8)/1024) as 'All db Size' from sys.master_files[/font]

[font="Verdana"]While doing inplace upgrade the only problem is you can't rollback easily.

Main is that take a backup of all your databases, logins.[/font]

[font="Verdana"]The article gives you the right direction.

Either you can save the DTS packages as legacy packages and import in the destination server or else open the package in designer and...

[font="Verdana"]Restart your sql agent service from configuration manager. If it failed to started, post back sqlagent.out file content.[/font]

[font="Verdana"]Why cant you try detach \ attach method. Try the steps below

*) Take the logins which has this db as default db

SELECT name from sys.syslogins where dbname='dbname'

*) Detach the db

*)...

[font="Verdana"]You may change the owner of the job to SQL Agent service account? If your service is running on Localsystem then change the owner to NT AUTHORITY \ SYSTEM.

Through which...

[font="Verdana"]Hi,

Do you have a public mail profile & default mail profile?? If not provide public privilege to the profile you have created and make it as default profile [/font]

[font="Verdana"]You can use sp_cycle_errorlog procedure in master database to recycle the errorlog, so that a new errorlog file name ERRORLOG will be generated and it will be used. Once this...

[font="Verdana"]Hi,

You can upgrade a database from lower version to higher version (i.e SQL 7 to SQL 2000) and its not possible to degrade it (i.e from SQL 2000 to SQL...

[font="Verdana"]YOu can check the link below to solve this problem

Database Mirroring Errors & Solutions[/font]