No, no suggestion but the same 'problem'.

Any pointers on this would be most appreciated.

HansLindgren

Greg Young (2/13/2008)

---

Doesn't anybody proof these questions? This is yet another example of where you have to guess what limitations the author had in mind. I tend to write UDFs...

This is no longer true in SQL Server 2005...

Regards,

Hans Lindgren

Ok, then you will have no problem there. But you should think about removing the domain user from the local administrators group..

Is your new server running SQL Server under a domain account or under LOCAL SYSTEM? Is the user System Admin?

Maybe you are not taking advantage of Instant File Initialization. You...

Good point!

Hi,

First of all; if you don't have thousands of sleeping connections you shouldn't worry about it.

Sleeping means that it is, in that specific instance, not using CPU resources (amybe...

It sounds like you have posted in the wrong Section.

If you mean DTS you should be in the SQL Server 2000 section. In SSBIDS you choose the name of your...

No. You would have to roll it your self using temporary objects...

The RESTORE DATABASE needs the parameter REPLACE to 'overwrite' an existing DB.

tymberwyld:

Why not use NULLIF( LTrim(RTrim(Prefix)) , '' ) instead of Case When LTrim(RTrim(Prefix)) = '' Then Null Else LTrim(RTrim(Prefix)) End As Prefix?...

A client of mine had the same problem. We only managed to solve it by altering Table Variables to Temp Tables.

Do you use Table Variables in your SPROC?

Regards,

Hans

I think you problem is all about blocking.

What is your insert code doing? Is it ONLY doing an INSERT INTO or is it also trying to select from the table...

There are some great scripts here on SqlServerCentral that you can use. There is one in particular that I used very frequently but it's now on an external HD somewhere.

Do...

Hi,

What do you think means by blocking? What the people in this thread has already said is that blocking is normal in a RDBMS system. Even if you have two...