You can do it this way....

create proc abc123 as

exec('CREATE DEFAULT dftMyDefault AS ''0''')

Cheers,

Prakash

Even spid is showing status as sleeping sometimes it does working internally.

To verift check the master..sysprocesses table for that spid and the value for waitinresource column, is always changing

Prakash

I think you should use dynamic sql to achive this.

Secondly sysindexes is not always return correct result so do a select count(*) and probably use a union to join these...

Try after recompiling it again

secong think which can be done is put timestamp and see while running procedure internally which procedure is taking long.

Prakash

This is another way to do this.....

drop table abc

create table abc (id int, v1 int, v2 int)

insert into abc values (1,1,1)

insert into abc (id) values (2)

insert into abc (id,v2) values...

R u using transactions?

It happens because of transactions sometimes, You need to commit such transactions to avoid locks.

if you don't mind selecting non committed data then you can use

select...

Have you tried dynamic sql and global temp table combination for this??

Prakash

May be this:

Check the second tab after selecting the database backup and see if the database related details are available or not. If not then database backup has problem

Prakash

Check: BACKUP, BACKUP (described) in BOL

Prakash

Try connecting with ODBC dsn i got the same problem while using TCP/IP and Named pipe connections. Change the connection property to named pipe and see if it works....

Prakash

XP's are calling dll's to do the task....

Prakash

I think you are usind ADO to do this....

The problem comes because of two properties:

1: clintside connection property to be set for connection object

2: connectiontimeout needs to be set to...

Try removing sa as a user from the database and then run this command....

Prakash

A thought..

select * from sysprocesses and then for all spid's run dbcc inputbuffer for all spid's to find out what all is going on ur server/database

by killing some spid's may...

I think ur problem is related to this link....

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4653&FORUM_ID=65&CAT_ID=1&Topic_Title=Strange+behaviour%2E%2E%2E%2E%2E&Forum_Title=Performance+Tuning

Prakash