metro17 (12/29/2008)

---

The script used to generate a primary key :

USE [DATABASENAME]

GO

ALTER TABLE [dbo].[EmpPers] ADD CONSTRAINT [pk_EmpPers] PRIMARY KEY NONCLUSTERED

(

[EepEEID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

yes, file is transferd but some size is reduced...

How can i come to know mode is binary or other?

If it is binary or other..then what should to do?

I think MSDB database also migrated..

Spicoli (10/9/2008)

---

I am occasionally seeing the following error on two of our SQL 2005 64bit servers. (build 9.0.3239)

[font="Courier New"]"Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due...

sp_msforeachdb 'dbcc showfilestats'

GO

sp_msforeachdb 'sp_spaceused'

GO

sp_databases

GO

Yes, i am do as same way.

First take backup on Local..then plan to move on network backup device.

But problem is thar the destination folder has required username and password top...

kumar99ms (12/24/2008)

---

Hi

HOw can u check free space in MS SQL SERVER SERVER

Using dbcc or system stored procedures could you tel me what are those ?

giving the exact information...

But i have already disable broker service on database , even though i am getting the thread of this serrvice in sysprocesses..

Thanks guys

Take transaction log backup of database and apply on that server with recovery.

srawant (12/19/2008)

---

Guys,

I have used litespeed to do my T-log backups... I want to do a cleanup of my backups older than 3 days programmatically.. These backups are with the name...

U can generate SQL login scripts from Right click on database-->task-> Generate script

and select only logins.

How can I get appliocationName from DDL trigger?

Can u explain process...

Vishal Singh (12/26/2008)

---

Dear Administrator

In a scenario where I am updating 5 columns out of 30 in a table and one of them.

Once I am done with the Update I am...

You can do onne thing

Assigned fisrt generated number to first varible.

Assigned second generated number to second varible.

Then using substring u can concating the two variable by taking 3 of 1...