How do you want to keep it in sync? nightly, hourly? There are many solutions depending on which type of availability you are looking for.

Is it using a connection to sql server. If so you can find out the spid by doing a sp_who2 and dbcc inputbuffer and kill the spid. I...

Try this one

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

/****** Object: Stored Procedure dbo.USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LOGIN Script Date: 10/21/2002 6:56:14 AM ******/

CREATE PROCEDURE USP_GEN_USER_RIGHTS_BASED_ON_EXISTING_LOGIN

@OLDLOGIN...

are you using exchange server?

thanks

I had to use a relay in order for my database mail to work. There is another way you can email that is using xp_sendmail.

bring up sql server 2005...

did you create and instance on the sql server 2005. you may need to connect stating the server name and the instance for ex:

servername\instancename

Did you have any of the other sql server applications installed on this server. for example sql server express. I have found that if you already have express installed...

I had the same issue and found out that they are suppose to fix these issues with sp2. I still havent installed sp2 so I am not sure if...

There are normally two cds associated with it. I had the same issue and had to install the second cd which included the client tools.

Thanks that will work.  I am still going to keep writing the cursor just for fun

I had a similar situation regarding my database growing to large and it was due to dropping and creating indexes on our nightly process that does quite a lot of...

use <database>

insert into <table_name>

SELECT table_name FROM information_schema.tables

WHERE table_type = 'base table'

Jar

The hostname is going to just give you the name of the server you are running the trace from.  If you have a chance to run the trace and monitor...

Actually.  I didnt realize that the data file was still there when I restored the database so the data filed doubled in size.  is there a way to shrink the...