It will depend on the output of the sig pad so the answer will be specific to the hardware and software provided by the vendor...I suggest you work with them.

One...

Mapping a Data Reader Source to an OLE DB Destination will give you the option to create the table in the destination...however other than column names and data types nothing...

Did you look at the Event Log? Please post the details of your findings so we may help you arrive at a solution.

It looks like it has been fixed.

Lionel E. Nzenze (3/11/2011)

---

Bad Idea..

So not send mail from a trigger.

Get the Trigger to write Whatever you want into some table.

Create a SQL Server Job to poll the said table...

Try this:

SELECT ...,

REPLACE(CONVERT(CHAR(10), CONVERT(DATETIME, [column_name]), 101), '/', '-') + ' ' + CONVERT(CHAR(12), CONVERT(DATETIME, [column_name]), 114) AS my_new_date,

...

FROM [some_table];

Edit: missed the replace, thanks bitbucket

You can do this with sc.exe:

http://technet.microsoft.com/en-us/library/bb490995.aspx

nico van niekerk (7/15/2008)

---

It IS important in which order columns are specified in a table. Having varchar columns preceding fixed-length columns place an undue burden on the server because of...

It can be done using a couple Windows Batch commands to accept the user's input into StdIn and by calling sqlcmd.exe to execute the SQL. I woudl recommend putting your...

Redesign your data model 🙂

Just kidding (not really)...boolean in SQL Server is implemented as the BIT data type where 0 = false. As an aside, NULLable bits are allowed too...

Anything with a Severity <= 10 will be treated as "informational" and will not affect batch execution (i.e. will not set @@error). It will however cause data to be sent...

Why did you post this in the SQL2008 forum? Try posting this in the SQL2005 forum.

WayneS might be on to something. Is your copy registered?

I just setup wzzip to test locally and here is what I get the first time I try running it:

C:\Program Files\WinZip>WZZIP.EXE...

Not that you won't get help here, but you may be better off posting this in an SSRS Forum: http://www.sqlservercentral.com/Forums/Group416.aspx

Ideally you should have the package use Windows Authentication to reach both SQL Servers and set the ProtectionLevel to DontSaveSensitive.

If that is not an option and you must use a...