can't help that much yet;

you didn't mention any specific error you get back, and it might be nice to see the actual command you are using in sqlcmd to...

martin.kerr 34088 (5/13/2013)

---

Hi All,

I have managed to set up a linked server to a MySQL database and i want to update the MySQL database using a table within SQL Server....

http://www.ssmstoolspack.com/Download

if your SQL2008 is 64 bit, you must install the 64 bit ACE drivers; the JET driver is only valid for 32 bit, and it won't work on .xlsx files(or...

i think it's the usual; there's no easy way, but you can use the metadata to build your commands to add everyone to a deny everything group

something like this is...

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