Lynn is absolutely right.  There are features no available to Standard Edition.  And I maybe wrong but Evalution Edition can only be ugraded to Enterprise Edition. So if you end...

Steve is right about how you're loading the data.  If you're using DTS to load I recommend having an execute sql task that populates the fields Steve described and after...

I would implement another physical distributor with pull subscription set up if you're concerned about the performance.  That way another instance of sql server running on completely different server and...

As always go with the more memory.  SQL server 2005's memory limitation based on the OS it's running on.  So if you will use Windows Server 2003 Ent. which does...

The function is the same.  SQL server uses this service to publish the SQL server to Active Directory so users can search for it.  The service is set to manual....

Sergiy and Steve provided the answer.  It really depends on the recovery model of the database and if you have the backups properly set up and working, then you can...

I agree with Avinash.  I just tried to select and insert into a table and @@rowcount function worked. Since it's a global function there maybe something else that setting the...

It's possible.  Of course there is definitely some performace penalty you will get with it.  It all depends on how big the databases and what type of replication you have...

I recommend Valentina's step.  At work I have similar steps that I backup several databases, compress the backup file move the compressed zip file to anohter server in different location,...

I recommend to leave any dbcc operation to SQL server.  Use the veritas for it's made.

Good day...

Bulent

In the options Recovery State you should see the Leave the database non operational option.  But I recommend you do this with script from query window, that way you have...

Jobs run under the account the context of the sql serve agent.  If your agent service account gets its access to sql server via windows membership it may be problematic...

for sql login that sets the password and the corpdatabase as default database

EXEC sp_addlogin 'testuser', 'password', 'corpdatabase'

use corpdatabase

EXEC sp_addrolemember 'db_datareader','testuser'

Your first place to search for an answer is SQL BOL. ...

I have a job that on step 1 backs up the databases on a scheduled time and on the next step moves those databases to another server.  I have not...

execute the extende procedure below that returns the free disk space on drives on your server

 EXECUTE master..xp_fixeddrives