I dont think u can do it...

if u have...

SQL Server 2005 comes with a 'better' alternative to bi-directional replication. Its peer to peer replication. You can have 2 or more servers participating in p2p replication with load balancing....

thang_ngo_2002 (6/19/2009)

---

EXEC sp_dboption 'database_name', 'single user', true

I get this error of SP sp_dboption

Error is : Server: Msg 5066, Level 16, State 1, Procedure sp_dboption, Line 470

Database options single user...

Glad u got it going 🙂

http://msdn.microsoft.com/en-us/library/ms144259.aspx gives u details of installing sql server 2008 from command prompt which includes silent installation.

i guess there must be some syntax error in the query. for sp_executesql, syntax is plain vanilla.

http://msdn.microsoft.com/en-us/library/ms188001(SQL.90).aspx

you may want to have a look at EXECUTE statement too.

http://msdn.microsoft.com/en-us/library/ms188332(SQL.90).aspx

Edit - added url...

pls read my first post again. It is possible to physically reduce the log size using dbcc shrinkfile. U can use that for one off time but is not advisable...

http://msdn.microsoft.com/en-us/library/ms180047.aspx has many examples. which object do u want to add extended property to? tables? columns?

adding extended property wont take time. also how many tables do u have? 1400? in this case i guess u'll need to add the property for each of them if...

as stated earlier, dont expect the log size to reduce physically. If the frequency of the log backup is good enough, you can expect it not to grow further.

The only cause of concern here is the network bandwidth as the DR site is geographically seperated. remember size of zipped file is 500mb. if you were to apply all...

declare @sql varchar(255)

declare @myserver varchar(255)

set @myserver='myDistantServer'

set @sql = 'select * from ' + @myserver + '.mydatabase.dbo.mytable'

sp_executesql @sql

check this out if this is what u need.

Rollie D Moe (6/18/2009)

---

I'M NEW TO SQL SO PLEASE BE PATIENT IF I DON'T EXPLAIN CORRECTLY. THANK YOU IN ADVANCE

WHEN I GO INTO WINDOWS EXPLORER, PROGRAM FILES, 90 FOLDER,...

Glad i could help you 🙂

You can query...