Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 25th, 2008, 10:56 AM
Friend of Wrox
 
Join Date: Mar 2007
Location: West Palm Beach, Florida, USA.
Posts: 205
Thanks: 4
Thanked 0 Times in 0 Posts
Default Table path using 4 part naming convention

Here is how I have qualified a path using 4 part naming in my sp:

SELECT vgiwpw03-sql3/equentialprod.goLabor30.Batch.ReportDate AS job_date

this:

SELECT 'vgiwpw03-sql3\equentialprod.' + goLabor30.Batch.ReportDate AS job_date

My vb program gives me error when calling the sp:

Invalid object name 'Batch'

My server is VGIWPW03-SQL3\EQUENTIALPROD and database = goLabor30 and table = batch


 
Old February 1st, 2008, 07:45 PM
Friend of Wrox
 
Join Date: May 2006
Location: Helsingborg, , Sweden.
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT Batch.ReportDate AS job_date
from [vgiwpw03-sql3\equentialprod].goLabor30.dbo.Batch




Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Naming convention for Replication darrenb SQL Server 2005 3 May 3rd, 2008 02:50 PM
host has preset database naming convention crmpicco PHP Databases 0 October 23rd, 2007 01:14 PM
Could not find a part of the path babarrana ASP.NET 2.0 Professional 3 August 21st, 2007 09:05 AM
Error: Could not find a part of the path eelisMX Pro VB.NET 2002/2003 2 July 4th, 2006 02:22 AM
Naming a new table SKE Classic ASP Databases 2 March 23rd, 2005 03:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.