The problem that I am running into is that we bought our software and don't have access to what the SQL is that is pulled for our forms. In this...

Would you mind explaining why you wouldn't recommend changing it to char(10). Thanks

It was the spacing issue. I corrected my data and now it works. Thanks you guys for the help.

It makes sense what you put, but I am getting the following error. Any ideas?

Invalid length parameter passed to the substring function.

Exactly, we paid all kinds of $$$ for this software and now, come to find out, it honestly just isn't up to par. we don't feel like feeding the CEO...

I completely understand what you are saying, but to do that, we would have to pay an addition $5000 just to have that done. I know that I can do...

I know that xp_cmdshell can only be executed by members of the sysadmin role, so I have granted user permissions to execute it. I also set up the SQL Server...

copy "C:\Documents and Settings\administrator\My Documents\Commander\autoprintpackinglabel.txt" "C:\Documents and Settings\administrator\My Documents\Commander\Scan"

this is what my batch file is. When my second table is updated, i need for this .txt file to be copied...

All that the batch file does is copy a completely empty .txt file from one folder on the c:\ drive to another folder on the same drive.

Here is the trigger that I am now using to update my second table. It works when I take out the EXEC statement. I also put my cmd into a...

I finally got my UPDATE to work by using the INSERTED table to get my data from. Now I have hit a snag because when I use the EXEC XP_CMDSHELL,...

I am not sure about the join, I'll try it out. I have taken out the EXEC part of the code and I still can't get it to work. I...

I'm sorry but I don't know what you mean by a table definition, and I can not find an error in SQL Server. The only error message I get if...

Here is what my trigger has evolved to. It now works. Honestly, I don't know whether an INSERT INTO would work here or not. This is the first trigger I...

I got rid of the TRUNCATE statement and the UPDATE statement is still getting me nothing. The statement is returning "0" rows and I don't understand why. When I run...