June 13, 2010 at 10:31 am
We just had our ERP app vendor remotely move our SQL 2000 database to SQL 2008.
I had Query Analyzer (QA) and Enterprise Manager (EM) on my laptop and used them frequently.
QA - SQL statements, every day. 99.9% to review data, not updates or other changes.
EM - Check activity when performance slows, check who is active in the database.
Can the newer tools be downloaded from somewhere, and if so where?
I've been googling and also searching msdn.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
June 13, 2010 at 11:27 am
Management Studio
It's on the SQL dvd, you can install it from there onto your workstation. When you run through the installer, deselect the database engine and make sure that workstation tools is checked.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2010 at 2:03 pm
Do you think you could suggest an easier solution?
Just kidding. Thanks so much.
P.S. The person who moved the databases over and set up the maintenance said I needed to download Query Analyzer and it was a freebie - you already know what I encountered when I searched the internet.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
June 14, 2010 at 1:11 pm
Installed SQL Server Management Studio.
Have performed some tasks - Checking user logins and running some SQL commands.
I'm a happy camper.
Thanks again for the help.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
June 14, 2010 at 1:49 pm
Glad to hear it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply