Viewing 15 posts - 346 through 360 (of 816 total)
1. Does anyone have any suggestions about how they would resolve this?
You can generate the reports of the SPS which are being used mostly and then can start tuning them....
February 9, 2011 at 4:14 am
then i created a table:
create drop table importdata.guest.guesttable(guestname char(5))
this query will give syntax error. How can u use create and drop together?
February 9, 2011 at 1:04 am
can you tell me what exactly you were doing and which account you connected with SSMS?
February 9, 2011 at 12:30 am
you can start from here
http://www.sqlservercentral.com/articles/Administration/beginningsqlserverloginsandusers/1460/
and then keep exploring further
February 8, 2011 at 11:04 pm
have you checked if the user is orphaned user or not.
Run this
sp_change_users_login 'report'.
Please provide result.
February 8, 2011 at 9:59 pm
I am not able to find these function in master database!!!!!!
these will be available in individual user database and the user get the permission on these function as part of...
February 8, 2011 at 9:44 pm
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...
February 8, 2011 at 9:38 pm
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...
February 8, 2011 at 6:29 am
These are the very basic question and you should be explrong the answers by yourself instead of looking direct answer from someone.
February 8, 2011 at 2:57 am
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...
February 8, 2011 at 2:01 am
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.
February 8, 2011 at 12:53 am
if you connect your sql server from sqlcmd, are you getting any error:-
try with this syntax
sqlcmd -S yourservername -E
February 7, 2011 at 11:25 pm
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...
February 7, 2011 at 11:00 pm
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...
February 7, 2011 at 10:40 pm
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...
February 7, 2011 at 3:41 am
Viewing 15 posts - 346 through 360 (of 816 total)