Thanks a ton Shakti and Susheela

Great Rutter, and thanks.

Its working now.

Regards

Binu John

Tried this osql -SWIP-7ADLZFDZW -E -dmaster -Q"sp_msforeachdb @command1='print ?'"

But giving error like this for all databases.

Server: Msg 128, Level 15, State 1, Line 1

The name 'DBA' is not permitted in...

Try osql -SServerNameHere -E -dmaster -Q"sp_msforeachdb @command1='print "?"'"

C:\>osql -SWIP-7ADLZFDZW -E -dmaster -Q"sp_msforeachdb @command1="print '?'""

I tried your code only.WIP-7ADLZFDZW is the server name.

Regards

Binu John

Getting the samething!!

C:\>osql -SWIP-7ADLZFDZW -E -dmaster -Q"sp_msforeachdb @command1="print '?'""

usage: osql [-U login id] ...

Getting the samething!!

C:\>osql -SWIP-7ADLZFDZW -E -dmaster -Q"sp_msforeachdb @command1="print '?'""

usage: osql [-U login id] ...

Martin

Good Hunting.

Can we delete a file in Primary filegroup??

In BOL it is mentioned that a 'separate database connection required for each open browse cursor.Each connection counts toward the total number of user connections configured on an instance of...

One doubt please..

why cant you use the msdb database for your requirement.

sysjobsteps has all the scripts which were used to create the jobs?

I located at Bangalore,India.Is there any restriction for people outside US?

dont need C: and bk_db_pro should be shared

dbcc traceon(1807)

go

BACKUP DATABASE [northwind]

TO DISK = N'\\192.168.4.23\bk_db_pro\northwind'

with format

GO

Osama,

Try this

dbcc traceon(1807)

go

BACKUP DATABASE [northwind]

TO DISK = N'\\192.168.4.23\c:\bk_db_pro\northwind.bkp'

with format

GO

Rgds

Binu john

1.Right click on Instance and click on 'edit sql server registration properties'

2.Click on button 'use sql server authentication'

3.check box 'Always prompt for username and password.

4.click on Ok button

Next time you...

If you dont want to practise, use this

declare @cmd varchar(200) , @i bigint

set @i = 0

while 1 = 1

begin

set @cmd = 'drop database db' +cast (@i as varchar(50))

...