Viewing 15 posts - 2,131 through 2,145 (of 2,462 total)
mdivk (2/25/2010)
:hehe::hehe::hehe:This is confusing me: the question is actually from a quiz. I just started learning Index. I don't understand the answer: obj_id = 869578136, index_id = 5
It means you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 3:24 am
Set Statistics IO ON
exec your Sp
Set Statistics IO OFF
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 3:19 am
in which column you have UNIQUE index ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 2:42 am
Thanks a lot.
below link help me
http://support.microsoft.com/kb/918992/
one thing i noticed that it encode the password in hexadecimal codes
while the normal script out method encode it in "unreadable" characters.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 1:07 am
CREATE LOGIN [MyLogin] WITH PASSWORD=N'ól?¨?&²??Ç[WÆ?$R¬sjµDúöÚ+pÇ', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [MyLogin] DISABLE
i just created a login in one server and pushed it in another
and when i try to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 12:44 am
can you do a test for me ?. just create a sql auth. login in one instance and migrate it to another one and then try to login with...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 12:13 am
Refresh means resetting the password with same characters.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 12:00 am
Bhuvnesh (3/3/2010)[hrbut when i tried to login with it in new instance ,it gave
"Login failed for user 'cxxxx'. (Microsoft SQL Server, Error: 18456) "
Here i am talking about sql...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 11:11 pm
DECLARE MC CURSOR READ_ONLY FOR
SELECT [Str]FROM #Windows_Auth_Orphan_User
OPEN MC
FETCH NEXT FROM MC INTO @cmd
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN TRY
PRINT @cmd
Execute (@cmd)
END...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 11:02 pm
J.D. Gonzalez (3/2/2010)
the insert to this table is blocking other process in other tables.
One questions, is this problem occuring from last couple of days or earlier was it running...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 7:44 am
There are chances that tables from that database involve in busy/heavy transactions.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 7:27 am
Greg Edwards-268690 (3/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 7:10 am
yes Grant is right.
Execution plan will give clear picture.
can you post table schema and execution plan?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 6:30 am
Hunterwood (3/2/2010)
declare @str varchar(200)
set @str = 'Apple, Banana,Orange, Pinapple, Lemon'
declare @result table (string varchar(100))
declare @start int
declare @end int
set @start = 1
set @end =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 6:16 am
parthi-1705 (3/3/2010)
SQL Server cannot create the mirroring endpoint, 'Mirroring'.ADDITIONAL INFORMATION:
----------------------------------------------------------------------------------
Create failed for Endpoint 'Mirroring'. (Microsoft.SqlServer.Smo)
TRy few things ;
1) Try to telnet your port for mirroring point.
2) Have you restarted...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 5:51 am
Viewing 15 posts - 2,131 through 2,145 (of 2,462 total)