komal145 (5/11/2012)

---

I have 2 tables:

dbo.Doc_activity and dbo.event_type

CREATE TABLE [dbo].[Doc_Activity](

[Entry_Id] [int] NOT NULL,

[Event_Type_Id] [int] NOT NULL,

[Event_Value] [varchar](1023) NULL,

[Event_Time] [datetime] NOT NULL,

[User_Name_Event] [varchar](200) NULL,

[Last_Updated_User] [varchar](1023) NULL,

[Last_Updated] [datetime] NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[Event_Type](

[Event_Description]...

John Bates-251278 (5/11/2012)

---

Hi everyone,

I have configured CMS on my 2008 R2 server.

I have a CMS node containing several SQL 2005 server names.

I want to query info from those servers and...

off the top of my head this should do it

SELECT EmpCustom.EmpCustValue AS Team, Employee.Empfname + ' ' + WIP.WEmpLName AS Employee, WIP.WCltName AS Project, WIP.WSCDesc...

apostolis.karayiannis (5/11/2012)

---

Hello

My problem is the following:

I have a table (table A) that has several columns and each one of those columns has a description on the description property. I...

+1 lynn

the more info you give us and the clearer the question, the more likely you are to get a well formed and correct response.

look at it this way -...

elham_azizi_62 (9/27/2011)

---

hello all.

I use this script for export query result to existing dbf file :

insert into openrowset ('MSDASQL','Driver=Microsoft Visual FoxPro Driver; SourceType=DBF; SourceDB=c:\Temp','select * from dskwor00')

select * from test

but get...

there is an issue with the 64 bit installation of windows - it doesn't install the MSDASQL drivers

kirkm 55368 (5/7/2012)

---

Sure, thanks. But it's still being designed (badly!)

SELECT qryUC.Serial, qryUC.Title, qryUC.Artist, qryUC.Lyrics

FROM qryUC INNER JOIN tblAAA ON qryUC.Serial = tblAAA.Prefix

WHERE (((qryUC.Lyrics) Like "*climb*"));

So it's where instr(qryUC.Serial,tblAAA.Prefix) > 0.

I'm...

if forgot to add - there are certain limitations/ workarounds for the replace function with regards to length of the string being no more than 8000 characters (see books on...

tburk 5368 (5/10/2012)

---

I have an Access db that an employee created that had some VBA code in it that I need to convert to SQL. Not familiar with VBA and...

try going in to management studio options and in the query results section set the "maximum number of characters displayed in each column" to a figure higher than 256

not sure...

ok - maybe i wasn't too clear on that ... the contents of the SSIS package for sublan 1 (ie the actual backup package itself) - sorry

more info can be found here

http://connect.microsoft.com/SQLServer/feedback/details/715710/a-time-out-occurred-while-waiting-for-buffer-latch-type-3

the bottom post from the microsoft suppoort guy seems to indicate that you may have a slow IO issue - they suggest that when you...

panwar.jt (5/10/2012)

---

What is difference between "Sp_Helptext" and "generating script using right click on stored procedure and click on modify" script.

In few case both option giving different result set in case...

hmsanghavi (5/10/2012)

---

Hi Mike,

I had already tried as per you said but an error was occured that time.

Error was about date conversion because some data are not well formated in messagetimestamp...