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...

I have one question -

I posed a question on our technical tests for new DBA/Developers and I asked

"Name All Types of join you are aware of"

The question was deliberatly loosely...

apologies - i went from varchar(1) to varchar(2)

i'd had too much coffee

yes - my column was populated

i converted it from 'a' to 'bb' 39 million rows

if you are using management tools then this will be very slow as management studio will work on the principle of making this backwards compatible (to sql7 i think -...