events

RE: Crystal Reports Version 8.x and Windows Server 2003

• by Dale Elizabeth Corey

• SQL Saturday

• Reply

I'm sorry.  I am wrong about IIS and SQL required on the same server.  It does require IIS but not necessarily on the same server.  That's just the way I have it currently configured. 

2004-06-07

RE: Critical Problem

• by Jeff Moden

• SQLServerCentral.com

• Reply

Sukio,Like I said in one of your previous posts, lookup "expanding hierarchies" in "Books on Line".  With a minor amount of tweeking, it will do exactly what you want.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-05-31

RE: Log

• by balaji-44374

• Redgate

• Reply

Thanx for your inputs.

2004-05-25

RE: Split backup across several drives ??

• by mccork

• Redgate

• Reply

Just use 2 destinations in your BACKUP command.  eg.BACKUP DATABASE mydb TO DISK = 'G:\mssql\backup\mydb1.bak, DISK = 'H:\mssql\backup\mydb2.bak' with init

2004-05-25

RE: Getting Date Time for Linked Server

• by James Travis

• SQLServerCentral.com

• Reply

Use OPENQUERY SELECT * FROM OPENQUERY (LINKEDSERVERNAME,'SELECT GETDATE() AS CUR_DATE')

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-05-25

RE: URGENT!!!! HOW DO I SET THE LAST UPDATE DATE AND LAST UPDATED BY IN THE TARGET TABLE USING DTS

• by Srinivas-Vippagunta

• SQL Saturday

• Reply

Thanks Darrell !!! It worked.

2004-05-21

Connecting to wins database

• by Site Owners

• PASS

• Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

2004-05-21

RE: ADO Timeout/Query Analyzer is not

• by James Travis

• SQLServerCentral.com

• Reply

I have heard that before in an article I read somewhere but here is some on what the big deal is.http://www.winnetmag.com/SQLServer/Article/ArticleID/21752/21752.htmlHowever the file is instcat.sql can also be an issue with MDAC updates on the server or the clients. To correct you may actually want to search for all instances of instcat.sql left various installs […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-05-18

RE: Distributed Partitioned Views

• by Jonathan Stokes

• SQL Saturday

• Reply

I've never looked into using partitioned views, so that may be the way to go. However, to get this thread started, I suggest you have a look at Microsoft Message Queue Server. This will do exactly what you require and ensures that if a transaction is rolled back on one server, it is rolled back […]

2004-05-17

RE: Change replication publisher

• by rabiigor

• SQL Saturday

• Reply

Hello

2004-05-12