maybe even start with this script that can help you with your inventory and scripts.

Just add that part to use the new location.

http://www.sqlservercentral.com/Forums/FindPost368929.aspx

DMV sys.dm_db_index_usage_stats contains the usage info you need.

BIG REMARK from BOL:

The counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started. In addition, whenever a database...

If that occurs with our backup jobs, it's always an xcopy still trying to copy the file to a safe zone.

We examine why that copy is taking that...

I would first run :

dbcc updateusage ('yourdb') with count_rows

and re-inspect the figures after that.

Congratulations for the 10K barrier.

Thank you for your support, 10000...

euhm, no ... still on 32 bit xp :blush:

Does msdtc have a 64-bit version too, and is that the version you configured.

Did you configure both versions ?

as you know, the value null is not NULL !

declare @var varchar(128)

set @var = 'NULL'

if @var is null

begin

select @var, ' it is indeed null 1'

end

else

begin

select @var, ' it is...

It works on my laptops sql2000 (SP4) instance ..

begin tran

SELECT *

FROM [ws20098002\SQL2000PE].pubs.dbo.employee

commit tran

must be a config issue.

Can you doublecheck your dtc configuration and firewall...

is tcp\ip enabled for the instance ?

If you have ssms on that server, can you just start it.

Do not connect to the server yet!

so cancel the connect popup.

Then click "new query" and then connect using the...

- please provide sql2005 version info ( @@version )

- is this an upgraded db (from 7 or 2000) ?

(and did you perform post migration maintenance ?)

- can you run dbcc...

1) why are you using 4-part naming ?

You should just connect to the correct sql-instance and db and use two part naming.

2) did you enable and configure msdtc at the...

What's wrong with:

/* day 2 of the current month 00:00:00.000 */

select dateadd(dd,1,dateadd(mm, datediff(mm, 0, getdate()), 0))

/* if you need day 2 12 noon */

select dateadd(hh,36,dateadd(mm, datediff(mm, 0, getdate()), 0))...

IMO aligned indexes provide both performance and recovery advantages:

- performance: because the are physically split like their corresponding table, so the engine will only use the part needed by the...

you can use

return(@yourcode)

to provide an exit code for your sproc.

in your app you can capture this value using the first parameter @return_value.

e.g.

If sqlcmd.Parameters("@RETURN_VALUE").Value.ToString = "0" Then

'.....

...