SQL Server Management Studio (SSMS) is the graphical mangement tool for SQL Server 2005. It includes a query tool.

SQL Server Query Analyzer (hopefully this is what you mean) is...

This works if you have SQL 2000 Enterprise Manager on the same computer.

In SSMS:

1. Click on "View" and select "Registered Servers"

2. R-click on "Database Engine" and select "Previously Registered Servers"

Your...

There are two ways I know of to accomplish this.

1. Grant permission at the schema level. If all stored procedures are in the same schema, like dbo, you can...

I've had the best luck saving DTS packages as .dts files then opening them in SQL 2005 SQL Server Management Studio and resaving them as legacy packages.

As for jobs, script...

Upgrade Advisor is designed to scan versions 7.0 and 2000, not SQL 2005. Version 9.0 is. SQL 2005.

Greg

Is SQL Server Agent running?

You could try writing a stored procedure that updates the password column in master.dbo.sysxlogins and giving the users permission to execute it. Look at master.dbo.sp_password for the update code....

Specifically, use the "Copy objects and data between SQL Server databases" option of the Import/Export Wizard or the Copy SQL Server Objects task in DTS Designer to retain indexes and...

It's a known bug. See http://support.microsoft.com/kb/938085/en-us.

Greg

Installing SQL Server 2005 will also install SQL Server Management Studio (SSMS), the replacement for Enterprise Manager. You'll also have the option to install SSIS when installing SQL 2005....

Granting SELECT on sysdtspackages in msdb will allow the developer to view the legacy packages.

Greg

I can't speak for all companies, but we use a separate CASE tool that has a data repository for logical modeling. We want something that is independent of SQL...

You should also use a UNC path rather than a mapped drive letter.

Greg

You can see the forum topic key by scrolling down on any forum subject page.

The titles do indicate number of posts. Editor Steve Jones listed them in this thread:...

What I do in this situation is import the flat file into a staging table with matching data types without doing any conversions, then use an Execute SQL task to...