Right click on the SQL Server in SSMS and select properties.

In the properties dialog, you have multiple pages in the left page, select security page.

It will display the current...

That query will not work. Why and other info, its better you read Books Online.

Use have many options to work with of which the below is 2 ways.

select e.entID, e.entShortName,...

Would like to reiterate what John said, more information please.

dmoldovan (12/1/2009)

---

Bru Medishetty (12/1/2009)

---

dmoldovan (11/30/2009)

---

Also if you do bulk data import / inserts, change the recovery model to "bulk logged" or "simple". BOL will guide you through the steps you...

I tested and confirmed that.

You either...

Use this Script.

DECLARE @HOURS INT

SET @HOURS = 24

CREATE Table #ErrorLog (ErrorLog varchar(1000),ContinuationRow Int)

Insert into #ErrorLog (ErrorLog,ContinuationRow)

EXEC sp_readerrorlog

Delete from #ErrorLog

where (LEFT(LTRIM(ErrorLog),4) NOT LIKE Datepart(YYYY,getdate()) and ContinuationRow = 0)

OR ContinuationRow...

kevinsql7 (12/1/2009)

---

We have SQL Server 2000 (SP4) running on Windows 2003 Server. In SQL EM, when I click on the current error log (8 mb in size) the EM hangs....

May I suggest you to visit the blogs section of my site (site address in the signature) and look for the article on Nov 3rd "Deploying SSIS Packages"

Post here...

Yes, you can set up movement of data between different databases on same server or different servers.

You need to script the tables that you need (at source) and create the...

I guessed so ...:-)

I did read in some best practices to have the log file of size 20% with respect to your database. In this case of db file, it would be roughly...

Yes, sp_help_revlogin is the best way to transfer logins.

You may be interested to...

You can edit the maintenance plans and when in design mode, you need to click on the icon. (See pictures is attached). You can enable extended logging and also choose...

I am not sure.

All I wanted...

doug turner (12/1/2009)

---

Thanks. The indexing helped a little. I'm up to 1.6Gb free now. It looks like some major table cleanup is in order to really free...