Matt Miller (12/23/2008)

---

If you're trying to delete "from the user interface" - you mean deleting rows from the Access interface in linked tables?

If you don't have primary keys set up...

Use Books on line and/or go to http://www.jumpstarttv.com. Here are the search results for Profiler at jumpstarttv

I'd recommend using SQL Profiler to see what command is being sent to the SQL Server. This can be found under the tools menu in SSMS. You can...

It is in dbo, which is usually the default for the database creator.

What did the table you are trying to delete from turn up as?

From BOL:

Beginning in SQL Server 2005, each object belongs to a database schema. A database schema is a distinct namespace that is separate from a database user. You can think...

Alter Table schema.table

Drop Constraint FK_Name

It is common to have tables that have multiple columns that create the uniqueness of row. Some SQL Server DBA's like to use these as composite primary keys, others...

Count me in with David in wondering what the business purpose for this might be. Updating 748 columns in multiple tables with n number of rows in 9 minutes...

There is no built-in method to handle this. Something like this would probably work, but would not handle holidays. The best way would use a dates table.

[font="Courier New"]--...

How are you choosing which is new product and which is old product? It looks random to me.

Is the table in the dbo shema or another schema?

Why must you return only 1 row at a time? Couldn't you return the data as a set and let the business layer or UI handle the looping? ...

In .NET the preferred way to handle this is to use the ToSTring function with a Format specified. Like this:

Now.ToString("yyyyMMddhhmmss")

First I'd get rid of the "*" in the delete as it is not necessary in SQL Server. Then I would look at permissions on the table for the...

Right side border on the left hand rectangle?