Viewing 15 posts - 2,116 through 2,130 (of 2,463 total)
saranram_forum (5/11/2009)
I got error "A critical error occurred:instance failure" while i entered next button.
Which next button ? when u got this error ?
what were you trying to do this...
March 5, 2010 at 7:48 am
Chris-475469 (3/5/2010)
I don't want to update the secondary table with data from any rows which have a WIPCODE of P009 or P002.
UPDATE ctSET ct.shorttext =
CASE WHEN LEN(ct.shorttext) + LEN(i.shortnarrative)...
March 5, 2010 at 7:40 am
MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete...
March 5, 2010 at 7:24 am
dba-vb (3/3/2010)
what is the impact of storing the null values in a table
Read Below post
http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
You will find "three state logic" Even more than that
March 5, 2010 at 5:25 am
May be this helps you
select
t1.resource_type,
db_name(resource_database_id)as db_name,
t1.resource_associated_entity_id,
t1.request_mode as lock_requested,
t1.request_session_id as spid_of_waiter ,
t2.wait_duration_ms,
(select text from sys.dm_exec_requests as r --- get sql for waiter
cross apply sys.dm_exec_sql_text(r.sql_handle)
where r.session_id...
March 5, 2010 at 5:04 am
Have you checked the Error/Sql log for that interval of time?
March 5, 2010 at 2:13 am
keyun21 (3/4/2010)
Does any one know where can i find DETAIL documentation on how to configure LINKED server where I can gain knowledge on login authentication between two server on....??????
Read Below...
March 4, 2010 at 10:45 pm
DELETE FROM @T1 where desn IN(
SELECT desn FROM @t1
EXCEPT
SELECT desn FROM @t2)
March 4, 2010 at 5:52 am
itskumar2004 (3/3/2010)
execute sp_executesql @ExecSql,@ExecSql1,@ExecSql2,@ExecSql3,@ExecSql4,@ExecSql5,@ExecSql6,@ExecSql7,@Execsql8--print @ExecSql,@ExecSql1,@ExecSql2,@ExecSql3,@ExecSql4,@ExecSql5,@ExecSql6,@ExecSql7
i cant say where the exactly problem lies but you can see where the problem occuring by print "sp_executesql" , see if it can help...
March 4, 2010 at 5:24 am
i am not sure but it seems that your "Count" depends on "group by" but you sum includes some case statement which is creating difference/wrong data. Still i would say...
March 4, 2010 at 4:57 am
SELECT t.id1,t.id2,t.id3 FROM
( SELECT id1,id2,id3 ,ROW_NUMBER() OVER (PARTITION BY ID1
...
March 4, 2010 at 4:33 am
miss.delinda (3/3/2010)
I'm still want to maintain the constraint. Can you show me, how update statement look's like?
UNIQUE Constraint means unique value. how can you maintain uniqueness by inserting duplicate values...
March 4, 2010 at 4:14 am
Jack Corbett (2/23/2010)
you could use WHERE account LIKE @query + '%' and give the Optimizer the option to choosing an INDEX SEEK.
Can we have INDEX SEEK while using LIKE operator?:unsure:,...
March 4, 2010 at 4:06 am
Viewing 15 posts - 2,116 through 2,130 (of 2,463 total)