Confused Results

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Confused Results

Postby JDS » Wed Sep 10, 2008 9:25 pm

Not sure if there is anything can be done about this but if the following query is executed

IF db_name() = '10063'
select 4,5,6

select 1,2,3

I get these results back
Results 1
DBCLUS1VSQL1\\PROD01 10048 1 2 3
DBCLUS1VSQL1\\PROD01 master 1 2 3
DBCLUS1VSQL2\\PROD02 10063 4 5 6

Results2
DBCLUS1VSQL2\\PROD02 10063 1 2 3
JDS
 
Posts: 18
Joined: Fri Oct 27, 2006 6:43 pm

Postby dlkj » Thu Sep 11, 2008 9:44 am

Hi JDS,

I've run this script in both SQL Multi Script and SMMS. Both return the result you stated.

What results were you expecting to see?

Cheers,
--
Daniel
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest