i think we'd need a CREATE TABLE definition and a few rows of sample data;

for the most part, i think it's joining a Calendar table to get all possible hours...

he means the operating system...command prompt's COPY command does it in a single line: you could call the Shell command for it:

in SQL

EXEC Master.dbo.xp_CmdShell 'COPY C:\Temp\Header.txt+C:\Temp\Test01.txt C:\Temp\MyWork.txt'

in a command window,...

you'll need to take that into consideration when you upgrade; If you have a separate development server, I'd start testing with higher compatibility right away just to start tracking if...

beautiful; exactly what i was looking for; thanks so much, Gianluca!

do you think looking at sys.sysaltfiles fo rthe master database, and assuming there is a parallel \Backup folder at the same level as the \DATA folder is safe?

--C:\Program Files\Microsoft...

darn; both that registry key and the that script on SQL tips assumes you know WHICH installation you are looking for already...MSSQLSERVER,MSSQL.1,MSSQL.2, etc;

I wanted it to be a bit more...

your idea is even easier to implement; you simply update the source with some tags and poof, some simple CSS on the page and they can see or not see...

i would simplify the issue a bit:

items that contain badwords get archived off to a separate audit table, then update the messages directly to remove the bad words; the overhead...

FYI HL7 is a messaging specification for healthcare information systems.

I goggled a bit after this, and it appears that the parsing is not a trivial thing; one of the...

the error 5.7.1 Unable to relay says the issue is with your mail server refusing anonymous mail;

usually a mail server requires mail to either come from 1)a trusted source/ip, or...

I think this happened to me once when I had upgraded the server to a higher version of a service pack, but not my local client tools; the local client...

ypk1984 (3/8/2011)

---

Hi I dont know, weather this is valid question or not?

So when we establish the linked servers, we can be able to see all the servers linked under the...

I'm guessing that the issue has to do with your SQL2008 being 64 bit, and thus requires 64 bit postgres drivers.

take a look at this article:

http://www.postgresonline.com/journal/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html

I'm not sure what you mean by that; as long as the driver, whether SQL...

backs are stored at a major version level: SQL200/2005/2008/R2;

service packs do not alter the format of the backup files, so you can restore to any installation of 2005; you can...