SQLCMD

Hi,I do have the same issue when using Linked Server too in addition to my Openrowset query.Could you post here how did you change those settings? So far I found the articlehttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cossdk/html/eb45c4ef-73c7-4941-abfb-0ce1adcdfb80.aspthas says that Win2003 SP1 or Win XP SP2 required, that we did not have yetPlatforms: Windows XP Service Pack 2, Windows Server 2003 Service Pack […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-20

RE: user!userID used to build report parameter selection list

by Jane-Matheson-154829

SQLServerCentral

I'm not sure what I did different OTHERTHAN I noticed you said tht the line must end with a space so I carfully placed the string back in and hit return after the last ". It works now!!!!! This is great. I evidently wasn't holding my breath or crossing my eyes or something right. Thank […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-20

RE: Question of the Day for 16 May 2005

by Miles-Neale

SimpleTalk

I thought that it would return other then null as well. After I got the 'you are incorrect' message I copied the SQL directly from the html page and pasted it into DB Artisan running against my local SQL Server installation. To my surprise, I was right. I did get a return like answer c. […]

2005-05-16

Existing Cube, need to change DataSource

by Aubergine-Blue

SimpleTalk

Topic

Is it possible to change the Data Source inside the cube to look at a new data source?I know I can edit the current data source and point that to a new place, but I have other cubes that still use that source.

2005-05-11

1 reads

RE: Accessing data across two servers

by PW-201837

SimpleTalk

Have you linked the server(s), using sp_addlinkedserver (or the Enterprise Manager UI) ?

2005-04-22

RE: New record column value should be defaulted to the previous value

by Frank Kalis

SQLServerCentral

ALTER TABLE YourTableNAME ALTER COLUMN SerialNo int identity (1,1) not null GoInteresting script. Do you think it will work?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-02-08

ASCII characters above 127 not translating through linked server

by jcook119

SQLServerCentral

Topic

Good afternoon,We have an Oracle database that holds a table we need to pull over into SQL Server 2000. The source table has a field that contains character strings which freqently include ASCII characters between 128-256. A developer has set up a linked server on the SQL 2000 server, using the "Microsoft OLE DB Driver for Oracle" driver. When I run […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-02-08

11 reads

RE: Question of the Day for 07 Feb 2005

by Juergen

SQLServerCentral

Are you sure your SQL 7 isn't configured for a dd/mm/yyyy? That is the reason for this error on my box. With switched dd/mm or the date in ISO-format I get the '*'

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-02-07

RE: Find all Databases on my servers

by Michael-Ziese-200679

SQLServerCentral

Yes see my second script i sayd it works fine, but i cant do this with the varialbe @servername, the affect gives a error like this: Line 9: Incorrect syntax near '@servername'There must be an other way, but i cant find anything in BOL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-02-07

How to get the last day of the month

by Jonas-Pranckevicius

SQLServerCentral

Topic

I have two variablesSET @FromDate = '1/1/2004' SET @ToDate = '5/23/2004'Is there a way/trick to get the last day of let's say January 2004 (or any year that @FromDate variable has). I don't think that SQL date functions can do that.Note: @FromDate variable could have '1/12/2004' or '1/23/1999' as well.Thanks

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-11-29

3 reads

SQLCMD

RE: Troubleshooting MSDTC in SQL Servers between W2003 and W2000

RE: user!userID used to build report parameter selection list

RE: Question of the Day for 16 May 2005

Existing Cube, need to change DataSource

RE: Accessing data across two servers

RE: New record column value should be defaulted to the previous value

ASCII characters above 127 not translating through linked server

RE: Question of the Day for 07 Feb 2005

RE: Find all Databases on my servers

How to get the last day of the month

Blogs

SQL Saturday Boston 2024 Slides

Small Data SF 2024

A New Word: Moledro

Forums

7 sept, scheduled book

7 sept, schedlued article

6 sept, published book

Question of the Day

Azure Data Lake Storage Gen 2