one thing everyone forgets

make sure your database is checkpointing - the log data is not truncated if no checkpoint has occured

try the following

use mydb

go

checkpoint

go

backup log mydb to disk='xxxxxxxx'

go

dbcc shrinkfile(2,1)

go

Rich

if i remember those machines (5664-server is it?) then they only have 1 disk (ok 2 disks in raid 1) on them???

1 disk and 1 Gb of memory will almost...

use the ORIGINAL_DB_NAME () feature in your classifier function

40 lac = 4,000,000 ( 4 million )

(1 lac=100,00)

is this correct ???

one more question - does the file you are importing/updating from have a unique identifier? if so is...

ok

1st you need to create a database in sql2005/2008 compatibility mode to host the proc

CREATE DATABASE test

Go

then set it to allow the use of unsigned CLR -

ALTER DATABASE...

A Good DBA will want to know everything going on in his environment - especially since he will be the one called out at 2am in the morning when it...

you can use a linked server to do this, but you will need to enable MSDTC and distrtibuted transactions in order to pump the results into a table

once you have...

unless i'm mistaken that gives you the table CREATE date, not he index create date

sysobjects.id = the table id

sysindexes.id = the table id

sysobjects.name = table name

sysindexes.name=index name

sysindexes.indid= the index number...

with regards to locked down environements and open vs closed environemtns, we're trialling the new Policy feature in SQL 2008 so that all dev machines and databases meet a minimum...

ok - i would suggest something like the followiing

declare @strsql varchar(max)

declare @temptabname varchar(100)

set @temptabnme='mysourcetable'

declare @destnamevarchar(100)

set @destname='mydestinationtable'

set @strsql='select '

select @strsql=@strsql+' max(datalength('+name+'),'

set @strsql=@strsql+ 'from syscolumns where object_name(id)='''+@temptabname+''''

exec (@strsql)

select name,length from syscolumns...

are you looking to close port 1433 to prevent external clients from connecting to sql server?

if so then just disable the TCP/IP server protocol and listen on shared memory only.

so...

this really depends on what you are trying to acheive and also your data volumes/indexes

if you delete/re-insert then this may be slow and you may get heavy fragmentation on your...

you can use ALTER INDEX.... WITH DROP EXISTING

however all this does is drop the exising index and re-create

if anyone is using the index at the time then the command will...

nope

the use of left or right determines which side of the join returns all results

my example is clearly a left outer join

if this were right outer then the results would...

left outer self join - easy

show me all employees and their managers

include all employees that do not have a manager

select e1.*,e2.name from employee e1 left outer join employee e2 on...