Is your SQL instance configured using mixed mode?

Is the SQL login you are using in the connection string present and enabled on the SQL instance?

Are you able to login the...

Read the WMIC using the xp_cmdshell (if run with T-SQL):

DECLARE @cmd nvarchar(500)

SET @cmd = 'c:\windows\system32\wbem\wmic volume list brief'

EXEC master..xp_cmdshell @cmd

If you post the DDL (table definition) statements and include some sample data (INSERT statements) we can help you better.

You probably should use a single stored procedure to first update...

And here is a link to the Microsoft site that states the Agent is not supported (in the "Management Tools" table)

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

Allthough the SQL Agent is installed with SQL Express it is not possible to run the service. The SQL Agent can not be used with SQL Express.

Does this suite your purpose?

select *

from sys.dm_os_wait_stats

where wait_type like 'LCK%'

Try to see how the filename of the attachment is detemined. I guess the attachment will be named according to the alert name. Probably there is an illegal character (like...

Are there rows entered in the [sysmail%] tables?

-- show a list of all mailed items

SELECT

sysmail_allitems.mailitem_id

, sent_status

, recipients

, subject, body

, send_request_date

, send_request_user

, sent_date

, sysmail_allitems.last_mod_date

, sysmail_event_log.event_type

, sysmail_event_log.description

FROM msdb.dbo.sysmail_allitems

LEFT OUTER JOIN...

Start by reading about the "sp_change_users_login" at http://msdn.microsoft.com/en-us/library/ms174378.aspx

The option 'report' has resulted in a list of users within the current database that do not have a link to a login....

Yes, it's possible. But is is a real security risk and never -ever- recommended. Are you really sure you can not define a password?

This is how you do it:

1.) In...

I noticed this is a double post

See http://www.sqlservercentral.com/Forums/Topic1476809-3411-1.aspx#bm1476906

Ok, I shouldn't use the phrase "valid date notation" but rather something like "a more deterministic or clear date...

Keep in mind the backup drive/folder is on the server and not on your workstation (assuming you run SSMS on your workstation and connect to a remote SQL Instance)

Also as...

savycara (7/23/2013)

---

I am trying to convert 20114 which is stored as varchar to datetime but I am getting the following error

Syntax error during explicit conversion of VARCHAR value '20114' to...

If I recall correctly the [sysjobactivity] table isn't updates dynamicly but is updated every 15 minutes or so.

I use the code below if i need to get the active job...