Hi and thanks for the article.

I also use EXCEPT to investigate why two queries don't return the same amount of rows.

with somerows (ListOfColumns)

(

/// first query

...

Hi,

good work, it would be nice if Microsoft could do something nice for annotations, it has been a pain since DTS.

I found this link that may be give us some...

Thanks for your explanations. I think I may use a piece of code rather than a stored procedure to do such a thing as I would more adequate for me...

Hi,

we had the same situation and we did the same. Some of them where using activex so it was abit of a challenge to makes them work again 🙂

Thanks for...

I think I would have detach and attach single file

EXEC sp_detach_db @dbname = 'pubs'

EXEC sp_attach_single_file_db @dbname = 'pubs',

@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

sp_attach_single_file_db attaches the...

Hello,

not sure if I have the full picture! Why would you like to pass a full table to a procedure, why not pass a tablename instead and open the table...