First off the login itself is not failing it is the database login (not server) that is failing. I tried this and ended up with the name thing until I...

This should handle it then for the row

select sum(length) as totalbytesforrow from syscolumns where [id] = object_id('tablenamehere')

Just run in the database in question.

"Don't roll your eyes at me. I will...

Are you talking about across the column or the total number of bites the table takes up? If the later you can run

sp_MStablespace 'TableNameHere' and you will get a...

Just be carefull and check Microsoft support if you have any troubles. One of note was a regression issue in SQL 7 SP 2 see http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q269282 but all should be...

Not to my knowledge, however are you sure there was not a secound added sometime after the last backup and that it could not have had soemthing happen to it...

Great to hear you got to the root. Hope you took good notes, as these things always seem to come back into your life when you least expect.

"Don't roll your...

To do thru cmd line you can use isql. SOrry I don't generally use myself but for a list of the paramteres type isql /?. Otherwise,

I know you can do...

I believe the only way a temp table can take advantage of a user-defined datatype is for it to exist in the tempdb. The problem with this is each time...

Can you tell me about the database files. How many files for the DB data and how many was there for the log. Any other things going on with the...

Try this, should help

--Language

SELECT 'Language' AS Property, CAST([name] AS VARCHAR(100)) AS [Name], alias AS [Description] FROM syslanguages WHERE langid = (SELECT value from sysconfigures WHERE config = 124)

UNION ALL

--Sort Order

select...

This is a second post, see "Get Children?" under General forum for other responses.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

1) Yes, and you use sp_attach_db to connect it to the new server.

2) Not usually, unless you have read uncommitted set.

3) It basically is the same as number 1.

"Don't roll...

Try this

CAST((case

when @w=1 then MRmanMemberID

when @w=2 then MRmanIsFinancial

when @w=3 then MRmanTitle end) AS VARCHAR(30))

The problem is Mr is a varchar and auto casting does not generally take place (I...

See this, apparently fixed in SP 2

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q247527

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Personally I go straight for the offending user, got a closet full of bodies I am keeping under wraps.

"Don't roll your eyes at me. I will tape them in place."...