From the MSDN site http://msdn.microsoft.com/en-us/library/ms345392.aspx I read the following:

An identical view of reporting data from all servers.

This assumes that all of the server instances are configured identically, for example, that...

That's recommended for the data-files of the TempDB... (also keep them the same size)

madhu.arda (1/2/2009)

---

Hi hanshi,

as you said We added a scheduled job to change the setting to ON just before the REORGANIZE of indexes and a job to set it back to...

Schedule this command in a job to delete all backups that are older then 2 days:

DECLARE @Date DateTime

SET @Date = GetDate() -2-- determine date of day before yesterday

EXECUTE master.dbo.xp_delete_file 0,...

Thanks for all the replies...

I've stopped my trace and created a new one, now with saving results to a file...

Are you sure the job is running during the weekend? SQL itself is not aware of the weekday when running a job.

Thanks for the reply Paresh.

But when I stop the trace, I guess I won't be able to see the events logged by the trace. Is there any possibility to see...

1. You need to test updates/service packs/hotfix on a test environment. The best scenario is when this test environment matches the production environment. This includes the SQL instance (incl. databases)...

SQL does not keep track of user actions. You can monitor this by setting up a trace with SQL Profiler and filter on the specified user. But be aware that...

Vince Lacoboni wrote a nice article about moving the system databases, including scripts to do it...

see http://www.sqlservercentral.com/articles/Administration/2605/

Here is what I tried to do once:

I added a new log-file on the new location and then make the original log-file empty with DBCC SHRINKFILE and the EMPTYFILE clause....

You can query a DMV that holds the rowcount for tables or count the rows from the table itself:

DECLARE @Rows Integer

-- query the DMV

SELECT

@Rows = row_count

FROM

Sys.dm_db_partition_stats

WHERE

object_id = object_id('{tablename}')

PRINT @Rows

-- or...

Lynn Pettis (11/26/2008)

---

Scenerio:

Day 1 ...

For my knowledge (no hands-on experience) :unsure: : You need enough space on both filegroups (on the old AND on the new location). The old location will eventually free up...

use the stored procedure: sp_change_users_login (see BOL for usage)