Duplicate post.

Replies here please

Correct. MySQL uses "IN" to designate input...

SQLCMD is the command line client for SQL Server.

sp_rename is the stored procedure that renames objects.

thesequel (3/14/2012)

---

Wow!Thank you guys again!

It appears my training book is outdated.

Looks like they made some significant syntax changes from SQL 2006 to SQL 2008.

I will have to find a tutorial...

This is how I would do it, but I never had to do it actually.

I found this thread that should put you in the right direction.

I formatted your query and now looks a bit more readable.

PRINT 'Fetching data: ' + cast(getdate() as varchar(88))

DECLARE @filter as varchar(222), @sql as nvarchar(4000)

SET @filter = char(39) + char(39) +...

50 instances? Are you joking?

I've never heard of anyone hitting the instances limit. :w00t:

50 is the maximum number of inctances you can install on a standalone server. http://msdn.microsoft.com/en-us/library/ms143432.aspx

For clustered instances,...

L' Eomot Inversé (3/14/2012)

---

I think you need to modify the linked server security information on server A.

On the security page of the linked server's properties on server A, tell it...

TheSQLGuru (3/14/2012)

---

I would really question putting TEMPDB on a RAM disk in this scenario. FusionIO cards take up a LOT of system memory - which is obviously then not...

The system is setup as follows:

Microsoft Server Enterprise 2008 (32-bit)

Service Pack 2

Intel Xeon CPU

E5470 @ 2.23 Ghz...

If you have enough space in the tempdb drive, you could use SORT_IN_TEMPDB.

Another option is adding temporarily a new data file in the same filegroup in a different drive with...

I don't know who you're talking about. 😉

No, seriously, you'd better ignore him.

A wise man once told me that the only person in the world you can change is yourself.

Actually I solved this 30 minutes ago, but I was trying to figure out whether there was a better way.

SELECT *

FROM swap AS s

WHERE NOT EXISTS (

SELECT 1

FROM swap AS...

John Chiu (3/13/2012)

---

Is there any limitation on linked server ? I am encountered a problem that push data from one SQL2K5 server to the other (more like to the archive...

GMail with Outlook has some weird behaviours.

For instance, when you send an email to yourself, you won't find it in the Inbox, but in the "Sent Items" folder only.

The folders/labels...