You can generate the reports of the SPS which are being used mostly and then can start tuning them....

this query will give syntax error. How can u use create and drop together?

can you tell me what exactly you were doing and which account you connected with SSMS?

you can start from here

http://www.sqlservercentral.com/articles/Administration/beginningsqlserverloginsandusers/1460/

and then keep exploring further

have you checked if the user is orphaned user or not.

Run this

sp_change_users_login 'report'.

Please provide result.

these will be available in individual user database and the user get the permission on these function as part of...

schedule the restore job and in job step properties.....mention the location and name for output file.

Output file will be your log file for that perticular job in that specific...

1) Open SSMS--Secuirty--Logins

2) Right click on your required logins and select properties

3) Go in user mapping tab and you will see that login have public access on database. Uncheck the...

These are the very basic question and you should be explrong the answers by yourself instead of looking direct answer from someone.

Assuming that this linked server is connecting to sql server and thats what you have selected in 'server type' option.

The other thing would like to check the security tab...

can you remove the alias or change it to something else.

As well can you see your server properties and it have 'Allow remote connection....' as enabled.

if you connect your sql server from sqlcmd, are you getting any error:-

try with this syntax

sqlcmd -S yourservername -E

if you remember your old name then :-

1) open dos prompt (CMD)

2) type... sqlcmd -L > C:\serverlist.txt

3) Once it finish, go to your C drive and open serverlist.txt. You...

are you sure you connecting to correct server or no one changed the name of the server using 'sp_dropserver and sp_addserver'.

The problem could be that someone chaged the server...

There are 2 option :-

1) You can configure your server/localmachine(whever you running query) to Israel date time format.

OR

2) I am assuming if your server is configured with UTC then you...