Viewing 15 posts - 1 through 15 (of 42 total)
Here's the error he gets when executing the query
C:\projects\Dispatch_Partner.wsf (55, 6) Microsoft OLE DB Provider for SQL Server: Only text pointers are allowed
June 14, 2006 at 4:28 pm
This was a part of an 'Archiving' process. We had already move the data were were deleting over to our archive server, but needed to delete that data out of...
June 14, 2006 at 9:42 am
I'm deleting 6 out of 12 million, so I'm not truncating..
Can I loop the above statement or not?
June 13, 2006 at 4:21 pm
I see the issue with the phone value being used twice..
The datefr and dateto are
SET @DateFr = '5/11/2006 12:00:00AM'
SET @DateTo = '5/11/2006 11:59:59PM'
But it also accepts @DateFr = '5/11/2006' and...
June 7, 2006 at 1:07 pm
Figured it out!!
When the file was importing the table it created had a varchar8000 for each column (a very wide table).
WHen I modifed the column data types the data went...
June 6, 2006 at 5:05 pm
That's exactly what happened.
What did you do?
I'm thinking of uninstalling everything and starting from scratch..
May 19, 2006 at 4:42 pm
Thanks for the advice Anthony, I'll probably end up just wiping it and starting over.
Enjoy your weekend.
Susan
May 19, 2006 at 10:13 am
I was able to figure this one out..
You need to make sure you have your model database set to readonly mode.
Then all databases you restore automatically have that option...
May 18, 2006 at 5:43 pm
What is the timeout period for the applicatoin? Can you extend it?
You could also set up a trace and monitor the database while they are running the application.
THanks
Susan
May 18, 2006 at 4:55 pm
When I try and connect to the db I get the following error -
Error 927: Databaes 'dbname' cannot be opened. It is in the middle of a restore.
Any suggestions?
May 17, 2006 at 3:21 pm
I did have the undo files
restore database SusanB
from disk = 'd:\fullbackuptest\SusanBFullbackup.bak'
with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'
restore log susanb
from disk = 'd:\fullbackuptest\SusanBTranbackup.bak'
with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'
May 17, 2006 at 3:17 pm
Thanks for your help. It did the trick and doesn't look like such a mess..
Thanks again
Susan
May 12, 2006 at 9:40 am
I've made the modifications suggested, but am having trouble creating it.
I get the following error - Maybe I've been looking at it too long, but I don't see the...
May 11, 2006 at 3:00 pm
Lowell,
Can you provide me with an example of the split function you mentioned?
I don't see it in BOL
Thanks
Susan
May 11, 2006 at 12:29 pm
Viewing 15 posts - 1 through 15 (of 42 total)