Viewing 15 posts - 181 through 195 (of 659 total)
Its the same same cod which you can see here
http://technet.microsoft.com/en-us/library/bb838727.aspx
Users got permissions error.
January 27, 2009 at 1:48 pm
Have you tried exec above query.
I get an error
Msg 156, Level 15, State 1, Procedure sp_help_revlogin_specific_name, Line 23
Incorrect syntax near the keyword 'ELSE'.
when I clear that i get another errors.
January 27, 2009 at 9:40 am
What does this part do.
--(change SQL_ACCOUNT_NAME, --NT_ACCOUNT_NAME, PASSSWORD)
EXEC sp_addlinkedsrvlogin 'ADSI', False, 'SQL_ACCOUNT_NAME',
'NT_ACCOUNT_NAME', 'PASSWORD'
do i need to create sql login and also use my NT login there.
January 27, 2009 at 8:26 am
Yes, Please. Once if i can query that I can filter Logins used for sql server.
thanks
January 27, 2009 at 7:36 am
this query just pulls 3 million records but it runs for more than 2 hrs and then gives an error " temdb full" though i have 800GB free space.
January 23, 2009 at 10:31 am
This is the query which is causing issue.
select distinct e.code,startdate,enddate
into #f
from exams e
inner join
...
January 23, 2009 at 8:26 am
EXEC sp_spaceused gives me this result
database_name= tempdb
database_size= 318779.19 MB
unallocated space= 317417.23 MB
reserved= 1006096 KB
data= 877584 KB
index_size= 127944 KB
unused=...
January 23, 2009 at 7:06 am
But if i want to create a proxy for that non admin account, how wud i create a credential for that id unless i know that account pswd.
January 20, 2009 at 1:30 pm
What will be the windows id that is associated with proxy, can that be sysadmin or sql service account.
January 20, 2009 at 12:53 pm
Instead of doing this can i just change owner of the job to my login (sysadmin) and if i do it can they still run the job and also make...
January 20, 2009 at 12:25 pm
Already i have files for each month and when i chek file groups from properties of database I see seperate file for each month. is there a way i can...
January 19, 2009 at 7:38 pm
Thats a gud idea buti wud like to know something if tht is possible?
Can select files something like
" select files from the drive where not in temp table #t "...
January 19, 2009 at 7:33 pm
Can some one let me know if i can do this this kind of setup.
January 19, 2009 at 7:25 pm
SQLBOT (1/9/2009)
My only suggestion is to use Windows search for .mdf and .ldf and cross reference it with your output from select physical_name from...
January 18, 2009 at 3:37 pm
Viewing 15 posts - 181 through 195 (of 659 total)