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)

MarkusB (11/27/2008)

---

No, in your case if you want to restore everything until the last tlog backup (#28) you should start with the last full backup #25 and then add the...

GilaMonster (11/27/2008)

---

HanShi (11/27/2008)

---

When it is ON a lot of locking will occur and the performance falls down. We added a scheduled job to change the setting to ON just...

Recreating the clustered index will not move the actual table. It will only move the location of the clustered index. To move the table to a new location you have...

There was initially a 'bug' in SQL 2005 where the default of PAGE_LOCK was OFF. With SP2 this setting was corrected and set to default ON. So be sure that...

Did you refresh the list of jobs in SSMS? Try if restarting SSMS will solve the issue.

Are you enable to view the properties through a Remote Desktop (or physically) on...

In the WHERE clause of your query you define AND operator. That will show results of it matches results from all three views. If you need the result of every...