DECLARE @TblName VARCHAR(50)

SET @TblName = 'MyTable' -- can be a parameter also

IF (SELECT OBJECT_ID(@TblName,'u')) IS NOT NULL

PRINT 'Table Exists'

ELSE

PRINT 'Table Not Exists'

Ok. I said dense_rank based on the rank values you...

You can see all the logins on the server using the system view sys.server_principals. It's the 2005 replacement for syslogins.

SELECT * FROM sys.server_principals WHERE type IN ('u', 'S')

sysusers on SQL...

There seems to be a bad link in the article. The link under "Network Solutions snatching domain names" instead links to an article about online polls.

Look up the DENSE_Rank funcion in books online. It's a feature new in sQL 2005 and does exactly what you want.

Pleasure

Strange.

Can you try and connect from management studio with that login (without the control server privilidge) and see if you can connect. If not, see exactly what error is given.

Alan G (1/13/2008)

---

Are you suggesting doing the update Stats after the TRUNCATE but before the INSERT?

Is this because the stats facility after the TRUNCATE still thinks there's 2.5m rows in...

No sims. Case studies.

Long business case then set of questions based on that business case.

Congrats

441 is a nasty exam. I struggled through it. Make sure you know the work very, very well.

The exact allocation of marks is a secret. No one knows what the percentage is between sims and questions or between the questions themselves. I know (because there's a mention...

I would recommend that you do a stats update after the truncate, as truncate doesn't affect the stats, or the rowmodctr.

If you have auto update stats on, then stats are...

Do the procs do any updates, inserts or deletes?

You could try Paul Randal's blog: http://www.sqlskills.com/blogs/paul/ Might well be something there.

The impression I've got is that 2008 is a very small change, compared to 6.5-7 or 2000-2005

Do you rebuild the index, or reorg it?