hi,

thanks for ur answer, but

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\testing.xls;HDR=No;',

'SELECT * FROM [Sheet1$]')

SELECT * FROM msdb.dbo.sysjobs

it is giving the error like

Insert Error: Column name or number of supplied values does not...

Thanks for your great help its really helpful for me.

RESTORE DATABASE devlop

FROM DISK = 'C:\devlop\DatabaseOldBackup\devlop041202'

WITH move 'devlop_Data' to 'C:\RESTORETEST\devlop.mdf'

, MOVE 'devlop_Log' TO 'C:\RESTORETEST\devlop_log.LDF'

, MOVE 'devlop_log2' TO 'C:\RESTORETEST\devlop_log.LDF'

, MOVE...

for only general information,

hi to all,

how vbscript is useful for sqlserver. please provider some information.

how can i create a batch file to execute bunch of sql files, that accept inputs servername,database name.

please help me out.

hi,

try using output variable in usp_temp111

then use a variable in the below query(entered by you), store that output in that variable and update.

can u provide table schema

HI,

try using the linked server. u can get the result.

hi,

the problem was solved. i just restarted the sqlserver. before restart i have checked the configuration section ad hoc query option is enabled(but still it is giving...

Is sqlserver sql is ansi standard or ascii standard

thanks chirag,

ur post is useful to me. is there any way to add folders for sps,functions,triggers..etc.,

thanks.

hi all,

i need to integrate the SSMS With VSS Please provide usefull information.

thanks.

hi,

thanks for ur reply,

is it possible to call multiple script files using sqlcmd dynamically?

thanks.

HI,

I've configured log shipping. but restoration of log giving error.

Message:

Executed as user: INSTANCE\SYSTEM. The step failed.

hi,

thanks,

how can i remove the standby mode.