That would be a valuable...

jim if you print the variable results, you'll see there's a quote in the wrong place.

"C:\Documents and Settings\jamesshaffer\My Documents\7-Zip\7za.exe" a "F:\mtv\secure\Construction\Access\All Database Backup\2012-Oct_Backup\"12-10-23.zip F:\mtv\secure\Construction\Access\CPAS

i've corrected your vbs code below to...

here's one way i've seen here on the forums to obfuscate a script that is to be deployed:

-- obfuscate a command to send to the client:

Declare @cmds Nvarchar(MAX)

Declare @obfoo varbinary(MAX)

--build...

forme, a CTE that pulls out the charindexes makes it easier for me to understand.

With tblDoc([FROM])

AS

(

SELECT 'John Doe1 <John.Doe1@abcd.com>' UNION ALL

SELECT 'John Doe2 <John.Doe2@abcd.com>' UNION ALL

SELECT 'John Doe3 <John.Doe3@abcd.com>' UNION...

http://webdesign.about.com/od/beginningtutorials/a/aa041700b.htm

code example:

<a href="mailto:firstEmail@email.com, SecondEmail@email.com?bcc=TheBlidRecipient@email.com& cc=thirdaddress@email.com&subject=heres%20The%20Info%20You%20Asked%20For"> Click me!</a>

tipping my hat to Sean, we travel in the same circles so often!

Thanks for the honorable mention, my friend!

you can do that either by checking the suser_name(), or comparing it agasint a table of permissions you create.

a...

Jim the single set of double quotes is an xp_cmdshell thing;there's only the classic extra-step work arounds.

the work around is to either use a variable, or create it in a...

jasona.work (10/22/2012)

---

My thanks to Lowell!

Using your Delete commands, plus adding one to delete from dbo.sysmail_mailitems, the DB is down to about 23GB from 133GB!

Set up an Agent job to run...

the http://www.ssmstoolspack.com/ is free and very popular among some of the psoters here.

it has a built in CRUD generator, so you can right click on a given table and it...

i've played with Microsoft.SqlServer.Management.Smo.Scripter that is part of the microsoft.sqlserver.managment.sdk.sfc ;

using that, you can tokenize any SQL statement.

i did it when i was playing with making my own SQL reformatter/prettifier,...

matt.gyton (10/22/2012)

---

Hi Lowell,

These are just standard SQL Agent Jobs being run on a schedule, so I'm assuming I could just change the default language setting for the login they are...

um, i don't think...

sanjay.dakolia (10/22/2012)

---

hi i am new to sql and i have the following problem

i am using the following query :

select cast (1157068800 as datetime)

but i am getting this error :

Msg 8115,...

you mean like resolving %appdata% or %path% from a command line or something like that?

yes, assuming you've enabled xp_cmdshell;

create table #Results (

ID int identity(1,1) NOT NULL,

TheOutput varchar(1000))

insert into #Results (TheOutput)

exec...