I believe the Select INTO prior to the Index creation was suggested because you then don't have to use the resources involved in maintaining the index during your table population....

Cursors cause performance issues because of looping executing things 1 at a time and not using set based operations. I am unaware of a set based operation that will...

You could create a table that has a list of your databases, then query that table and use the results from that query to populate a cursor to loop through...

Yes, I do this all the time with visual studio. You can either deploy your entire project, or use cntl+click to select the reports you want to deploy then...

For that many tables across that many databases, it might not be a bad idea to handle this with either a DTS (sql 2000) or SSIS (2k5+) task.

I think you'll...

sorry I assumed that if you had a client, they would have had a project at some point in time or other...

Just change the below to a left Join.

FROM Clients...

Glad to be of service.

-Luke.

According to the following it would appear that Database mail only retries if it can't contact your SMTP server. It would appear that your issue with the multiple sends...

Are you sending them directly from the SQL server or via some other SMTP server on your network? Various SMTP servers have differing abilities for logging and such, but...

You need to make sure you're calling the replace function each time as it take 3 params...

param one, the string to check

param 2 the string to replace

param 3 the string...

Are you copying all of the data from one database to another, or just a few tables?

If it's every table you could just take a backup of db1 and restore...

If it doesn't matter what values from Columns 3 and 4 are returned, why return them at all?

Why not just select c1,c2 from mytable Group BY C1, C2 ?

Ok, so I'm lazy and when doing some ad hoc work on small tables I used to occasionally use Select * WHERE 1=2 to get a list of column names...

Have a look at the following code. You want the entire statement that creates the cleanedColumn column.

-Luke

CREATE TABLE #test (

id INT IDENTITY,

testval VARCHAR(15),

description VARCHAR(50)

)

INSERT INTO [#test]

SELECT 'test','no...

This question was already asked and answered here http://www.sqlservercentral.com/Forums/Topic583230-146-1.aspx.

Please do not cross post.

Thanks.

-Luke.