yould want to use something like this:OBJECTPROPERTY(OBJECT_ID(OBJNAME), 'IsSchemaBound')=0  means false, and OBJECTPROPERTY(OBJECT_ID(OBJNAME), 'IsSchemaBound')=1 means true

so i'd use something like this for the cursor:

select name from sysobjects where xtype='V' and OBJECTPROPERTY(OBJECT_ID(NAME), 'IsSchemaBound')=0...

It kind of sounds like he wants a limit for an application, to prevent more than 5 instances, instead of 5 users to the sql database.... am i right?

you'd still...

i was originally going to post about the wonders of sp_recompile, but it didn't work as expected. I thought it recompiled dependant objects as well, causing a chain reaction, but...

in SQL 2000 you can run sp_MSdependencies with no parameters to get the list of objects in a order of hierarchy, but it's not perfect if you have a circular ...

According to the Microsoft DLL search db (below)

   http://support.microsoft.com/dllhelp/default.aspx?dlltype=file&l=55&alpha=SQLSRV32.dll&S=1&x=9&y=9&start=150

File sqlsrv32.dll is released

   2000.85.1117.00 for XP sp2

   2000.85.1022.00 for Mdac2.8 or Windows 2003

same dll, two different...

here is a script i use to change collation for a db that is different than what i usually use.

note that the sample below has TOP 5 limitation to see...

SELECT

  SYSOBJECTS.NAME AS TBLNAME,

  SYSCOLUMNS.NAME AS COLNAME,

  TYPE_NAME(SYSCOLUMNS.XTYPE) AS DATATYPE

    FROM SYSOBJECTS

      INNER JOIN SYSCOLUMNS ON SYSOBJECTS.ID=SYSCOLUMNS.ID

    WHERE SYSOBJECTS.XTYPE='U'

    AND TYPE_NAME(SYSCOLUMNS.XTYPE) IN ('VARCHAR','NVARCHAR','CHAR','NCHAR')

    ORDER BY TBLNAME,COLNAME

i prefer to simply catch the results of sp_helptext PROCNAME into a recordset, and print hte results from that;

Sub a()

    Dim sql As String

    Dim rs5 As ADODB.Recordset

    Set rs5...

can't you just create a view and make the owner INFORMATION_SCHEMAS, so it shows up/is available everywhere? there's several articles and posts that mention doing that.

very handy Ged;

I added another selection below that you can use if you have stored procs or functions that have been renamed the same way; Thank you for writing something...

not fixing an issue like this could cost you your job. The great thing about posting here at SSC is you can build off of other's experience, and avoid the...

hadn't seen it before either; tested it and it works on my sqk2k machine:

SELECT name

FROM sysobjects

WHERE { fn LENGTH(name) } > 30

[edited] sure enough, it's in the BOL:

Functions for...

there's a famous full featured script that does exactly that;

http://vyaskn.tripod.com/code.htm#inserts

you'd do something like

EXEC sp_generate_inserts  'tbcounty' and get results like this:

or a subset:

EXEC sp_generate_inserts  'tbcounty' ,@from="from...

Sergei is right, but there is some extended stored procedures you can put on your sql 2000 server in order to use regular expressions in SQL 2000:

read this for all...

do you mean when you view it in Query analyzer?

QA is limited to displaying 8000 chars or 4000 nchars for a column value; so if you do "SELECT someNTextValue...