Stored procedures that begin with xp are extended stored procedures e.g. dynamic-link libraries (DLLs) that SQL Server can dynamically load and execute.

Stored procedures that begin with dt_ are either for...

I have a set of stored procedures that define at trace that writes to a file. This is usually used for record SQL for performance problem investigation, but you should...

I may change my mind on UDFs.

I now believer "deny create function to public" is the most appropriate.

Public includes everyone except system adminstrators and does include users with ddl_admin or...

One alternative is to use a database replication tool. My experiences with database replication have been very bad, as the vendor tools from MS and Oracle seem to be...

As a further suggestion, as Microsoft would charge if you opened a problem, post to a Microsoft newsgroup. An MS person might be willing to open a problem for free...

Sergiy: Thanks for catching the typing error

"Do not put table access in stored procedures !"

should be

"Do not put table access in FUNCTIONS!"

The original version of MDAC version 2.6 that was installed with SQL server 2000 has a known bug with igonoring authentication settings.

See FIX: SQL Server ODBC Driver Ignores Authentication Setting

http://support.microsoft.com/kb/q279526/

You...

Sergiy is absolutely correct.

If a UDF needs the current date, pass the value as a parameter.

Here is a story regarding the use of UDFs that include table access.

About 2 years...

AHAH, at least we can now narrow down the problem to the text!

The clustered index (indid = 1) has reserved 34,363 pages and used 34,363 pages which is 265 Mb...

Are @intP1 and @intP2 parameters to the stored procedure ?

Are the values changed within the sp ?

If the answer to either question is true, that might be the cause.

For an...

If the columns are in the same table:

Update MyTable

set MyNewColumn = MyOldColumn

if the columns are in different tables:

Update MyNewTable

set MyNewColumn = (select MyOldColumn from MyOldTable where some criteria )

How familiar are you with DTS and Global Variables ?

I can send you an example DTS package that you could modify.

Here is the "driver" SQL code to call a DTS...

How very strange !!!

Just to confirm that the exact order of the steps were:

DBCC REINDEX (on the same index with a fill factor of 90)

go

DBCC updateusage ( DatabaseName, NotMyTable)

go

sp_spaceused NotMyTable

go

Some...

Sergiy, you are absolutely correct that the "LEFT OUTER JOIN" produces a different result compared to the "NOT IN"

I did not think about the case where the columns could be...

Yes, I did open the link but do not see how using a left outer join will help in those case where the join key in the dependent table is...