Sounds like the service is still running. Check that. If so turn it off. Sounds like something did not get removed all the way.

Andrew SQLDBA

when you uninstalled SQL, did you happen to bounce the box? this would have finished the uninstall process by doing things stopping the services, and deleting the remaining files in...

What is it that you need?

Why are you installing SQL Server on the Boot partition? You should keep SQL Server and the OS on separate spindles.

Andrew SQLDBA

As many as needed. The key does not expire. The key is to verify that you are the owner of the data(cd, dvd, etc...) Like a car key and a...

I didn't think that diagram went with.

Thanks, I will do that.

It has been a long day already, and I need more coffee. My mind is not good.

Thanks

Andrew SQLDBA

I suggest reading the SQL Books Online. They are the very best resource when it comes to SQL Server.

I think the BOL tells all

Andrew SQLDBA

I just told you. There are no DTS Packages in SSIS. There is no migrating anything. You cannot simply "migrate" a DTS package to SQL 2005. You can re-write it...

Yes, and what is your question?

When you install SQL Server, the install copies a version of the environment that you use to manage SQL Server. It also installs a version...

SQL 2005 does not use DTS, SQL 2005 uses SSIS packages, they are totally different than DTS.

If you want samples of SSIS packages, they come with SQL Server 2005

Andrew SQLDBA

This is all that you need:

"Provider=SQLOLEDB;Data Source=<Your_Server_Name>;Initial Catalog=<Your_Database_Name>;UserId=<Your_Username>;Password=<Your_Password>;"

That is it, not good to have more than that.

Andrew SQLDBA

You cannot use both Windows Integration and SQL Authentication. Chose one or the other. And get rid of some of that other junk as well. Keep things simple.

All that you...

When using the Database Diagram app within SSMS, you can easily change a column's property to an Identity column.

Select the column in the table that you would like to modify

Press...

That is fine, what ever you use. You do not have change the table. I was only giving an example. You just have to make certain that the Key will...

You're correct, you did not design the table correctly. What would happen if you need to add one more productcode? The entire database and the front-end would break.

Anytime that you...

You can have up 32,767 databases per instance, and you can have 50 instances per server.

This is one of those questions, that the answer will be, "it depends"

It all depends...