For your first question, you can only return numeric values with the return keyword in your stored procedure. So, if you need to return something other than a number...

I had no idea such a stored procedure existed. We always stop replication and usually must remove the subscriber and publisher. This reafirms my belief that it is...

Have you tried SELECT SYSTEM_USER?

I know when I use this it gives my username where the other user_name() gives dbo for the same login.

Robert Marda

The VB programmers at my company are beginning to learn and set up something with .NET. Other than that I don't see any revolution nor assault. It appears...

I like this article. Even though you say it only touches the surface of the subject it goes into it enough to give me a better understanding of stored...

Those are the ones that prompted this question. I am specifically considering using DBCC TRACEON(3605) and DBCC TRACEON(1204). Are these the ones you use?

Robert Marda

Brian:

Thanks for the reference. I read the article and according to Microsoft the problem with slowness was fixed with SP3 which we are currently using (sorry for not mentioning...

I never had a problem with the identity columns. I think this is because we didn't use them a lot where I used to work (Telos Corporation).

Robert Marda

I like your article and believe that every table should have a primary key and that it won't hurt every table if it has a clustered index. Almost all...

no offense taken, I just wanted to clarify what I wrote to start this topic.

Robert Marda

I am in no way saying I dislike SQL Server. I enjoy most everything about SQL Server. I know part of the reason I enjoy DTS packages so...

I liked your article too. I always hear database people talk about normalization and denormalization and the various levels of normalization without really understanding what they are talking about....

Steve, you have a good point. Before getting into networking I didn't know a DBA existed. I had worked doing data entry and data conversion for the Post...

This next comment from me probably shows my newness of working with databases. I thought there would be more people that set out to be dba's and achieved that....

Perhaps I am not paranoid enough. In my previous position as a dba I never created a single stored procedure and knew nothing about creating dynamic SQL. I...