It's always going to be a range, even though the range can be 1-1, which of course would only select the first column. I didn't setup the table, just...

I found an easier solution than changing the code. This was an internal server, so security from the outside wasn't an issue. I just gave the public role...

The application is Microsoft Dynamics Great Plains; however, it uses SQL authentication for user logons, so I have around 100 accounts and really don't want to have to add every...

I've tried that, but the syntax that I've seen online is:

WITH EXECUTE AS OWNER

however, when I put that in my trigger, I get a syntax error.

Is there a way in SQL to do like a runas? That way when any user updates their address, it would run the trigger as a user that is...

I actually just descovered this as you posted this reply. Is there away around this?

UPDATE: It has nothing to do with the dbo role, it has to do with the sysadmin right. If a sql user has the role of sysadmin, the trigger...

Nevermind, I have figured this out. So for anybody else looking to do it, this is what you need to do:

USE [COF_sql]

GO

/****** Object: Trigger [dbo].[SQL_update] ...

Ok, looks like the mail function has been replace. So, I've updated the code and when I take the varibles out of the message, it works perfectly; however, when...

Sorry! It's Standard Edition. Let me show you what I've wrote so far, which I think will work, except I'm getting a syntax error on @svr_id in the...

It is SQL 2005 and I haven't written anything yet.

Lynn, I'm positive there is nothing running in between those jobs, I manually ran them back to back.

Jeffrey, I'm not doing a differential backup on the Master DB. If...

Ok, for the Full backup, I'm running:

EXECUTE master.dbo.xp_create_subdir N''C:\sqlbackup\master''

GO

EXECUTE master.dbo.xp_create_subdir N''C:\sqlbackup\model''

GO

EXECUTE master.dbo.xp_create_subdir N''C:\sqlbackup\msdb''

GO

EXECUTE master.dbo.xp_create_subdir N''C:\sqlbackup\TEST2''

GO

EXECUTE master.dbo.xp_create_subdir N''C:\sqlbackup\TEST1''

GO

BACKUP DATABASE [master] TO DISK = N''C:\sqlbackup\master\master_backup_200907061538.bak'' WITH NOFORMAT, NOINIT, NAME =...

I have tried running the back to back. I first run the Full backup, it says that its successful, everything looks perfect on it. Then I run the...

Afraid not! I can't get a differential backup to run anyway that I try it!!!