Yes records were inserted... i verified that...

I will be happy to provide any more information in this regard....

In hurry to get my issue resolved i think i didnt provide enough information. My bad. I will try to make thing more clear now and provide scripts so that...

Thanks for looking into this... I will try to make it make clear....

Actual output:

Starting the Transaction.

Beginning to run the queries.

(0 rows affected)

Queries executed successfully.

Transaction committed successfully.

Expected output:

Starting the Transaction.

Beginning to...

I am running these SQLCMD script from SSMS, using SQLCMDSHELL....!!!

"deny" prevails over "grant" permissions... may be the user is added to some group with deny permissions...

sounds promising...

Thanks for the reply Steve. yah on changing the old password i can check the option but i dont see a reason for not being able to check the option...

I posted this in wrong header. Can the moderator move this to SQL server 2008.

Hi Manuni,

Can you figure out what all query/jobs were executing when the TEMDB went full? This will help you in locating the cause of the issue.

thanks people.... i got it what i was looking for... above two scripts are fine...

Thankx for your response.

Let me tell you my scenario.

I want to modify a Stored Procedure. I am not allowed to use ALTER. I have to DROP and CREATE the SPs....

In one scenario we had to copy some data from live DB to test DB. Since the table was having an identity column we were not able to make the...

And i thought i only didnt knew it 🙂

Notepad / word editors are acceptable... query editor/SSMS/third party tool not allowed...

Anyways sorry for not being able to convey what i am looking for (thought you people would understand)...