Great thanks :hehe:

Answered found in another forum...thanks Brian.

***************************************************

Microsoft has created a new Knowledge Base article which covers transferring logins for SQL Server 2005. It includes an updated version of sp_help_revlogin:

How to transfer...

Yes, I do generate the code and then cut & paste into another window to execute...

The sql code using the REPLACE statement worked for what I need to do...

Thanks a...

YOU ARE SOOOO RIGHT!!! I was running via GRID, when switched to TEXT - it display as expected...

Thank you very much...Michelle

Thanks, however this puts the 'GO' on the SAME line as the sql statement...I want the 'GO' to be placed on a line by itself...

Instead of this:

exec my_proc 'Northwind','No' ...

Thank you all...I used the SED command and it all worked out fine...I would love to use it during my sql generation but I'm not sure where it would go:

SELECT...

Thank you very much...

Regards...Michelle

That makes sense...thanks...

I found the system table map here:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

Regards,

Michelle

Sysobjects - sysindexes joins on 'id'...which join should I use to include sysdatabases?

I still have not been able to get the correct results..I need the follow:

Dbname, Tblname, rowcnt

what I mean is, i am getting back the SAME TABLES list for each database but these tables are not actually in the database. how do i make the...

GREAT...thank you Noel.

Sorry, your message is posted in the SQL 2005 forum so I ASSUMED you were on that version ...

This may be helpful...

Where does SQL...

The Microsoft® Windows Vista™ Community Technology Preview (CTP) released today is the fourth in a series of early Windows Vista builds being released to an extensive technical community. The CTP...

Try this link:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

Hope it helps...Michelle

Try this...

A. Changing the compatibility level to SQL Server 7.0

The following example changes the compatibility level of the AdventureWorks database to 70.

EXEC sp_dbcmptlevel AdventureWorks, 70

GO

***********

60 = SQL Server 6.0

65 =...