Viewing 15 posts - 3,556 through 3,570 (of 3,603 total)
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...
August 22, 2002 at 2:36 am
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...
August 22, 2002 at 1:35 am
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...
August 19, 2002 at 3:00 am
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...
August 15, 2002 at 10:00 am
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...
August 15, 2002 at 9:26 am
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...
August 15, 2002 at 1:45 am
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...
August 13, 2002 at 1:52 am
On a related subject, should Int IDENTITY columns be deprecated infavour of GUID columns?
August 1, 2002 at 9:58 am
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,...
July 31, 2002 at 10:19 am
How does ORACLE handle authentication?
July 11, 2002 at 10:15 am
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...
July 11, 2002 at 3:52 am
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...
July 2, 2002 at 6:08 am
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...
July 2, 2002 at 4:53 am
I haven't read this particular book, but my comment is that a book from a different discipline can provide a useful perspective that is applicable to the SQL discipline.
For example,...
July 2, 2002 at 3:30 am
I've done it using an ADO Stream object. See Wrox Press ADO 2.6 Programmer's Reference.
Once you have done it for one sort of file then you can do it...
July 1, 2002 at 1:57 am
Viewing 15 posts - 3,556 through 3,570 (of 3,603 total)