Viewing 15 posts - 4,726 through 4,740 (of 7,429 total)
Simple recovery - truncates the logifle when a checkpoint is issued to it. This means that the only reliable backups you can make and use are Full Backups. This also...
October 8, 2002 at 5:37 pm
Yes, I would play a bit with SQL Accounts on Server B because with SA you have now opened where just about anyone can get thru depending on if you...
October 8, 2002 at 5:29 pm
chrhedga, you are right there, I am used to doing this on 7 more than 2000.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
October 8, 2002 at 5:56 am
Could be but I have not run into this so cannot confirm. I will check around if anyone here has any ideas.
"Don't roll your eyes at me. I will tape...
October 8, 2002 at 5:55 am
Internal to SQL the answer is no. You will need to build that logic into the application itself to check for an error return code and message. Then you decide...
October 8, 2002 at 4:55 am
How did you define you linked server?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 8, 2002 at 4:53 am
You probably need to use sp_attach_single_file_db. If you use sp_attach_db it expects the information about the TL to be included, the other will build a new TL for the db.
"Don't...
October 8, 2002 at 4:52 am
First off memory is actually managed by the OS more so than SQL Server, even that memory allocated to SQL Server. The programmers most likely did not implement too much...
October 8, 2002 at 4:49 am
Other than that you may try to build a cursor and do character by character comparisons, but this will be extremly slow and quite possibly memory intensize. You are getting...
October 8, 2002 at 4:29 am
I agree with Robert, the SP itself should not cause issues but something could have stepped on the Winsock stack or the network configuration during the install.
"Don't roll your eyes...
October 8, 2002 at 4:25 am
1) Thru T-SQL you don't have an option. You can however use OSQL or ISQL with the output commands to send data to a text file, save the results in...
October 8, 2002 at 4:23 am
Ha ha, sorry about that I was reading crossed eyed apparently as I missed that section. However you may still have dumps going on that can explain what is happening....
October 8, 2002 at 3:59 am
chrhedga does go a little overboard there. All you actually need is
DECLARE @traceid int
EXEC sp_trace_create @traceid OUTPUT, 8
PRINT @traceid
The traceId will allow you to shut it off without bouncing the...
October 8, 2002 at 3:50 am
It may be in the middle of a commit transaction or rollback. Check the Current activity to see if their is any activity listed that would relate to this process....
October 8, 2002 at 3:42 am
Can you give us a bit of the procedure so we can understand what you may be doing wrong or happening that is due to design. Both when works and...
October 8, 2002 at 3:35 am
Viewing 15 posts - 4,726 through 4,740 (of 7,429 total)