You can not attach but you may be able to import data into the new database 7.0 from 2000. You may also generate scripts in 2000 to create table and...

Sheena,

I think I know what could be the issue. Good observation!

We just lost the network for 15 min and it took FOREVER for me to open Start->Run or a Folder...

You have to update your skills daily. Reading article of the day or answering QOD, going to the free seminars and user groups etc. And don't forget "Soft Skills" like project...

Sheena,

You say that the scripts are outputted to files. Are ANY of the files created when running under local admin account? Also describe your actions when you "run a script"....

Sheena,

To check if the account has rights to SQL Server or other folders, right-clcik on the folder name in Windows Explorer, Properties, Security Tab. Highlight the account name and see...

Thanks Alzdba and David!

We can not do ASP.NET because it is the existing ASP application. I do know that we can use ASP and ASP.NET pages in one app but...

Peter,

I think you problem could be because an entry was created in a Client Network Utility that does not reflect the true connection information or enabled protocol. For example, if...

Service account (SQL Server Startup Account)  needs Read /Write as Steve correctly said, but it is Read /Write for BOTH NTFS and Share Permissions. Share permissions would be called "Change"...

1. Post here the error message when starting EM.

2. Database that you created probably has you as an owner. Give other people permissions to access this database. Also, when...

I am not sure that you can change authentication type if the connection type and string are hard-coded.

Well, it happens to me too! Same thing, running traces. Moreover, if a report is run in the security context of read-only user for the user DB his TempDB rights...

Tracy,

You ARE THE BEST!

It sure works. The dropdown is really small, it is a part of the SAVE button if I would to describe it. I have never noticed it....

Sheena,

Tell us about this local admin account and how it was set to be a startup account for SQL Server service. It may be security issues both ways:

1. SQL Server:...

Do not forget bonuses, benefits etc.

Normally bonuses are counted for the surveys. Some of the benefits may be counted and some are not. So if your paycheck $60K and average...

I think this explains it:

http://msdn2.microsoft.com/en-us/library/ms254966.aspx

Debugging a CLR Assembly