Viewing 9 posts - 1 through 9 (of 9 total)
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...
October 13, 2003 at 7:04 am
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...
October 10, 2003 at 2:20 pm
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
October 10, 2003 at 1:53 pm
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,...
October 10, 2003 at 1:47 pm
...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...
October 10, 2003 at 1:32 pm
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...
October 10, 2003 at 1:09 pm
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...
October 10, 2003 at 1:03 pm
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...
October 10, 2003 at 12:10 pm
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. ...
October 8, 2003 at 9:25 am
Viewing 9 posts - 1 through 9 (of 9 total)