What are you going to do with that text parameter after you have retrieved it?

Why not loop through the returned recordset and build up the string in your app and...

I DO name my constraints.

If SQL needs an index and there isn't one available it creates its own.

Sometimes an index is not appropriate but SQL may decide that it needs...

If all you want is a list of names simply run

SELECT Name FROM SysObjects WHERE TYPE='P'

P = Stored Procs

V = Views

TR = Triggers

If you want the actual definitions then try

SELECT...

I'm willing to be that the dbo user does not have an associated login.

Use sp_ChangeDbOwner '<<whatever login you want>>' within the database and the dbo user should be fine.

I often...

Although these utilities are useful I felt a chill go down my back the first time I saw one of these things working.

I used the toolkit from http://www.lostpasswords.com on NT...

I had a table called Tbl_CommenceDownload and noticed that I gained an index called tTbl_CommenceDownload.

I attempted to drop this and got the standard message that tells you that you are...

I thought this at first, however it is not as simple as the naming convention.

Not all system indices start __WA etc.

The way I get around it at present is to...

I started off with SQL 6.5 when Enterprise Manager was given the euphenism Enterprise Mangler therefore we always used TRANSACT SQL and explicitly named every constraint.

SQL also creates system indices...

Sorry about the lateness of this post.

I've found that @@ROWCOUNT gets its knickers in a twist with triggers.

INSERT DestinationTable(Fields)

SELECT Source.Fields

FROM SourceTable

WHERE Some Clause

SELECT @@ROWCOUNT

If DestinationTable has a trigger then @@ROWCOUNT...

On a related subject, should Int IDENTITY columns be deprecated infavour of GUID columns?

On the plus side their products tend to aim for usability.

On the downside is that their are some very powerful features in competitors products that I wish Microsoft would implement.

Also,...

How does ORACLE handle authentication?

We use WA for an Internet solution where no-one is automatically on the domain. This forces users to login to the internet application.

It is the Windows Group that is...

What are they using instead of Hungarian?

Considering the battle to get developers to adhere to standards I don't relish the idea of changing just because MS don't feel like it...

Thanks, but my SQL2K box uses OPENROWSET with parameters and it works.

My extracted code will not work even if I hard code the values of the parameters.

I've had to get...