Use the ROWMODCTR Column in the sysindexes.

It maintains the number of records that have been changed (Inserted, Updated or deleted)

Use the Following Code to get a list of tables...

Congratulations !!!

Don't say it's ridiculous changes in the new Edition, it is an enhancement.

The info it presents the data about the Instance Activity is really good.

It Depends...

Let me give a explanation.

You have said you need to maintain security also across, then it would be good to implement schemas separately for group of tables..

It does not...

Assuming you have a "BKUP" Directory in Drive K and the backup files are with the extension .bak and you need to delete all files with .bak in that directory.

Create...

Hi,

Since this was not implemented by me earlier, I did try after looking at your question and found no issues on the subscriber when added I a new column. Transactional...

Most of the SAN's are Snapshot enabled check with with your Network...

Using Snapshot replication to move the Large Database of 90GB would cause...

Have you moved the only the systemresourcedb to another location from the default location?

If you have moved only the systemresourcedb and masterdb is still in the default location, then I...

Erin-489205 (10/16/2009)

---

I need to install a named instance with all components as well. Do I have to install the same service pack or can I leave it at service...

If you have noticed or not, when this issue occurs, the Processor usage is near 100 % but still nothing happens.

I had this situation some time back and remember...

Hi,

I know this is not the most optimum solution you can have for this scenario, may be you can use this for the time being.

TRUNCATE TABLE dbo.profiles_display ---- JUST TO...

Its my mistake that I have not seen that he posted in SQL Server 2005.

I just joined this site yesterday and thanks for letting me know, would not repeat...

I guess he can use PIVOT if the Version is SQL Server 2005 or higher and it would obviously not work if it is SQL Server 2000.

That was my intention...

Hey,

Are you using SQL Server 2000 or SQL 2005 ?

Because the solution depends on that.