How long are these process individually taking(Step A,B,C)? Does ur Begin Tran and Commit TRAN includes all three steps?

Nice

Try the first method then, uninstalling by running ur SQL C.D or exe file

Maybe u r getting error column name not found when running those ALTER TABLE scripts. errors r usually self explanatory. If it says column name not found then maybe u...

R u trying to uninstall your SQL instance by running your .exe file by running set up through SQL 2005 CD or uninstalling by going to ADD/Remove programs in ur...

1)Change default port 1433 for SQL to some other port.

2)If possible use just windows authentication mode

3)Change password of sa login periodically

4)Make sure your xp_cmdshell is off

5)It will be...

seems like S.P is there. So if u run your IF EXISTS DROP statement, without the CREATE S.P. (your below statemnt), and then run the SELECT * FROM sysobjects, do...

You can get IO Statistics using SET STATISTICS IO and can then turn them on using SET STATISTICS IO ON and turn them off later on using

SET STATISTICS IO...

Maybe there is S.P with the same name under different schema? Hard to believe that SQL is lying.

What does this gives?

select * from sys.sysobjects where xtype = 'P' and name...

Is it a requirement to save your data in XML format or you have the option to save your data in any other way in SQL table. Say, as an...

Insert/Upates can amount to huge page splits if your fill factor for that non clustered index is low. Huge page splits causes excessive disk I/O and contribute to slow performance....

Yes u can encrypt/decrypt character column. But how are you planning to do that?

I haven't.......

Is it possible to post the stored procedure? Do both SQL instances have same service packs too?Thanks.

TO_friends (5/29/2009)

---

Hi to all,

I want to turn the following code which is from a .asp page, into a stored procedure so that it can be run by sql agent every...