here's an example which uses the FORXML to produce a comma delimited list as a result for each ID:

is this what you were after:

Resource_Id    Skills
  ...

tom.goehring (7/29/2009)

---

Lowell

Did you ever get a chance to create the procedure for the steps below:

3) Install IIS (please include with what pieces to install and configure)

4) How do I create...

there is a script submission that loads all the trace files into a table here:

Default Trace Load of All 5 Files[/url]

you could easily change the command from '*.trc" to logins*.trc"...

nope, no other way. even the GUI does that behind the scenes...the ALTER TABLE clause only lets you changing some of the other attrivutes for column, like ISNULL,...

what you want is the sp_rename function.

with that, you can rename any object...table, constraint,column...doesn't matter.

to rename a column, the syntax is like this:

EXEC sp_rename 'SchemaName.TableName.ColumnName', 'NewColumnName, 'COLUMN';

how about wrap it with try catch, and use dynamic SQL instead; that way it won't test for the connection until the EXEC fires:

BEGIN TRY

Begin Transaction

IF @p_LoadExcelB = 1

BEGIN

SET @sql='

INSERT...

ok, i know that the moment you use a function on a JOIN or WHERE condition, you lose the ability to use indexes, and it requires a table scan.

Your #1...

why not create a view, so it is always ready on demand?

CREATE VIEW MyTrace As

Select * from FROM ::fn_trace_gettable(c:\my_trace.trc", default)

probably a misstatment, but you can't use a trigger i think, but you can certainly use a script to test for your invalid columns:

here's an example of the first two...

OK I've got ~140 or so points accrued from the QOD section, that are not applied yet to the points viewed in the forums; right now my rank is "SSCrazy",...

after you stop and restart the server, the tempdb gets recreated....if it is small by default,(say 10 meg) the first SQL that inserts those 11,000 rows into the temp table...

i have this saved in my snippets,it's supposed to find all zip codes within a given distance, assuming you have a table with zipcode, lattitude,longitude in it:

hope this helps:

/*

Returns zip...

isn't the table scan and not using the index due to the SARGable condition?(Search ARGument)

column = @value can be used to search as boolean match to the index

column is...

adrish sorry about the late followup; the forum doesn't seem to notify the author for posts on content the way it does for forum threads.

since this version got created, I've...

show us your function call;

here's an example of using a linked server to get a function call back, does this help?

exec ServerName.master.dbo.sp_executesql N'Select SERVERPROPERTY(''MachineName'')'