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...

so isn't your real problem getting all of the dateimes into a valid format and changing that column from varchar to datetime.

that would allow you to write decent SQL and...

can you post screenshots of the contents of subplan_1 ?

hmsanghavi (5/9/2012)

---

No. In this query, it will give me error. because there while doing join, it will consider all data including invalid data. And conversion of such data into date...

robert.hall (5/9/2012)

---

Thanks Mike,

Please excuse my ignorance, I am not very experienced with SQL Server, but have been tasked with setting up some Maintenance Plans.

Also, I have to wait for my...

genius - thank you

have you looked at the error message ?

....configured to allow remote connections. (provider: Named Pipes Provider<c/> error: 40 - Could not open a connection to SQL Server)). The......

check in ...

Eugene Elutin (5/8/2012)

---

I'm an atheist. Are...

those are the people that are logging in using "SA" ??? - so your trigger will mark the record as update by "SA" - (i'm not for one minurte advocating...

ggjjbb1983 (5/8/2012)

---

They can be updated manually, using a trigger for example, which fires on the insert. Also, i dont need the catalog updates to be real time.

The issue was,...