SQLRecon[/url] is free, and uses a number of different methods to find all the SQL servers on your network.

i've used it a lot of times, it does a lot more...

hey I'm glad you got it working the way you wanted! Congrats!

i thought select serverProperty('ComputerNamePhysicalNetBios') was supposed to give you the actual machine you are connected to in a clustered environment, am i wrong?

Roust this seems to be working on my sandbox; i was able to create a table with a pk and a uq, and it iterrupts the create index statement:

CREATE TRIGGER...

copy paste error; your variable is missing the @:

set @vBackupPath ='\\l04\backup\RightFax_backup_'+@vDate+vTime+'.bak'

should be

set @vBackupPath ='\\l04\backup\RightFax_backup_'+@vDate+@vTime+'.bak'

ben i hope this helps;

this is the syntax i would use to update from a different table; it would be different if this is inside a trigger;

i *think* your current...

which registry key are you looking at?

on my machine, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

has a value of CurrentVersion=10.0.1600.22

for the the FileVersion of sqlservr.exe, i had 2 on my machine, one for an 2005 express...

some of your part codes do not contain a colon then; add a WHERE statement:

WHERE CHARINDEX(':', PART_CODE) > 0

sure, here's a basic example.

in any query window with SSMS:

begin tran

select * from example with (tablockx)

the with(TABLOCKX) gives you an excluseive table lock.

now if you try in a second query...

only on stored procedures, you can reference a table that does not exist, and the proc will still compile successfully; they call it delayed name resolution.

so you'd be able to...

no matter what the linked server type is, you can use this command:

EXEC dbo.sp_Tables_Ex myLinkedServer

that will list all the tables available in the linked server...whether sql,access,oracle,or whatever...i...

You've kind of hit on all the high points yourself, so i'll just expound a bit.

first, format-wise, a trace is a trace; it's designed to capture exactly 64 columns of...

J-F, to find non-compliant data with high ascii, i think you can just use this:

select * from @test where value like '%[^''a-Z .,-]%'

i think you'd use a Tally table...

if that is a specific product, i think you'd have to add the synonyms to the theosaurus file right?

it's the same concept if i search fro "camero", but i...

the original statement used to create a table is not saved/stored anywhere;

all you can do is generate a statement which would create the table; it probably would not be exactly...