Here are two options for you. You can either use two single quotes to represent a single single quote, or you can use the char function insert the character....

Something like this should work for you:

declare @comp_id varchar(12)

declare @prodno varchar(12)

select @comp_id=comp_id,@prodno=prodno

...

There seems to be a number of ways to do move databases. From my simple test, everything came across fine, and DTS did it, no script that I could...

I'm assumming this error is because you have

QUOTED_IDENTIFIER set to ON. When QUOTED_IDENTIFIER is ON SQL thinks you are using double qoutes around identifiers. You have...

Exactly what permissions are missing?

I just ran a test of a simple database, with one table, and one user, where the user was granted select, insert, delete, and update permissions...

I don't have an example of how to script logins with sids on my website. But I found the script here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

Gregory Larsen, DBA

If you looking for SQL Server Examples...

How did you move the databases? I'm guessing you must have DTS'd them over, and not used a backup on 7.0 and a restore on 2000.

Also did when move...

Andy's right on with how to identify orphan users.

When you scripted users did you retain the SID's, if not your sysusers will not align with syslogins. Although as Andy...

Oh, now that I read what you want more closely, I'm not aware of a way to execute a proc and then start another one right way before the first...

Not sure exactly what you want.

I think this might work, although you might run into a character limitation size limit.

Of course this example only creates multiple tables based on data...

First I think I would consider using the SYSLOGINS table in master. Here is a query that might work for you. Let me know how it goes.

select...

Here is an example I promised related to more than one collating sequence per server.

Here is a query that shows the problem of having two database with different collating sequences...

You could try to build a pivot table query. Check out my pivot table examples on the website listed below. Hope they give you some ideas.

Gregory Larsen, DBA

If you...

quote:

---

Good afternoon,

I know there is a way to do this, but I seem to be having a brain cramp. I have to...

If you give the user db_ddladmin they can manager the defaults and types of database tables.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples