Michelle-138172 (6/5/2013)

---

The main thing that puzzels me is why it only happens to web calling. There's never a problem running it in the Management Studio. My web dev guys can't...

so much of it depends on how it was presented, also;

As a veteran of more than a couple of posts here,

How well the question is phrased directly affects...

Michelle-138172 (6/5/2013)

---

Thanks for the advice! The thing is, all the tables involved in the proc are very static. The updates happen once a while and the proc usually works fine...

luis covered a couple important points i wanted to mention again: you'll need a new column for the ClientId in there somewhere.

we've done this in the past, and the way...

Michelle-138172 (6/5/2013)

---

I have a stored procedure that's called by a web application. Every now and then, the web call will time out for no apparent reason. But I can still...

glycere2000 (6/5/2013)

---

Can you say what other specifics you need? This particular function has been working well for years and only about couple of months i realized this has happened sporadically....

glycere2000 (6/5/2013)

---

I have a vb6 application and the database is housed on an SQL2000 server. My problem is that the vb6 function should increment the numeric form of the...

lsalih (6/5/2013)

---

I would like to ask for help with creating a stored procedure to generate below information:

1- A time stampt for record creation in a table, a time stamp shows...

sure, just run sqlcmd /? to see the defaults, but BOL for details:

sqlcmd /?

---

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\lizaguirre>sqlcmd /?

Microsoft (R) SQL Server Command...

this is syntactically correct, and what i think you were looking for:

now you will NOT use the procedure, but run this command instead.

MERGE INTO linked.dbo.student tgt

USING linked.dbo.studentdetails src

ON src.[StudentID] =...

run this command with the original/unaltered version of generate_merge , and copy and paste the results:

EXEC [dbo].[generate_merge]

@SrcDB = LINKEDCP,

@SrcSchema = dbo,

@SrcTable = student,

@TgtDB = LINKEDCP,

@TgtSchema = dbo,

@TgtTable = totalstudent,

@predicate =...

don't modify the procedure.

paste the results of the procedure for your table here.

we can help you modify the results,a nd you'll execute those modified results instead.

for example, after formatting, my...

i knew there was a dmv with this info (select * from sys.dm_exec_sessions) , but i had to google it myself to be sure;

this blog has a nice explanation and...

we don't need the source code in this case, we just need to see the exact command you are trying to execute, i think;

exec [generate_merge] 'CDM','dbo','tbstate','CDMLIVE','dbo','tbstate',@debug=1

the issue with the code...

oops yes i see that now on this page:

http://msdn.microsoft.com/en-us/library/cc645993.aspx