Viewing 15 posts - 5,476 through 5,490 (of 7,429 total)
quote:
comoletetion
Yeah, it is one of those technical terms that yells, wish I had a spell...
June 13, 2002 at 5:37 am
If should actually show better in most cases, but there are factors that can offset the increase. 1 is the type of RAM that was in the machine before and...
June 13, 2002 at 5:31 am
Cool I am glad you found your answer and I had not tried this myself so I have learned something too. Thanks.
"Don't roll your eyes at me. I will tape...
June 12, 2002 at 8:07 pm
Take a look at sp_executesql in BOL, it will show you how you can use it to do just this.
"Don't roll your eyes at me. I will tape them in...
June 12, 2002 at 8:05 pm
Ouch, but at least it has been corrected and you learned something. I had nimda on one of our boxes we thought was patched but found SP2 on Windows 2000...
June 12, 2002 at 7:29 pm
Two things, first do you have a full backup for that database, and second what is your recover model set to (properties of database in EM)? It should be full...
June 12, 2002 at 7:27 pm
This point has always confused me and if I am wrong from what I was taught please let me know I have never gotten a sure answer. My understanding is...
June 12, 2002 at 7:15 pm
Try
WHEN 5 THEN CAST(H.SharesHeldQty AS VARCHAR(50))
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 12, 2002 at 12:29 pm
I believe some of the info is saved also to the mmc for the SQL management console.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
June 12, 2002 at 12:24 pm
Under most circumstances it does not and you will need to run BACKUP LOG [db] WITH TRUNCATE_ONLY right before a full backup. Then you can issue DBCC SHRINKFILE to shrink...
June 12, 2002 at 12:12 pm
Maybe I am confused, the names are very easy to see how they relate directly to SQL from C#. Maybe I am misunderstanding what you are after. Can you explain...
June 12, 2002 at 6:27 am
Actually this sounds more like the ODBC tracing file. To disable or verify it, open the ODBC control panel, click "Tracing" tab.
"Don't roll your eyes at me. I will tape...
June 12, 2002 at 5:59 am
SO are you saying these are 2 different jobs? If so they should not conflict but depending on who gets to a datasource first it may block access from the...
June 12, 2002 at 5:54 am
Andy is right, the icon only represents the last run comoletetion state. So when it fails it will turn red, but a running log-reader will never change the icon so...
June 12, 2002 at 5:51 am
I forget but I do believe there is a counter for at least averages of those two items in PerfMon but I forget the titles.
"Don't roll your eyes at me....
June 11, 2002 at 6:45 pm
Viewing 15 posts - 5,476 through 5,490 (of 7,429 total)