Thanks, I knew that but just wanted to confirm.

All of us thought that our DBA was making backups. But he wasn't!!!

May be we need a new DBA.....

We have a backup, but its about a month ago.

You cannot change the role of the sa user.

Disable SQL Auth. is for the authentication mode. If you use only Windows Authentication you cannot login with the sa.

You can create a shortcut to the file isqlw.exe (Query Analyzer) and sending as parameter the server and database.

isqlw -S ServerName -D DBName -U UserName -P Password

See "isqlw Utility" in BOL.

After opening the DTS like ankushac said, you have to save it on the server:

- Select Save as... from the Package menu

- Change the location to SQL Server

- Select...

When adding a SQL User to a role, the user must have acess to de database. If the user is a domain user, sp_addrolemember grants database access to the user,...

The MAC address is stored on the net_address column of the sysprocesses table.

This return the MAC address of the machine running the actual process:

use master

select hostname,...

Try to use [] instead.

BACKUP DATABASE [02] TO  DISK = N'C:\02.BAK'  WITH  INIT ,  NOUNLOAD, 

NAME = N'SW backup',  NOSKIP ,  STATS = 10,  NOFORMAT

- Which version of SQL do you have? Wich sql service pack does the server have?

- In sql 2k to set the source error rows, goto to the options tab...

If you process the 49500 row alone, does it give the same error?

Also, check that row to see if it doesn't have any special character in it.

Can you post the error message you are getting?

You can use Servers Alive (http://www.woodstone.nu/salive/), it's free for up to 10 alerts.

It can monitor disk space, services, processes, databases, ping servers, etc.

The USE instruction has to be in the same statement as the CREATE TABLE.

 

set @stmt = 'USE '+ @dbname + ' CREATE TABLE First(...

You have to wirte a dynamic query, like this:

declare @dbname varchar(25)

set @dbname='DatabaseName'

exec('use ' + @dbname +

' select .... all the instructions here .... ')

You...

No, you don't need to restart the server.

The service pack that you installed is the same of the server?

Can you connect to the AS via a client tool, i.e. pivot...