Hello,

SQL Server 2005 is a current version and SQL Server 2005 exists only in CTP, not a released version. I would migrate data from MS ACCESS to SQL server 2005...

Theoretically adding an additional instance should not be reflected on the default instance.

You can add this user to db_datareader database role to read everything in the database, or if you would like the user just to review the schema but not data,...

J is correct.

As for SQL, the old one will work too for this particular case:

declare @I int

select @I = (select count(convert(varchar(2),ID)+Keyvalue) from #new

group by (convert(varchar(2),ID)+Keyvalue)

having count(convert(varchar(2),ID)+Keyvalue) >1)

set @I = @I-1

set...

Woo!!!

Charles Evans is completely right.

CLR, GAC etc.

I was at the 2008 Launch event and was listening to Bob F. presentation on Office 2007 in Sharepoint 2007 on Windows Server 2008...

Create a similar role in the second database. Add logins who are members of the role in the first database to this new role in the second database. Give this...

You may want to read:

http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/admincmp/75517c11.mspx?mfr=true

Chapter 11 - Migrating from Other Products to SQL Server

and scroll to the part:

Migrating DECODE Functions from Oracle to SQL Server

In this article they have a...

Andy,

Good Job with the article.

- DNS Aliases (your #8). They do help when moving 1 application database and not the whole server. When you have application aliases or host headers...

Steve,

I am going to implement one IP - One Port 80 for multiple IIS websites using Host Headers:

http://support.microsoft.com/kb/190008

HOW TO: Use Host Header Names to Host Multiple Sites from One IP...

If it is a third-party SW, I would notify your manager and escalate back to the vendor who needs to do something about that.

Request these IPs from your Network Admin and configure your Windows server in Advanced TCP/IP settings to accept these IPs - your network admin knows how to do that.

Once IPs...

I would not invest in tools with SQL server 2000.

You need to investigate Express Edition of 2005 and future editions of 2008.

For some reason nobody mentioned as solutions:

- cursors

- visual basic application

- junior developer selecting records one by one

- Oracle administrator using his Oracle PL-SQL

- outputting all records to...

Yes. There is another permission "ALTER SERVER STATE" , check out the link in my previous post. If you need more, maybe your sysadmin has to give you rights as...

Let me know if this helps:

GRANT VIEW SERVER STATE to YourLogin

http://msdn.microsoft.com/en-us/library/ms186717.aspx

ask your sysadmins to give you the above rights. At least you will be able to open the Activity...