>> in the last few weeks

I suppose it started with installing SP4. Ask your DBA.

Under my observations, the first difference between SP3 and SP4 is the way how SQLServer displays processes...

Not possible.

"With encryption" - easy decrypting by dSQLRVD.

>>I was thinking of putting the desired SPs and UDFs in another DB on the same server where the main DB owner has...

I think your way is trace with events : Stored Procedures->SP:StmtCompleted, TSQL->SP:StmtCompleted.

Good Luck.

C2 Audit is not for such tasks as q

>>Anyone know a way to tell when the database size is automatically expanding?

Start Profiler, add events Database->Data File Auto Grow, Database-> Log File Auto Grow

Start Trace.

That's all.

Wanna sheduling - script...

Hi!

Notice that BuyListingID 2 does not join to SellListingID 10 because it is already used in the result set. Also, BuyListingID 3 does not join to SellListingID 10 or 11,...

Hi!

>>I have no idea why, but the cursor is faster.

I have idea

Look at master.dbo.sp_MsForeachtable - and you will find cursor.

It is not astonishing...

Hallo!

How do I  check equality of tables:

1. Simplest. COUNT(*) AND UNION

SELECT

  Count1 = (SELECT COUNT(*) FROM Server1.db1.dbo.Table1)

  ,Count2 = (SELECT COUNT(*) FROM Server2.db2.dbo.Table2)

  ,CountUnion = (

    SELECT COUNT(*) FROM

   ...

George.

With XP you have to use temp table, you cannot use table variable.

Hi!

You have to write a program using DMO.

If you do not want to write - look here: http://www.sqlservercentral.com/scripts/contributions/1151.asp

It's your part B and even more.

Good Luck!

Hi!

With SP you have to use temporary table. With XP also.

SP you can rewrite into UDF, XP - no way.

Try something like this:

DECLARE

  @timeout int

SELECT

  @timeout = 300

DECLARE ACur CURSOR LOCAL FAST_FORWARD READ_ONLY FOR

SELECT

    spid

  FROM

    sysprocesses

  WHERE

    DATEDIFF(s, last_batch, getdate()) > @Timeout

   AND spid> 25

You...

"Readers block writers"

Try SELECT * FROM ATable (TABLOCKX) and you lock your server forever.

You can write near each table (NOLOCK) or better write SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on...

I've also saw such "magic numbers". On different systems and different tables it was each time different.

>>Use ROWCOUNT

ROWCOUNT is not recommended in BOL, isn't it?

TOP looks preferable.

Hallo!

>>Error = [Microsoft][ODBC SQL Server Driver]>>String data, right truncation

SQL Server tells you that your table contains a string field that have lesser length than in your format file.

Check your table...