Viewing 15 posts - 4,456 through 4,470 (of 7,429 total)
Huh, I may be wrong, was just going back over the SQL BOL documentation and this is what I found
quote:
Important Microsoft®...
November 5, 2002 at 7:52 pm
When you have no connection try a tracert and see what happens. It may be trying to negotiate the initial handshake and is getting delayed along the path. Now the...
November 5, 2002 at 7:26 pm
quote:
In transactional replication, only changed (INSERT/UPDATE/DELETE) records are replicated to the subcriber database. Are you also trying to track deleted rows?...
November 5, 2002 at 7:22 pm
Sorry, I have never used Solomon. Would have to see their documentation to possibly offer any further help.
November 5, 2002 at 7:17 pm
No as something had to be preventing it. Maybe there is something to what Simon stated but how many times have you grown the file? I have several that are...
November 5, 2002 at 6:46 pm
That is what I remember was DBCC LOG, but if memory serves it is not very usefull or easy to figure out how to do what LogExplorer does with DBCC...
November 5, 2002 at 6:43 pm
quote:
Antares686,You wouldn't be able to post the table structure(generation script) for your tables used in the example below, would you?
November 5, 2002 at 6:40 pm
This is from another site
quote:
First of all, if possible, try not to stored images and other binary files in the SQL Server...
November 5, 2002 at 6:18 pm
Not sure but take a look here at XML_MaxWaitingTime, this may be XMLRADs version of CommandTimeout.
November 5, 2002 at 6:08 pm
This is a design thing usually, what exactly do you mean by keep data in a local database, it is usually an Access database, other vendor DB, or some other...
November 5, 2002 at 5:52 pm
Can I see an example of both the SPs? Also, is this on a seperate drive from log files and other data files, and what type of an Array is...
November 5, 2002 at 5:49 pm
If I remember correctly that is the message when using some Performance Monitor counters, I have not seen in Profiler. However I would think it was a popup and not...
November 5, 2002 at 5:35 pm
Sorry no SQL server on hand, but I believe there is a distribution agent table in the distribution database that references the job, that is how they link up. However,...
November 5, 2002 at 5:33 pm
No, I believe you asked this before. The reason is when a Full backup runs it marks the commited sections of the TL as inactive, and therefor they should be...
November 5, 2002 at 5:18 pm
Try this
update TEMPTESTDATA
set [Accession#] =
Right(RTrim(LAB_Accession_Num),2) + -- This will happen either way so do here to save some typing and add a little readability.
(
Case-- Didn't understand why you had...
November 5, 2002 at 5:07 pm
Viewing 15 posts - 4,456 through 4,470 (of 7,429 total)