that worked......

Thanks... Linto

oops!!!!! no way......

Can I use

if exists(.....)

GOTO label1

else

GOTO label2

GO

label1:

ALTER PROC .....

GOTO endlabel

GO

label2:

CREATE PROC:

GO

endlabel:

GO

Whats your thoughts ??

We have to go through security department to get EXEC permissions on the stored procedure. In most cases, our Software Config Management group has permissions to run DDL statements. And...

For the second best practice, i would like to add

Give proper alignments or Indent while writing the joins to make the query more readable.

Linto

Why don't you write the code in the VB application to convert to numeric after reading from the text file and compare for the validity of data stored ??

Linto

I am getting page not found error while trying to see the columnists details.

Linto

You want to know only a developer point of view from Replication. What each term means like Subscriber, publisher etc. There are not much questions asked from Replication when i...

Whats the output of this ?

select count(distinct *) from XXXXX

Linto

Are you running the DTS package part of a NT job ?

Linto

Are you seeing in EM ?

We have an issue similiar to this. in the server the EM was showing users in the machine and in a remote machine it was...

what is the connection string you used from your VB program ?

Linto

We followed a method similiar to a C++ file header comments style where we will put all the information first, like the version information, creation information

but that contains the...

Have a look on this...

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1499

Linto

Are you telling that a table not having a clustered index is one of the WORST PRACTICES ???

Linto