CREATE PROC usp_get_counts (@tablename VARCHAR(50))

AS

BEGIN

SELECT SUM(row_count) AS RowCount

...

Error messages please. Every single message, plus anything that's in the error logs.

I don't think I've ever seen a case where SQL database files were recovered after deletion and were...

Steps are given here:

http://msdn.microsoft.com/en-us/library/bb934049.aspx

Koen Verbeeck (9/22/2014)

Iek, now that you mentioned it, I...

Surely he expects you to figure it out by yourself? Are you going to tell him, when you present the answers, that they were given by other people?

Anyway, I already...

Maybe someone accidentally the Thread while cleaning up the weekend's spam (all 8 odd pages of it)

SELECT ID, Country + '+{' + CAST(Code as CHAR(2)) + '}' AS Country

From TableName

Disable the sa account and leave it disabled.

For an admin account, create your own, windows authent or SQL authent, strong passwords, password policy, all the usual security steps

I believe they can both run in parallel.

What exactly are you doing?

Those aren't roles applied to logins. They are database roles, they are applied to the database user.

Is the login a member of the sysadmin fixed server...

Offline = index unavailable for the duration of the operation

Online = index is available for most of the duration of the operation, more resources required, may take longer than an...

You don't alter the role. Users can have many roles. Remove that user from the db_owner role, then add him to the roles you want him to have.

sp_adddbrole and sp_removedbbrole...

Looks like they're scenarios which the previous DBA has set for him.

i was in to a new organization has to handel the entire setup singly there is no other...

If you have no DR server, then yes, the DB is down until you can finish the restore. No way around that. That's why critical servers should have HA/DR plans,...

Oh, so these are interview questions you're posting here, not a real set of database problems? Good to know.