I would not do file operations in a trigger, but what you have looks like it will basically work.

I think the issue might be no permissions for SQL server to...

well, you can get the quick list for bcp (or sqlcmd, it's newer, updated replacement)

by running it from the command line window with the /? flag

bcp /?

sqlcmd /?

for the basic...

a linked server is a server object in master.sys.servers...so once you connect with SSMS, whether it's local or remote instance of SQL, you can create or use linked servers...

in that case, i'd change the name of the file to something that was generated to represent teh actual date, like this: (but why only for Wilson?)

--20130508-16-23-28-040.xml

SELECT REPLACE(CONVERT(VARCHAR(35),getdate(),112) + '-'...

is the question "how do i run this query every x minutes?"

the answer is to create a scheduled job in the SQL Server Agent, that reccurs every hour or whatever...

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