If I query useing servername.database.schema.tablename it returns records, but in management studio I can't see the databases, its just linked server node.

Thanks

When a publication database is mirrored, Log Reader Agent behavior is governed by the mirroring state of the database. By default, the Log Reader Agent can only replicate log records...

Data is copied to the mirrored server in Synchronous fashion to avoid chances of data loss. In order the data to be committed on principal it should first be commited...

Check VCDBCMD tool

Try this code to select the text between '[' and ']' in a column

SELECT SubString

(description,

charindex ('[', description) +1,

charindex ( ']',description) - (charindex ('[', description) +1)

)

FROM PUBLISHITEM

WHERE DESCRIPTION LIKE '%Doc...

There is no option available to detach system database, but you can restore the system databases from backup.

AQKhan

Check the space in tempdb or the HD partition where tempdb is placed. Due to space constraint tempdb may not be able expand. When you restart the SQL Service it...

Hi Sadequl Hussain

Can you share some of the scripts for stored procedures so that I aslo start work on that

AQ KHAN

A useful strategy in large databases is to partition a single logical set of data into multiple physical storage locations for manageability or performance reasons.

SQL Server 2005 supports partitioned tables...