What happens when you failover? Is it again a SQL restart?

Let's say for eg., one of my job is running in a clustered instance and a failover happens...what will...

In case if you require to do a rollback of your database from SQL 2005 to SQL 2000 you can follow these tedious steps:

- Script out entire database including...

Hi Friends,

I got same problem today for one of our job after resetting password of a windows account. This job to run SSIS package was running fine till we changed...

Hi

Thanks. The issue was with port only. In last few days security team has updated e-trust anti virus and port 1433 was removed from the exception list of firewall....

Hi

Run this command to check if you have any error message related to your common database:

EXEC sp_readerrorlog 0, 1, 'Common' or

EXEC sp_readerrorlog 0, 1, 'suspect'

No, its native SSMS.exe only...

Hi Koti,

Can you try this

select * from sys.sysprocesses where spid >50 and dbid= dbid

Vijay,

Make sure your SQL Server 2005 is running. If you are trying from the local machine, then your SQL server is not running.

Goto services and start the SQL Service.

Vijay,

There is MS tool available called "MS SQL Server 2005 Upgrade Advisor". You can find it at

_http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

There is one more white paper for upgradation

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

But in your case its...

Can you try this? It worked for me...

USE [tempdb]

GO

Checkpoint

DBCC SHRINKFILE (N'tempdev' , 0, TRUNCATEONLY)

GO

Whenever a database is restored, its as good as you are deleting and creating a new one. Until unless its specified, default db owner will be the user from which...

Vijay,

If you are installing on Win XP machine, SQL Server 2005, Enterprise Edition won't work. You have to go for Dev Edition.

Hi

It looks like you have installed only client components of SQL 2005 and not SQL server database engine. What is your OS?

Also go to services and check if you...

Hi

First check what are the available instances on your machine and their respective status.

Most easier way to find it out would be

Start -> Programs -> MS SQL Server 2005 ->...

There is an undocumented sp: sp_msforeachdb. By using this you can run the script for all databases at once.

Eg:

EXEC sp_Msforeachdb "DBCC checkdb ('?')"

http://www.sqlservercentral.com/articles/Advanced+Querying/sp_msforeachdb/182/