thanks all,

it helped me and I just added wait for delay 2 sec

CREATE TABLE [Test] (ID bit)

DECLARE @endDate datetime

SET @endDate = DATEADD(hh,1,GETDATE()) -- 1 hours from now

WHILE GETDATE() < @endDate

BEGIN

INSERT...

Thanks you,

I just want to create a new table and insert data in loop using a query from management studio and want to see while performing live migration, whether the...

So Import/Export is NOT meant for this kind of data refresh right?

Even if the setup shows the above message, I continued with the upgrade and it...

I do not want create tables in MASTER database and we have Admin database to keep the maintenance scripts.

So how to user your script by creating the tables in...

Does the script works with dbmail instaed of using the procedure sp_send_cdosysmail and CDOSYS objects?

thanks

Is the script works in SQL Server 2005 and using dbmail?

Thanks

Yes, it's not parsing and getting below errors:

Msg 102, Level 15, State 1, Procedure SP_GetBlockedInfo, Line 4

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Procedure SP_GetBlockedInfo, Line 25

Incorrect syntax...

I think you need to start with service pack two before service pack three and apply in server with reporting services before the server with the ReportServerDB and ReportServerTempDB because...

Could you please advice me..

thanks

Thanks,

I'm looking for a script which will include the logic to send an email when blocking occurs that includes the information such as what sessions were blocked and what session...

Thanks,

Yes, We can know the blocking by sp_who2 when blocking occurs. But not after the blocking. I...

Thanks so much,

Is there any script that looks for Blocking or dead lock every 5 mins?

and if that script detects any blocking or dead lock, it should send an email...

I selected the path by using browse option that exist in setup.

Yes. The folder structure exist already. Prior to the installation, I have created the folders. But still getting the...