Have you tried this?

Right click on the database -> Tasks -> Generate Scripts...

BOL

Enabling and disabling SQL Server features can be configured using facets in SQL Server Management Studio.

To configure surface area using facets

In Management Studio connect to a component of SQL...

There is no surface area configuration for SQL Server 2008

It is possible to hide a SQL Server intance from beeing detected by sqlcmd -L.

select * from sys.dm_exec_requests

where blocking_session_id...

You need to shrink the file using DBCC SHRINKFILE command or the UI.

Hi Chandu,

I think CHECK constraint checks AFTER insertion of data. If we do row count in the ckeck constraint it will have the new row. See the following example:

CREATE TABLE...

It (what you did ) is in-place upgrade.

They are not options what you see on the setup screen. They are methods how you upgrade. If you upgrade the existing...

Also consider copying the records in smaller batches.

http://sql-server-performance.com/Community/forums/p/11750/11750.aspx

declare @minID intdeclare @maxID int

declare @batchStart int

declare @batchSize int

set @batchSize = 25000

select @minID = min(id), @maxID = max(id)from sourceTable

set @batchStart = @minIDwhile...

select @@version shows whether it is Evaluation or Developer Edition.

select @@version

Microsoft SQL...

Maintenance Plans are stored in the msdb database. So take backup of msdb database.

SPID is dynamic. Once a process is completed, it's SPID may...

The...

litu deb (7/21/2009)

---

Hi All,

How to check through TSQL/SSMS which table is not synchronised in transactional replication?

For eaxample: suppose table is not synchronised ,it has 100 rows in publisher but...

BOL

C2 audit mode saves a large amount of event information to the log file, which can grow quickly. If the data directory in which logs are being saved runs out...