Not just errorlog, but also sqlagent.out. If you don't have a sqlagent.out, then that's probably the problem - the service is configured to write to a folder that doesn't...

I don't understand why you're using a Script task. I would use an Execute SQL task, with an expression built using the values from your columns. If this...

I searched the internet for "create solution in bids". If you do the same, you'll find...

Lowell (12/12/2011)

---

i'd recommend forgetting about putting the count in the table.

instead, create a view that is uesed to calculate the count based on a join; then the count is correct...

You need to create a new project and add the package to the project. Then you can use the button with the green triangle to run the package (or...

Yes, I think it's possible to do this with a trigger. But I'm not doing all your work for you. Have a try, and post back if you...

What have you tried so far?

John

Also, you're confusing the output parameters of the procedure with the result set. You can only use INSERT INTO to insert the result set - not the output parameters.

Try...

Another DBA? Triggers? Database restored?

John

No. From Books Online:

Note the "all". You need to grant permissions...

You could put the different types of table in different schemas and then grant permissions on the schemas.

John

Easier than that in SQL Server 2008 and above:

SELECT CAST(CURRENT_TIMESTAMP AS time)

John

Edit: just noticed the milliseconds requirement. You can either convert the above to varchar and chop off the...

If there's nothing to choose between two different syntaxes, I usually go for the ANSI standard. That's why I prefer <> in this case.

John

OK, this is the last time I'm going to ask. I know it's extra effort for you to prepare and post full DDL, INSERT statements and procedure definitions, but...

Yes, the conditions in the WHERE clause do appear to be mutually exclusive. Don't change the ANDs to ORs just for the sake of getting it working, though -...