Viewing 15 posts - 46,111 through 46,125 (of 49,571 total)
Ah. I thought that might be the case. The corruption's in the system tables in MSDB and checkDB can't repair corruption in the system tables.
I know there's a way to...
June 24, 2008 at 7:38 am
Which one? Amazon lists well over 100 books on C# published by Wrox
Why do you recommend it?
June 24, 2008 at 7:30 am
MW (6/24/2008)
Would you mind if I ask you a few questions about thecredentials
Please post your questions in the certification forum.
June 24, 2008 at 7:26 am
Put the trace into a job on the prod server. It's not a heavy load providing you're writing to a drive that's separate from the data or log files.
The server-side...
June 24, 2008 at 7:22 am
Sorry, I don't understand what you're asking. Could you explain a bit more please?
June 24, 2008 at 7:04 am
Can you run a checkDB on it and post the errors you get?
DBCC CHECKDB ('MSDB') WITH NO_Infomsgs
June 24, 2008 at 7:00 am
Looks like you're trying to attach a SQL 2005 database to a SQL 2000 instance.
Adventure works is SQL 2005, hence can only be attached to SQL 2005 or higher.
June 24, 2008 at 6:15 am
Most likely it will be exactly the same.
A view is just a saved select statement. It doesn't store data at all. When you query a view you are just...
June 24, 2008 at 6:08 am
You mean, if you're lucky, your database comes out of suspect mode. Deleting a log file is like playing russian roulette with your database. You are asking for trouble.
See here...
June 24, 2008 at 6:02 am
I've worked extensivly with profiler in 2000 and 2005. It doesn't limit column width in either version.
Run the following query (substituting the correct table name) and see what it returns.
SELECT...
June 24, 2008 at 5:40 am
Michael Earl (6/24/2008)
I do not even think it is possible to see any performance degredation because there is too much in the plan cache.
Pre SP2 on SQL 2005...
June 24, 2008 at 5:32 am
Chris Hall (6/24/2008)
I'll try EXEC xp_servicecontrol 'QueryState', 'SQLServerAgent' too, Gail. That sounds less prone to unexpected name changes!
Maybe, maybe not. I think the second parameter is the service name...
June 24, 2008 at 5:25 am
If you save the profile trace to a file or table, the entire textdata is saved. If saving to a table, the column gets defined as type Text.
Are you only...
June 24, 2008 at 5:22 am
Performancewise, I wouldn't think much, if any. Accuracy wise however... Float's an inaccurate data type and prone to rounding errors. It's not something I'd like to store financial values in.
June 24, 2008 at 5:19 am
EXEC xp_servicecontrol 'QueryState', 'SQLServerAgent'
I don't know what permissions are required to run that though. I suspect fairly high.
June 24, 2008 at 5:17 am
Viewing 15 posts - 46,111 through 46,125 (of 49,571 total)