Are there any ISAPI filters installed on your IIS server? There's a known problem with ISAPI and IIS that manifests itself as either images not being displayed or "Unable to...

Renaming the clustered server is not possible for a couple of reasons:

1. We are running on one instance within the server. There are multiple instances running other critical databases.
2. The instance on...

SET NOCOUNT ON!!! 

I can't believe I forgot that...

Including the spaces in the output from the SP...

The problem is not how to format the output, the problem is I can't get at my @#%$ data. I tried DTS with a SQL Task that executed my SP...

I changed the sqlString variable to a simple "Select JobName from Requests" (lists all jobs) and the code worked.

Is there a problem with executing a Stored Procedure that returns a...

The problem is I don't know enough about XML to build the XML Schema (or XSL file in Antare's reference) to map the RSS feed to the SQL database. The...

That's the syntax generated by Enterprise Manager when you select a Function from the Add Tables dialog. It's odd, but that's what it does.

I'm not really trying to use a parameter...

I need to be able to do this in a view. Can you Declare variables in the SQL in a view? (I'd check myself, but I'm reading mail from home...

OK, next question:

I built a view to test using the above udf and this works:

SELECT     mail, sn, givenname

FROM         dbo.udf_GetEMpsBYManager('115898') udf_GetEMpsBYManager

Now, I don't want to...

Here's the final, working solution:

CREATE FUNCTION dbo.udf_GetEMpsBYManager

(

@empid char(6)

)

RETURNS @table_variable TABLE (employeeid char(6), sn varchar(50), givenname varchar(50), mail varchar(200) )

AS

BEGIN

Declare @temp Table (employeeid char(6))

Declare @rows Int

Insert Into @temp

  Select Distinct employeeid...

I took Jack's code, modified it with the changes suggested by Antares and I get this:

Create FUNCTION dbo.udf_GetEMpsBYManager

(

@empid char(6)

)

RETURNS @table_variable TABLE (employeeid char(6), sn varchar(15), givenname varchar(25), mail varchar(50) )

AS

BEGIN

Declare...

55 million rows to be exact.....

So it appears that the response for a single select with a non-clustered unique index is somewhere in the area of <= 2 seconds. The...

The data is already in ascending order when it's being loaded. The database is 1.7GB and the single column is only one BIGINT, so if you do the math that's...

Since a PK creates a Unique Clustered Index I generally use that as a shortcut in EM when I have a table with no relationships to other tables. I understand that...

I understand that an index is necessary for performance, but does it need to be a Primary Key index (therefore clustered) or will a non-clustered index work as well? If...