In my opinion one of the biggest problems, at least where I live, is the car. Something that started as a solution has brought about a whole new world...

Then it's time to take a look outside SQL Server, see if it got stuck in the Exchange server somewhere or in a spam filter.

in the first query results, what was sent_status for the SQL Agent jobs?

you can check the sent_status of all queued e-mails:

SELECT * FROM dbo.sysmail_allitems

WHERE send_request_date >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

ORDER BY send_request_date DESC

there's also an error...

I agree, especially since Microsoft seems to keep moving away from other technologies toward...

snomadj (11/23/2016)

---

I need to give a client some options for creating a front end interface for a sql backend. What they currently have is a series of lame old access...

looks like SQL Server Central is having spam for thanksgiving :crazy:

Maybe you could use your script as a way to programmatically build the SQL Agent job using msdb.dbo.sp_add_jobstep

https://msdn.microsoft.com/en-us/library/ms187358.aspx

something like this but changing the parameters to better suit your needs...

USE msdb;

GO

DECLARE...

If you already have a table you're trying to load data into, I've often found BULK INSERT to be easier to work with than OPENROWSET. Have you tried something...

just tried your scenario, it looks like an event is put in the SQL Server error log. Try this:

EXEC sp_readerrorlog 0, 1, 'SINGLE_USER'

it looks like this time you're missing the database name, you started with dbo. instead of fgsvrtrisys.dbo.

when you got the popup asking "Enter Parameter Value" what did you type...

DBCC TRACEON would need to be manually re-run after a server restart. If you use the startup parameters of the service then it will automatically have that flag set...

If you grant the user privileges at the schema level instead of the database level, then they could create and alter procedures at will, but not be allowed to drop...

zoggling (11/22/2016)

---

...

When we attempt to connect to a named instance on the database server from the web server, the following error is raised in the IIS Log:

Error occurred in LoginButton_Click...

OK, the fact table looks better, but I'd need to understand the business a little better to know why you still have multiple balances in the fact. Will these...