Check on the SQL Server to see if the login is disabled. If it is, then enable it. You can do this in management studio by checking properties of the...

In this case I don't think rebooting the system is going to help after all. Look at whether the account is locked out. Try logging on to the machine with...

I don't think you are going to find anything useful in the agent log. However, there could be a stack dump or mini-stack dump in the sql log.

If you want something simple and quick just for the database you can issue:

SELECT user_name(grantee_principal_id) [User_name]

,permission_name

,class_desc

,state_desc

FROM sys.database_permissions

ORDER BY user_name(grantee_principal_id)

I forgot about the schemas which can be gotten from sys.schemas. Of course there are also the users and permissions, so let me know if you want a script for...

The only difficulty here is the tables because the views/functions/procedures can be gotten at through sys.views, sys.procedures, sys.sql_modules. So, I have only included something for the tables:

IF OBJECT_ID('Script_Table') IS NULL

EXEC('CREATE...

I agree with winslet. Once there is a memory fault or a stack dump the only way you are going to get the service back online is by rebooting. Unfortunately...

2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for a log...

unless someone else needs to execute or modify the jobs it is better to use sa for the job owner. There are no dependencies this way and you can just...

Good catch about the logins. Here is a script for the logins and the server level permissions:

Declare @login sysname

,@Password_Hash Varbinary(200)

,@Grant sysname

...

Are you getting your reserved versus used with something like the following and then doing a DBCC shrinkfile(1/*or whatever the number is*/,####in MB) ?

Declare @File_Stats table (

File_ID int

,File_Group_ID int

,Total_Extents...

Alter Table [tabletwo]

Add ID int

UPDATE tt

SET tt.id = t.id

From Tabletwo tt

JOIN tableone t

on tt.name = t.name

--make sure there are no null ids in tabletwo before dropping the name...

The best method is to make a full backup of your database. Use SQL Server compression if you have 2008. Send the file to a fileshare on the hosted network...

Assuming you have identified the locations and they are correct there are a couple of possibilities. The most likely is that the records from the insert statement in the stored...

The only thing you can attach are images and links. Anyway it should only take you about 30 minutes to create all the templates you want to use. That is...