Well, I was going to say that I thought the name of the country at that time was "England" and that the island's name is Great Britain, but Wikipedia has...

I went through a conversion of this nature, changing a 15-year-old FoxPro database into MySQL. This database ran a mid-size company, with around 2-4 million transactions in it.

I opted...

I don't know if this applies to your situation, but for me, I will nearly always choose SELECT....INTO when writing ad hoc queries, b/c I'm selecting from tables in a...

opc.three (6/22/2011)

---

rmechaber (6/22/2011)

---

Looks like you must create a Windows account, grant it NTFS permissions to access the relevant shares, etc., then create SQL login based on the Windows user, etc....

Jeff Moden (6/22/2011)

---

Yes it absolutely does... just not the way that most people have been led to...

Craig Farrell (6/21/2011)

---

For anyone else who got sideswiped by this:

xp_cmdshell in msdn: http://msdn.microsoft.com/en-us/library/ms175046.aspx. See remarks.

Activating the proxy account: http://msdn.microsoft.com/en-us/library/ms190359.aspx

In particular:

xp_cmdshell Proxy Account

When it is called by a user...

Jeff Moden (6/21/2011)

---

The problem that I'm becoming more and more aware of is that people really don't know how to run procs that contain xp_CmdShell without giving the proverbial keys...

Excel is still a great application with extensive features and a robust programming language.

Just this weekend I had to import a large spreadsheet of data into SQL Server, but all...

As Greg said, that works...

.... but only if you are running an Agent job against that particular DTSX file, stored on the file system.

You may know this already,...

Tom.Thomson (5/18/2010)

---

Nice guidelines up to a point. There something rather bizarre though: the claim that "following" is not a noun and therefor can't begin a sentence is pure nonsense....

I haven't played with this, but it is supposed to be possible to inspect the report's render format and dynamically change the report.

Here's one link for you to get started:

http://blog.datainspirations.com/2010/03/03/sql-server-2008-r2-reporting-services-as-you-like-it/[/url]

Rich

Well, one problem I see right off the bat is if I open your posted Excel file, I get a popup that the file format doesn't match the file extension....

GilaMonster (5/12/2011)

---

If it makes...

While it is true that T-SQL is not supposed to consider the order in which you type tables on a JOIN, I ran into an odd problem trying to troubleshoot...

Here's a link to a post I made about how to fix an early problem where users were unable to access any reports in RS, despite permissions tweaks, AD group...