Prev: SqlFileStream Fails
Next: 5th business day with stock SQL/no function/no loops.
From: rodchar on 19 Mar 2010 16:08
Hey All,

I'm trying to write some SQL for a remote sql05 database and it requires me
to prefix any table names with the database name.

Is there anyway around this, kinda clutters up the sql, i think.

thanks,
rod.
From: Patrice on 19 Mar 2010 16:56
Some details could help. What yo you call a "remote" server ?

My guess is that you are using actually a linked server. The prefix would
then just the name of the linked server ? What happens if you don't ?

--
Patrice


"rodchar" <rodchar(a)discussions.microsoft.com> a écrit dans le message de
news:F97FA791-79F3-44E2-9E9F-FA6C5759479A(a)microsoft.com...
> Hey All,
>
> I'm trying to write some SQL for a remote sql05 database and it requires
> me
> to prefix any table names with the database name.
>
> Is there anyway around this, kinda clutters up the sql, i think.
>
> thanks,
> rod.

From: Sylvain Lafontaine on 19 Mar 2010 16:58
I would suppose that in your connection string, you don't specify the
default database to use or something like that. You don't say how you are
writing this code, so all bets are open.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"rodchar" <rodchar(a)discussions.microsoft.com> wrote in message
news:F97FA791-79F3-44E2-9E9F-FA6C5759479A(a)microsoft.com...
> Hey All,
>
> I'm trying to write some SQL for a remote sql05 database and it requires
> me
> to prefix any table names with the database name.
>
> Is there anyway around this, kinda clutters up the sql, i think.
>
> thanks,
> rod.


 | 
Pages: 1
Prev: SqlFileStream Fails
Next: 5th business day with stock SQL/no function/no loops.