Actually, it's difficult, if not impossible, to know after the event what the deadlocking process was unless you had already enabled the appropriate trace flag or started a Profiler trace....

I think that the article you mention only refers to databases with TRUSTWORTHY set to ON.

I wouldn't recommend having NT AUTHORITY\SYSTEM as a database owner. If you do, any...

So is it fixed now, or do you need any more help?

John

krishusavalia (2/11/2011)

---

I am new in to SSIS.

Can you guide me though how can i check that account is same or different for sql server and sql sercer agent?

when i am...

In case you have separate accounts for your SQL Server and SQL Server Agent services, it's usually...

Wayne

There's been a lot of partisan debate about whether and how to use stored procedures, so I'll let you search for that and make your own mind up!

From my own...

Wayne

Create a stored procedure in your database that has parameter SerialNo, then write a macro in your Excel workbook that passes the parameter from the worksheet to the stored procedure...

If the original owner is, for example, a DBA who has left the company, then you shouldn't need to do anything after changing the owner. However, some databases are...

If you are changing the database owner to sa then one effect of this is to remove the original owner's access to the database. You need to make sure...

Or something like this:

SELECT RIGHT(' '+CAST(MyDecimal as varchar(18),18)

But really, you should be using...

Probably your best bet it to use bcp or SSIS to create your file. If you don't want to do that, please will you explain your requirement better? ...

clarmatt73 (2/10/2011)

---

Hi All,

I am trying to change a Decimal (18,2) to Char(12) which is simple enough however the figure needs to have spaces at the start instead of on the...

Thanks for taking the time to explain that, Joe. I understand what the problem is now - where you have a many-to-one relationship between the two joined tables, the...

Another alternative is to remove all the alerts from your jobs, then create a new job to run every 15 minutes to check for jobs that failed the last time...

Anand

Is there a question there?

Like I said, no cursor is necessary. Try it the way I suggested, or use the link that Dave posted, and get back to us...