Sorry again. Here is the whole script.

DECLARE @DbData AS TABLE

(

id INT IDENTITY(1,1)

,SQlServername NVARCHAR(MAX)

,SQLInstanceName NVARCHAR(MAX)

,TCPPortNum INT

,DatabaseName NVARCHAR(MAX)

)

DECLARE @ServerInstanceName NVARCHAR(MAX)

DECLARE @DBName NVARCHAR(MAX)

DECLARE @SQLString NVARCHAR(MAX) = ''

DECLARE...

I am sorry but I forgot to mention that the servername has to be passed as a parameter to the openrowset query

DECLARE @SQLString1 NVARCHAR(MAX) = ''

DECLARE @SqlCreateLogin nvarchar(max)

/*

I assign...

Like some wise man quoted

"Love your job but not the people you work for"

That was really well said by the Editor. It is not good to play the blame game or bad mouth about ur previous employer at an interview.

Hey, I got the news letter mails today. :):D:)

I am getting the notifications for the forum entry though. I left my PM on and I just checked my mail. I get a prompt email but i cant figure...

The last mail I got was the database weekly update on Jan 19th. My spam folder does not contain any news letters from sqlservercentral.com.

I work 48+ hours a week. How? I do 8 hours shift Monday to Saturday. And sometimes I am on call on Sundays too. 8 hours is just on papers,...

Where is da party Steve? ....;):D:)

That's very creative.......sounds cool too....:):D:):D

Hope there r no die hard oracle fans out here......he he....

I think jus by solving QotDs is a very good way to prepare urself. I have encountered lots of trick questions in it and of course u need to have...

Did u any of u know this.

O - Object

R - Relational &

A - Analytical

C - Computing

L - Logical

E - Engine

regarding that box issue, i jus thought i could jus move to the top most floor. It would make realizing my resolution more easier..:):D:P

Hey, come on, if v do not encourage him, lets atleast c to that lets not discourage him......

Congratulations......this is brilliant.......keep this going and all the best.....