i see it does fail if your DATEFORAMT is DMY and not MDY: i get the same error you got when i explicitly set my dateformat:

(/12//16/11 causes the error: no...

ndevr (5/10/2012)

---

Hi All,

I have to check in all the servers, whether Database mail is configured or not ,if not i have to setup the mail, what are the pre requisites...

In addition to what Elliot said, some of the events in your trace will not return all columns;

if you run this query (change the patch to match your path to...

this can help:

http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

sure, the datediff between getdate and getutcdate will giveyou the current offset; that willl be 4 or 5 depedning on whether daylight savings is in effect or not:

some timezones are...

SQL_path (5/9/2012)

---

Hi all,

My query has data that drives off of @reportstart @reportend but for the same paramerters the dataset in the report runs blank, therefore available values are empty....

can you change the processes to start using GETUTCDATE instead of GETDATE when you are building your time stamps?

that's greenwhich(sp?) time, so you can better compare dates between data at...

ravisamigo (5/8/2012)

---

Hi All,

xp_cmdshell 'dir \\Server001\e$' - running in Server2

xp_cmdshell 'dir \\Server002\e$' - running in server1

OUTPUT : 'Access is denied.'

But I'm able to access through RUN(WIN+R) command from server1 to server2...

I've posted my version of a Calendar table a few times in some other posts; take a look at my version, and you can decide whether you want to use...

if someone, say a developer, had a change to the code, and did a DROP PROCEDURE usp_blahBlah and then did CREATE PROCEDURE usp_BlahBlah, the permissiosn will be lost.

if the...

with the DDL, we could see if the column MessageTimeStamp was datetime or not...i suspect it's a varchar because of the code converting it to datetime.

you could add persisted...

back in my vb6 days, i had to debug someone elses program that used vb6 int (32767 max size) on a program that had been in place for years that...

If you can modify the proc code, you could add something that raises an error yourself;

For example if not exists(SELECT therRecordstoDelete) or testing if @@rowcount =0

And log info to helpxdiagnose...

wow, it's possible to do that if you create the foreign key with the NOCHECk command;

still that's just making a mess : looks like someone was just slapping bad code...

if you can connect to it via query analyzer or enterprise manager, you can get the version installed.

in QA, you can simply SELECT @@VERSION

in enterprise manager, (it's been a while)...