Viewing 15 posts - 1,501 through 1,515 (of 1,790 total)
The following discussion covers this area pretty well. Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 1, 2003 at 6:59 am
This is probably a bad way to do this but, in a new T-SQL step create a table called something like CheckCount and populate that with old counts and new...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2003 at 8:37 am
When you say that you have no idea of who is running the trace, are you saying you can't see the connection when you run a sp_who2?
If you can see...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2003 at 8:10 am
Thanks Gentlemen. Allen_Cui - Yup, I'm in 7.0 land - but not for long.
If anyone does come up with any issues associated with this I would be interested to hear....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 28, 2003 at 6:34 am
Antares is very correct as I do this as well. The only db's that can't be restored / upgraded are the master and the msdb (learned this the hard way)....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 26, 2003 at 7:54 am
Steve,
I liked the article and can understand the constraints. I like the "brutally honest" review with the understanding that some reviews will not be posted because they are too harmful...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 24, 2003 at 12:36 pm
The collations you have on your client are the default installed in SQL Server setup. The problem you are experiencing (as you probably know) is that the server is configured...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 20, 2003 at 7:32 am
Since no one else has taken a stab at this I will....
I'm sure that you could build some flag in the AS400 DB System to flag the records prior...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2003 at 3:43 pm
No, you can jump right up to SP3. Make sure you read the readme notes and review the details before doing the actual upgrade.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2003 at 11:03 am
Antares was right on with this one. Attempting to register the dll didn't work as normal but replacing the dll and restarting did do the trick. Sorry for the delay...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2003 at 3:55 pm
I have never found a way to export the diagram directly from SQL Server but I have used Microsoft Visio to reverse engineer the database and it makes a great...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2003 at 8:23 am
Antares, Thanks for the idea. I will try that tonight after I stop services. I attempted once while the services were running and received an error stating that the file...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2003 at 10:32 am
Thanks. It was my plan as well to use the Perf Mon however having a few problems there. Will get them ironed out as I believe Antares post to http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=9956...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2003 at 9:06 am
Did anyone ever figure out why Task Manager incorrectly reflects the memory utilization for SQL when AWE is enabled? Curious. Thanks.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 12, 2003 at 2:20 pm
Does it clear up when you switch view to Detail and then back again to Taskpad? That will usually clear up the errors that show up on mine so it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2003 at 2:42 pm
Viewing 15 posts - 1,501 through 1,515 (of 1,790 total)