Viewing 15 posts - 121 through 135 (of 782 total)
Leo.Miller (11/15/2011)
You need to use the PWDCOMPARE function:Reat this article: http://msdn.microsoft.com/en-us/library/dd822792.aspx
Use it like this,
SELECT name FROM sys.sql_logins
WHERE PWDCOMPARE('', password_hash) = 1
OR PWDCOMPARE('', password_hash, 1) = 1 ;
Cheers
Leo
Leo....Doesn't...
November 18, 2011 at 6:04 am
Oops...I thot correct answer should be 3,4,5
Didn't understand why it will round off when datatype is datetime.??
Regards,
Skybvi
November 18, 2011 at 5:40 am
@leo-2 & mark
The script provided by you not working.
Can you confirm it is working on your side?
Regards,
SKYBVI
November 17, 2011 at 1:57 pm
I would surely be a scientist, If i could perform that much calculations 😛
I sincerely hope that Rest of the QOD questions does'nt have calculations like this much...
Regards,
SKYBVI
November 16, 2011 at 6:02 am
You can look :-
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
that's default location of it, if you haven't changed it
Regards,
Sushant
November 8, 2011 at 5:55 am
ACinKC (10/26/2011)
October 26, 2011 at 7:27 am
Hi,
You can create a SSIS project with execute SQL task having the query to get the db name, last backup sizes, time, where it is backed up...
October 19, 2011 at 8:47 am
Can you tell us the output you would like to get based on the sample data you provided?
October 18, 2011 at 2:38 pm
Mad-Dog (10/18/2011)
i want only if colb = 'c:\1' while cola is 'first' and cola 'second' do not show the 'second'.
The first and second are actual values in your table or...
October 18, 2011 at 11:51 am
Your explanation is unclear,
If I get you right, you can add up constraint on your table.
--> To add constraint in your table design, to not insert duplicate values
you need to...
October 18, 2011 at 11:23 am
I guess the answer is wrong
It should be 1 and 2 only
beacuse only the constraint is violated,
the sql statement is terminated.
it doesn't look for other statements...
just goes out of loop.
Just...
October 17, 2011 at 7:07 am
Did you recently changed the password for the login?
This happens when you have an application running on hte system using the login credentials
and you change the password for the...
October 11, 2011 at 6:57 am
can you ping the remote server
and
also try to telnet the remote server
wat u get?
Regards,
Sushant
October 6, 2011 at 11:32 am
John Mitchell-245523 (10/6/2011)
October 6, 2011 at 8:34 am
cindyaz (10/6/2011)
check if you have a default database set for this login ID.
Yes, the default database is master.
Regards,
Sushant
October 6, 2011 at 8:32 am
Viewing 15 posts - 121 through 135 (of 782 total)