Thanks for your response Siva.

Sorry for asking such a silly questions but I am completely new to Clustering.

Could you please explain me in little detail how do we Connect...

Thanks a lot for response Jpotucek.

I need to know how do we reboot the node in cluster enviroment.Like from command propmt I can use following command

SHUTDOWN \\nodename \r

but how...

Please somebody help me with this.

Thanks,

SR

Hi Rob,

I am not much familiar with VB script.So I am not sure about using this in VB.But you can use OSQL command to run the job from batch as...

May be you can script  following stored procedure in batch file to run sql agent job.

USE msdb

EXEC sp_start_job @job_name = 'your sql agent job name'

Thanks,

SR

I think there shouln't be any comma between source and destination path.It should be something like this.

Set @SQLCMD = 'move \\.3\c$\ClientExports\Export.txt \\.10\d$\Test'

Thanks,

SR

If you see no information about isolation level when you execute DBCC USEROPTION that shows isolation level is default that is read commited.

Thanks,

SR

You can use set rowcount to delete duplicates for example to delete first record in you case

set rowcount 1

delete from tmPunchtimeSummary  where sEmployeeId='1234'.

This will delete only one record.

Thanks,

SR

I donno if this is what you are looking for.

ALTER TABLE Table_name ADD RouteID  INT IDENTITY.

Thanks,

SR

Try following query:

sp_MSforeachdb " select '?' as dbname,name from ?.dbo.sysobjects where xtype='U' and name='Table_name' "

Thanks,

SR

Try the following script.

sp_msforeachdb 'use ? execute sp_spaceused'

Thanks,

SR

Thanks a lot for your reply.I will really appreciate if you can explain me in little detail or guide me to the proper article about how primary keys and identity...

Thanks for your response david.

I typed capital but that doen't make any difference.

getting same error.

Thanks,

Sree

Thanks for your help Dylan.

Thanks,

Sree

Hi,

Remi thanks for responding.

According to scenario I can't delete all the tables.

Thanks,

Sree