What is four part name?
Explanation : ServerName.DatabaseName.DatabaseOwner.TableName
Example : localhost.AdventureWorks.Person.Contact
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Community Initiatives
About Pinal Dave
Pinal Dave is a Pluralsight Developer Evangelist. He has authored 9 SQL Server database books and have written over 2500 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 9+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Prior to joining Microsoft he was awarded the Microsoft MVP award for three continuous years for his contribution in the community. Here is the list of the Pinal Dave's books.
Follow @pinaldave
Send +Pinal Dave an email at pinal@sqlauthority.com-
- 63,130,394 (63 Million+)
SQL in Sixty Seconds
SQL Books
Funny Index Video
SQLAuthority Links
My Homepage
Windows Live Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
All Scripts - 3
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
> SQL Interview Q & A <
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
About Nupur Dave
Top 3 Commenters
-
[...] 1 : Remote Stored Procedure can be called as four part name: Syntax: EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName ‘Params’ [...]
[...] have been referencing database objects in four part names. SQL Server 2005 introduces the concept of a synonym. A synonyms is a single-part name which can [...]
[...] 20, 2008 by pinaldave Previous I wrote blog post about SQL SERVER – Explanation and Example Four Part Name. It was explaining the new feature of SQL Server 2005 of Schema. Few days ago I received email from [...]
In the example for a 4-part name, does the server name refer to the name of the computer or does it refer to the name of the SQL Server instance? These will not necessarily be the same names.
Aren’t all indexes created as separate structures from a table? Although the index is created against a particular
table, doesn’t the index itself exist in the database as a separate, self-contained structure?
Which index type — clustered or nonclustered — logically
sorts the database of a table?
[...] While using JOINs in your SQL query always prefix column name with the table name. (Example). If additionally require then prefix Table name with ServerName, DatabaseName, DatabaseOwner. (Example) [...]
brother i will need to enter the data to the table of db1 from db2 and db1 is on remote server
please send me the syntax if possible
Hello Kasif,
1. Copy data using Import/Export wizard or SSIS package.
2. Insert data using OPENQUERY function
3. Insert data using OPENROWSOURCE function
4. Insert using 4 part naming. you would need to create a LinkedServer for this.
5. Create script of data at source server and run on target database. As this would need more workaround so not recommonded.
Regards,
Pinal Dave
Hi,
I am very much impressed with your sql blogs and posting.Pinal I have newly stepped into SSIS package could you please help me around in this ….
How to run a stored procedure in ssis package .And i have to pass the parameter’s from excel sheet .Like this
=”exec st_example ‘” &F2 &”‘, ” & E2 & “, ‘” & H2 & “‘”
and in the excel sheet , i need to pass the parameter by row by row .it would contains about 800 row ‘s .i am running this stored prod manually daily.
And i have to schedule this job and send an alert mail.
Sir i am new about to linked server.i am using this in my local server
sp_addlinkedserver
@server=’ip address of my remote server’,
@srvproduct=”,
@provider=’SQLNCLI’,
@datasrc=’databasename’
and then i make this query:
SELECT *
FROM OPENQUERY(‘ipadress’,databasename.uid.’select * from tbl_Products ‘)
it not work. plz sir help me.
Thanks
Randeep Chauhan