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

i don't think there's a limit on RAM;

the default setting is 2048 terabytes of ram as the default maximum setting until you change it to something less than what is...

Howard I have 2012, but I'm not sure where, specifically, you are talking about where the objects get bracketed by the quotename() function;

do you mean when you script an object?...

GabyYYZ (6/4/2013)

---

Ahhh...in our company, we consider naivete and blissful ignorance as sound DR...

sachin6139 (6/4/2013)

---

I have 2 select statements. One with NOLOCK hint and other without NOLOCK hint. I am getting different result sets. Rows are same but there order is different....

i had to add one more alias near the end to get this to parse correctly in SQL:

(also several columns are using reserved word names: xxxSTAFF.[File],xxxBanks.[Desc], xxxPayrollBankGroups.[Group])

...

FROM [xxxOES Absence 2006...