mw112009 (1/27/2014)

---

We have a commercial app that fires several stored procs at the begining. Now sure which one of them is throwing an error ( Says something like column ferral_orr...

if this is a one time report/export, you can select the data in ssms and chose results to text instead of to grid.

otherwise,

bcp.exe or sqlcmd, either using the -o parameter,...

my example trigger, while untested, would not error out if an automated process inserted multiple tickets in a single operation; but it would create a single email that said these...

well, now i see two things;

first is a critical permissions issue:

the end user who inserts into this table must ALSO be a user in the msdb database, and must also...

well, what you are seeing in the log is normal, i believe. if the service broker gets an email, it starts the database mail executable,and it's default lifetime is ten...

since dbmail is already set up adn running, it might be something related tot eh recipient or relaying;

if you run this query, is the specific email you sent in...

nothing beats actually seeing it for yourself.

here's exactly what i did.

for computed columns, the cost isn't a lot, but it's there.

the key is to look at the actual execution plan.

attached...

Matt Crowley (1/23/2014)

---

It might be OK. I remember in SQL 2000, if you ran DBCC checkdb against a database that was actively being updated, there was a chance you...

so glad it worked out for you;

just got back from lunch, and i was just about to reply that i think you might have put a space between the slash...

aberndt (1/23/2014)

---

Lowell - You are correct, the SEQ is a number and the information that I want is associated with the SEQ # directly before that operation. I attached...

i love this script from Microsoft for this kind of situation:

http://archive.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=addselftosqlsysadmin&DownloadId=9198

it connects to your local or named instance, and adds the current windows user as a sysadmin on the machine...

aberndt (1/23/2014)

---

I appreciate both of your help. It is the row above in both the abc table and the view. I am reviewing the article that Brain Donor...

aberndt (1/23/2014)

---

I am trying to add a field to a view that actually contains data from the record previous to the one I am selecting here:

SELECT ...

I've found the hard way there are multiple prerequisites to...

the SUM(SUM( doesn't look right to me; i think you just wnat to add the two together:

does this minor change work?

= "Record contains "

+ Switch(

Sum(Fields!FQ.Value, "ds") <> 0 and...