Use a temp table instead of an IN statement and add a IDENTITY. You can JOIN both tables and use ORDER BY.

You cannot use sp_executesql and define the database as variable. You have to create a complete statement and use either sp_executesql or EXECUTE.

This works fine on my system:

CREATE PROCEDURE usp_CreateDatabase

...

Do your column names really contain "*" or are you about to create a old style LEFT JOIN?

Flo

Have a look for correct index usage and no scans for many rows. Here you can find a currently free download of...

Use an INNER JOIN or a CTE. Both should scale equal. Sub-queries may cause implicit cursors. Temp tables make no sense for one statement.

I would avoid NOLOCK if you are...

Did you check if your HD is full?

Did you check if your t-log file space is used or just needs to be shrink?

Did you try to shrink t-log files?

Did...

As Ken mentioned, if upgrade to SSE2k8 is an option you should do this and use the new table data-types from .Net side.

If you are not able to use SSE2k8...

Just another script:

http://www.sqlservercentral.com/scripts/anywhere/66000/

To search in all databases just add a loop through databases around the tables part.

Flo

Just tried on SQL Server 2000. ESCAPE works fine 😉

DECLARE @t TABLE (Txt VARCHAR(20))

INSERT INTO @t

SELECT 'AP_F_SC'

...

MS changed many things for UAC in Windows 7. This might be the reason why it doesn't work on Vista. However, I used SSE2k8 on Vista with no problems. Currently...

Hi

Numeric is equal to decimal. But did you have a look to data types MONEY/SMALLMONEY? 😉

Flo

In SQL Server 2000 your table needs any other unique column (e.g. a identity, guid or timestamp). If it doesn't have one of those a very slow WHILE loop seems...

You cannot use CONVERT to convert VARBINARY into a hexadecimal string.

Either use this function I also published here (as mentioned in the other script 😉 ):

http://www.sqlservercentral.com/scripts/Hex/65997/

Or, for better performance, use...

@Lynn: You really like lmgtfy?

😛

Have a look to my script. You have to insert them like this:

INSERT INTO AnyTable (VarBinaryColumn)

SELECT 0x12345

Flo