DavidB (2/10/2009)

GilaMonster (2/10/2009)

If you want to...

GSquared (2/10/2009)

Greg Edwards (2/10/2009)

I can remember having to write "No" on my left shoulder before going in for...

I always forget about Application Roles. Probably a better a way to go if you can change the application to use it.

If they have rights to login to the server and access to the database there is no way I know of to keep them from using any ODBC/OLE DB aware...

Fairly simple:

IIF(DateDiff(DateInterval.Day, Date1, Date2) <= 1, "Y", "N")

Date1 should be the earlier date.

Sounds like a power builder issue. I don't think sql server has sp_pb60table and don't know what it would be. Based on my google search it looks like...

We are not currently running AV on our SQL Servers. This is something I have typically left up to the Network/System Admins with the caveat that, if AV is...

Here's a flow of how I would do it with what I know about SSIS now (meaning there may be a better way):

Package Variable for table name

Script Task that populates...

Can you share the data structures? See the links in my signature for some advice on how to.

Can you give some more details about how you are doing it? I believe what you are looking for is the ability to use a variable to set the...

If you post as Vladan requests and look at the articles linked in my signature it would be easier to provide you an answer.

I think you are looking for something...

I don't know of a combo box control available to Reporting Services. Maybe there is a third-party add-in. Typically reporting services reports don't have any editing capabilities so...

You can turn off replication of delete statements. Check out this blog post by Kendal Van Dyke:

http://kendalvandyke.blogspot.com/2008/12/hey-i-said-not-to-replicate-delete.html

You would need to limit the number of rows returned to the report in order to force it to be one page all the time.

If you just want to insure...

Maybe indexes on fk_PO_ID, ShipTo and fk_PO_ID, StoreNo?