Viewing 15 posts - 121 through 135 (of 243 total)
metro17 (12/29/2008)
USE [DATABASENAME]
GO
ALTER TABLE [dbo].[EmpPers] ADD CONSTRAINT [pk_EmpPers] PRIMARY KEY NONCLUSTERED
(
[EepEEID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...
December 30, 2008 at 5:17 am
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?
December 29, 2008 at 11:37 pm
Spicoli (10/9/2008)
[font="Courier New"]"Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due...
December 29, 2008 at 10:03 pm
sp_msforeachdb 'dbcc showfilestats'
GO
sp_msforeachdb 'sp_spaceused'
GO
sp_databases
GO
December 29, 2008 at 10:01 pm
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...
December 29, 2008 at 5:08 am
kumar99ms (12/24/2008)
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...
December 28, 2008 at 10:28 pm
But i have already disable broker service on database , even though i am getting the thread of this serrvice in sysprocesses..
December 28, 2008 at 10:24 pm
Thanks guys
December 28, 2008 at 10:22 pm
Take transaction log backup of database and apply on that server with recovery.
December 26, 2008 at 2:35 am
srawant (12/19/2008)
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...
December 26, 2008 at 2:34 am
U can generate SQL login scripts from Right click on database-->task-> Generate script
and select only logins.
December 26, 2008 at 2:29 am
Miron Berlin (12/26/2008)
see if you can achieve it using DDL trigger by checking application name trying to execute alter table.
How can I get appliocationName from DDL trigger?
Can u explain process...
December 26, 2008 at 2:18 am
Vishal Singh (12/26/2008)
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...
December 26, 2008 at 2:12 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...
December 25, 2008 at 11:26 pm
Viewing 15 posts - 121 through 135 (of 243 total)