Looks like the SQL Server service account is not set to a domain user. Is it "Local System" or "Local Service"?

I guess something like a DNS name + reverse proxy can do that.

I'm not sure you can forward to different ports based on the "alias" name, but it's worth giving...

I see...

The application looks fro a LABELS table that contains all the labels in the report for translation in other languages.

That's something I failed to remove from this project and...

Indianrock (8/15/2012)

---

The trick Brian, is making sure databases, tables, fields, indexes,relationships and queries scale. ORM technology is probably here to stay, but just because something works on a...

+1000

Couldn't agree more.

On portability, I agree with Steve that nowadays it's not as...

Record counts of what?

Can you clarify please?

Great!

Glad I could help.

You may also want to replace sysfiles with sys.database_files:

SELECT database_name = db_name()

,database_size = ltrim(str((convert(DECIMAL(15, 2), dbsize) + convert(DECIMAL(15, 2), logsize)) * 8192 / 1048576, 15, 2)...

You're welcome.

Glad I could help

You could also extract the code from sp_spaceused and query DMVs and system objects directly:

-- Taken from sp_spaceused:

SELECT database_name = db_name()

,database_size = ltrim(str((convert(DECIMAL(15, 2), dbsize) +...

OPENROWSET?

No need to wait: http://support.microsoft.com/kb/2720425

Unfortunately, that won't work. sp_spaceused returns multiple resultsets when no @objname parameter is specified and INSERT/EXEC doesn't...

Not the only one, honestly. 🙂

Just to add my $0.02, if you're on Enterprise Edition, resource...

subbareddy542 (8/12/2012)

---

FIRST CREATE ONE FUNCTION.

CREATE FUNCTION SPLIT(@VAL VARCHAR(MAX))

RETURNS @T1 TABLE(COL1 VARCHAR(MAX))

AS

BEGIN

WHILE CHARINDEX(',',@VAL)>0

BEGIN

INSERT INTO @T1 VALUES(SUBSTRING(@VAL,1,(CHARINDEX(',',@VAL))-1))

SET @val=SUBSTRING(@VAL,(CHARINDEX(',',@VAL))+1,LEN(@VAL))...