Here is the completed stored procedure. I had problems with @SQLCmd variable type being VARCHAR, so changed it to NVARCHAR.

USE master

go

IF EXISTS (SELECT * FROM sysobjects

...

Karl,

"select * from sysobjects will automatically select from the database you're currently logged into.", this helped me a lot.

Thank you very much.

Ram

Is there a simple tutorial to setup a profiler session to do this?

Hi Siva,

What's the syntax of the SELECT.

Here are couple threads where similar problem was discussed,

http://www.dbforums.com/archive/index.php/t-929535.html

http://www.mcse.ms/archive81-2005-3-1512945.html

HTH

-R

Here is a good place to start,

SAN Integration Technologies

If you mean avoiding using CAST() or CONVERT(), they affect the performance especially when there are a lot of reads and lot of data. We are not planning on changing...

Hi John,

It makes sense now. We are in the process of setting up database redundancy through replication and we have two servers for hardware failure.

But out of curiosity, in case...

But if you have your data and log on RAID 5, then there shouldn't be any issues ?

Here is a part of the solution. I said part of the solution because, when the stored procedure is run in Query Analyzer, an output file is created. But when...

After applying SP1 to SQL 2005, the taskpad view (in SQL 2000 EM) is working fine.

Thank you, I received the scripts.

Here is my email address ram4tech at yahoo.com

I would change the setup if necessary to adapt to our environment.

Thank you Scorpion.

R

I used EM to setup snapshot replication. If we had more time to write scripts to setup the replication it would have been great.

Scorpion,

Can you show how to setup a...

Thank you all for your suggestions.

Steve, I was thinking about DTS option. How hard/easy it would be to write a DTS package and schedule it. Which would be advantageous between...

select field1, count(field1+field2), field2 from #temp

group by field1, field2

having count(field1+field2)>1

HTH