the import/export wizard is just an application. once you have a user name/password so you can loginto SQL server, you can use...

excellent! I'm glad you found this thread and the helpful procedure!

in a bat/cmd file or command prompt, you can get the computer name from the variable %computername%

echo %computername%

so you can build a script with that...does that help?

edit

also, if...

well there is two pieces of the puzzle.

IF the linked server is using dynamic ports, you need to have the SQl Browser Service running on the linked server. If it's...

a post here on SSC says one person thinks that error is related to this:

http://www.sqlservercentral.com/Forums/FindPost1168084.aspx

The first error message actually looks a lot like the dynamic packet sizing (autotuning) in Windows...

you could build the queries you want to execute for all tables meeting your criteria.

if the table has a value in the UpdateBy column, are you trying to set...

the error is pretty straight forward; it could not find the table in the database. maybe when you abstracted it out, you hid the issue.

do you Really have a database...

sp_trace_getdata is used by SQL Profiler to read it's trace and return the results to the SQL Profiler GUI/application;

SQL Profiler is definitely known to have an impact on SQL server...it...

Sreejith Sreedharan (10/23/2012)

---

Thanks for the email. Based on my searches thats what I came across too. Do you know of any one who has created this as CLR function? May...

Looks like you'll have to use a CLR routine.

i grabbed this function in vb.net from Google, you'd have to convert it to a CLR function from there.

source:http://stackoverflow.com/questions/7515164/visual-basic-2010-hmac-sha1

edit: here's the converted...

Sreejith Sreedharan (10/23/2012)

---

Has any one encrypted data using HMAC-SHA1 or HMAC-SHA256 encryption method. I need this done for the current project that I am working and am unable to find...

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