mw112009 (5/8/2013)

---

Lets make this simple.

select top 100 message from [surescripts_msg_import]

In this case the column message is of type text.

Can someone please help me write a select query that will retrieve...

my best guess is this will perform better, but it depends on the data;

also it looks like you are pulling from a view(v_MOTS_RELATED_CONTACT_DATA_N), which itself could be pulling in...

remind him about partial data recovery and point in time restores.

the little bit i read says NIGHTLY backups, and does not mention SQL Server point in time recoveries throughout the...

interesting, my knee jerk reaction is That I would still script out for disaster recovery, an d keep performing native backup and disaster recovery for SQL server regardless of the...

in a kind-of-similar thread, someone had a table full of varbinary(max) datatypes full of graphic images, without the filename/extension, so they couldn't figure out if the file was *.jpg, *.gif...

maybe you added a plugin for SSMS, and it's crashing on the close of SSMS, which causes the restart?

yes; the link i posted used the latest drivers that are compatible with opening all previous excel formats,

I've connected to pre-2007 xls, 2007 xlsx and 2010 xlsx spreadsheets with...

we are really on the same page;

i use traces a LOt, especially becasue i'm very familiar with it, and it's easy to create a trace template with profiler, and make...

i've read it's possible by doing something in the C:\Windows\SysWOW64\odbcad32.exe folder or something as well, but the method i'm mentioning is what i'm currently using;

glad you guys have a handle...

when i run sp_who2, i see a few rows that might be the "right" server side spid(14,29 and in my case), with the command "TRACE QUEUE TASK"

why...

i couldn't get your one example to work, because the data was malformed in your pasted example; it was missing two tags, so it was not valid xml; it was...

Ok the light came on with Marks' wildcard solution, thank you!

thanks, arthur, but that's kind of what's confusing me;

if i don't use the namespace, i get the desired results for the second item but not ht efirst; if i use...

nareshmsbi13 (5/8/2013)

---

I have execute my stored procedure using a select statement like

Exec SP where select * from view,wt is the finall out put of this query can some...

myself, specifically,...