grab the old SQL 2000 DBA Toolkit Part from this SSC Article:

http://www.sqlservercentral.com/articles/Advanced+Querying/sql2000dbatoolkitpart2/2362/

that's the one that added regular expressions encryption and more to SQL 2000 via extended procs.

when you got o...

John did you ever get all this workign the way you expected? between the DDL and the DML, you were testing for a lot of stuff, i was hoping to...

this gets you closer,and I left enough in there for you to do so you can understand the code.

you need to concatenat teh values, as well as accomodate teh counting...

there's a few assumptions here: that the column ID is always an integer, with no gaps.

the trick is to simply join the table against itself.

With MyCTE (ID,Status)

AS

(

SELECT '1','0' UNION...

SQLKnowItAll (8/21/2012)

---

Darn, I was...

thanks for catching that!

it was a copy paste blunder form something i adapted; i edited my post to yank that out;

ii think you want a near-endless while loop instead; something like this:

declare @i int,

@err varchar(100)

set @i=1

WHILE @i < 120

BEGIN

EXEC sp_WhoIsActive

@find_block_leaders...

GO cannot exist inside a procedure. it is a batch seperator, so when you compile it, the system thinks the procedure is finished..i would imagine if you try that code,...

BaldingLoopMan (8/21/2012)

---

nah. when i build a trace to say return everything w reads over 1000 i was hoping the trace had an export script to sql and maybe it would...

if the question is can a C program connect and use a SQL 2008R2 database, then yes; the ODBC drivers like the SQl Native Client can be used by a...

well the function dbo.DelimitedSplit8K can get you about 90% of the way there; you'd have to clean it up a bit.

you have to be able to find a delimiter in...

with SQL 7/2000, if you have a previous backup of the master database, you could restore it as a user database, and then manually script out / create the logins...

SQLKnowItAll (8/20/2012)

---

Is that relevant since the GRANT CREATE VIEW is at a database level, not a schema level? In which case I ask, did the OP do this on...

robert.gerald.taylor (8/20/2012)

---

I've got a schema (Reporting) that I want to grant CREATE, ALTER & DELETE permissions to a group; the T-SQL statements I did are:

GRANT ALTER ON SCHEMA::Reporting TO [abc\BI...

you can do this easily withe DelimitedSplit8K function here on SSC:

declare @val varchar(8000)

set @val='ABC DEF GHI JKL MNO 12 PQR'

select * from dbo.DelimitedSplit8K(@val,' ')

where ItemNumber=5

read the article here and...