here's a basic example for connecting, does this help?

'form a command that waits longer than 30 seconds for testing

Dim sqlcmd As String...

Brandie Tarvin (5/10/2013)

---

j2cagle (5/10/2013)

---

Yes, Say Hey Kid, it's very similar to what you posted. I agree with a previous post...the real issue is in the VB code. However, I wanted...

it's just a syntax issue, where you are doubling up the SET and SELECT unnecessarily;

I think you want to simply assign the variable directly in the SELECT:

SELECT

...

in both vb6 or VB.Net, you can split the string into elements, and take the first element, or you can use the built in string functions.

'VB.Net: both return "ABC"

...

Here's another idea I had put together a simple Reporting grid app for our end users;

it's a windows app featuring the DevExpress Report Grid;

on the left, it has a list...

for SQL 2008, I know there's nothing in the GUI to help.

there's registry keys here which seem to allow you to enable it or disable it, but i don't remember...

well if you have a hardcoded list, you could modify it like this:

IF EXISTS(SELECT 1 FROM #Results

WHERE Login =...

here's a quick adaptation of another post i did for almost the same thing;

you'd need to tweak the mail settings, assuming you have db mail all set up:

--2005/08

IF (SELECT...

modified from a similar post on the same subject, i think this would do exactly what you are asking:

--Prevent access from SSMS

--drop TRIGGER logon_trigger_not_from_SSMS on all server

CREATE TRIGGER logon_trigger_not_from_SSMS...

that confirms my thoughts on permissions to the shared folder...

when you access any resource OUTSIDE of SQL server, like...

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