1) Use this query to get the UOW (a GUID) of the offending transaction:

use master

select distinct req_transactionUOW from syslockinfo

Note: Ignore the UOW records that are all zeros. “00000000-0000-0000-0000-000000000000”

2) Use the...

It's a permissions problem.

To verify that's the case in your scenario, give the user that you are running the SQL Server service under administrative rights on the SQL...

Like stated before, I would say Oracle is "harder" to deal with simply because of the lousy tools they provide. PL-SQL is no tougher to learn than T-SQL. ...

I consulted with Microsoft. There is no "supported" way to monitor the usage of the MemToLeave area. They also backed up the fact that 1024mb is the absolute...

Thanks for the input- we have defined maintenance windows in place, but I was wondering if there were any drawbacks to deploying procs/functions from purely a technical perspective.

Hi, did you ever get a resolution to your issue? We are having the same exact problem. I believe it's network-related, rather than a SQL problem, but I...

Hi, did you ever get a resolution to your issue? We are having the same exact problem. I believe it's network-related, rather than a SQL problem, but I...

Hi, did you ever get a resolution to your issue? We are having the same exact problem.

thanks!

Hi, did you ever get a resolution to your issue? We are having the same exact problem.

thanks!

Are there audit columns or some sort of other audit mechanism? You can find when the data was updated and then trace that back to any jobs that start...

If you want the highest that fits the criteria:

select max(columnName) from table

where transactionDate <= whateverYouAreCompaingTo

If you want the first that fits the criteria:

select top 1 * from table

where...

Have you tried moving the directories under IIS to under "mysite.com"?

You could possibly insert the record set into a temp table, and query out of the temp table:

SELECT MAX(EffTime) from #tempTable

There is probably a more elegant solution to this,...

You could do a "Print to file", from ERStudio, ERwin, or wherever. Name the file fileName.eps, then run it through Acrobat to create a PDF. As stated, I...