declare

@NUMBER1 int,

@NUMBER2

int,

@NUMBER3

int

SELECT

@NUMBER1=(select COUNT

I really don't want to prevent you to look for a different solution, but this error is hardly happening because of other reason. Is your sql port changed (not 1433...

This is an authentication issue; the "null" indicates that the userid passed through the ODBC connection cannot be validated and a null is being passed to sql server instead the...

You have to move the logins first and then restore your user databases. To move logins you have to create 2 sps: sp_hexadecimal and sp_help_revlogin in master db; please follow...

Just an add-on: as there are cases when developers should not be members of db_owner role, sql 2005 has got a new db role that gives "execute backup" permission: db_backupoperator.

Jeff, please find the link here http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/oltp-performance-issues.mspx

Also I would appreciate if you could explain what "

Not being a smart guy here... was very interested in what you said..."

means actually....

Overuse of joins usually results in longer running queries and waistes system resources. You have to find out (I know it's not easy) which transactions are going to be run more...

select upper(left(last_name,1))+lower(substring(last_name,2,len(last_name)-1)) from table_name

use master

go

GRANT VIEW ANY DEFINITION TO ReportUser;

go

You cannot trobleshoot using all dmvs available, which could be a pain when designing the hardware for your sql installations for example.

Thank you heaps. I was dropping any hope to have an answer to this.

You cannot copy an online file; in order to move database files you have to detach it first. Check Securing Data and Log Files in BOL.

Check your connection string; how this could be: integrated security=true means win authentication and still you use sql authentications with sa as loginid; what is the error body and number...

right click (as you said) then "script stored procedure as"; there is not a "view code" option, if this is what you're looking for.

As you wrote under notification services, I assume you're on sql 2005.

select

st.[name] as TableName,sc.[name]...