If I were a gambler, I'd bet you do not have sufficient disk space to complete the restore. A similar experience happened with a client of mine and boggled...

If your have Enterprise edt. and have access to Enterprise mgr, then make a back up file (.BAK) transfer the file to the new server and restore database from the...

Matt,

I've had to work similarly and the staging table approached worked best for me. It's very clear, easy to validate, and easy to clean up.

-Kel

because the UDF is going to be used in search functionality as a view, I need join on it. When I realized I needed to pass in a date,...

...which I can appreciate, and so they don't allow for the getdate() function in the udf ...BUT passing it in as a param should be allowed. Te return value...

Ugh! Yeah that's where I'm headed I guess, but selecting from a table, or a view that is created to house or supply, something that should be as easily...

You should be checking for errors after any insert, update or deletes and responding to them within you proc (rolling back the transaction) and responding to the calling procedure or...

Sarat

Is this what you're looking for? Just paste my code into QA replacing my table vars with your tables.

Hope this helps.

-kel

begin

declare @tblVendor table (VendorId INT IDENTITY,DataId INT )

declare...

Thanks for the input guys, I guess it's in part my opinion of small...1000's of rows is what I'm dealing with and for SQL server I consider that small. ...