The error means Asp.net is not a user in your SQL Server and the database used to run the application, in Win2003 you can add the Network Service account to...

I agree with Jeff I am looking but I will not apply for such position because it is not practical for one person to perform such tasks even in 100...

I don't think the GUI will tell you anything because most people don't know the index subsystem in SQL Server 2005 was all new, I have not installed it but...

Congratulations to you both and thanks for all the info.

If what I tell you did not work maybe you did not install the developer edition or Enterprise edition and you need at least DBO permissions for all databases you...

If you connect to the server the Profiler you access belong to that instance which means you are running Perfmon on that server.  It is very simple Management Studio tools...

It is in the data subfolder of the Microsoft SQL Server folder in the C drive of the server where SQL Server is located, you need admin level permissions in...

I don't know what is RDC but here are the correct steps, in the surface area configuration tool click on surface area configuration services and connection in the database engine window...

No there is some confusion here if your surface area configuration is correct you choose the server to connect to at the point of connection because I seldom connect to...

I have DBO permissions in our development server and I can connect to Profiler and Perfmon is under tools in Profiler, I must add I have the server registered so...

Yes but you need to use the surface area configuration tool to enable browser service, also change to both local and remote connection and to be safe change to both...

It is very easy with DateDiff you get the days and convert to month.  Try the link below for details. Hope this helps.

http://www.stanford.edu/~bsuter/sql-datecomputations.html

That is a very good question for 2005 make sure your backup use the C dirve if not the person need to create backup devices and restore in recovery mode...

Create a blank database with same name and do SELECT INTO statement of the 5-10 tables and the 5.  Then create the new tables as needed.

Yes your code split the columns into two but it was part of a mile long report so based on relevance to the customers data I will use what...