How we will access a table of one server from a stored procdure in other server?

shaurya

 Profile Answers by shaurya Questions by shaurya

• Oct 9th, 2008

You can access this through the following syntax[Another Server IP].[Database Name].[Owner].[Table Name]e.g.[XXX.XXX.XX.XX].[myDB].[DBO].[EmployeeMaster]

Answer Question  Select Best Answer

How to deny delete and drop permission to the user for the particular database in SQL Server 2005.

lairdmcbride

 Profile Answers by lairdmcbride Questions by lairdmcbride

• Oct 22nd, 2008

USE [PARENTDB] GO DROP SCHEMA [USER] GO USE [DB]GO DROP USER [USER] GOor in GUI SQL SQL server Managment Studio go to your DB open it's security section up. . select users folder .. select user adn press delete on the keyboard ..

Answer Question  Select Best Answer

What are the types of authentications supported SQL Server

ashwani.kumar

 Profile Answers by ashwani.kumar Questions by ashwani.kumar

• Sep 10th, 2008

1) Windows Authentication2) SQL Server Authentication

gopi2008

 Profile Answers by gopi2008 Questions by gopi2008

• Apr 18th, 2008

Sql Server supports two types authentications1)Windows Authentication2)SQL Server Authentication

Answer Question  Select Best Answer

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by sakthi.jaganathan

• Aug 25th, 2008

We can copy the Table structure also from one table to another tableExample:                   CREATE table emp1 as      &nbs...

srivani123

 Profile Answers by srivani123 Questions by srivani123

• Nov 15th, 2007

select into statement will work heresyntax: select column1,column2,....into table2from table1

Answer Question  Select Best Answer

How are SQL Server databases physically stored under Windows 2000?

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

There is no hard and fast rule. It depends on you SQL statements.There some usefull guideline.Turn on Execution plan.Avoid cursorUse Cluster index (try to keep it small).If possible use 'If Exit'Try to avoid Rebuild option.

subhashsubramanyam

 Profile Answers by subhashsubramanyam Questions by subhashsubramanyam

• Apr 17th, 2008

Optimizing Stored Procedure involves1) Identify long runnning queries and rectify issues associated with it2) Identify whether they are resource intensive (Eg: I/O intensive ? Replace Cursor...

Answer Question  Select Best Answer

Question: Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Create a out parameter.Set?value with NewId() which return a guid.then insert it into a table.

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Dec 14th, 2007

GUIDs are created by the newid() function. If the default of the primary key is set to NewID(),a new GUID is generated for any new row. In addition, the newid() function may be declared within an inse...

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Deadlock occurs when two or more processes have?lock objects and each process is trying to acquire a lock on an object that the other processes have previously locked.? Let p1 process? has an exclu...

rup

• Jan 30th, 2007

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the ...

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Use IsNULL(,value) .If query return null ,it will replace by  value.

Pandian S

 Profile Answers by Pandian S Questions by Pandian S

• Mar 5th, 2007

Hi1. Without any Null Value for Column1:Select * From Table1 Where Column1 Is Not Null2. Instead of Null values it returns as '0':Select IsNull(Column1,0) Column1,* From Table1

Answer Question  Select Best Answer

Naseer4u

 Profile Answers by Naseer4u Questions by Naseer4u

• Aug 6th, 2008

Select * from sysobjects where xtype='U'

srikanth tirunagari

• May 25th, 2007

select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'

Answer Question  Select Best Answer

ramaniy

 Profile Answers by ramaniy Questions by ramaniy

• Jun 2nd, 2008

Prefix column name with table name like tableName.columnName

Answer Question  Select Best Answer

smithsi

 Profile Answers by smithsi Questions by smithsi

• Jun 2nd, 2008

Set statistics io onset statistics time on

sapna

• Sep 20th, 2006

set showplan onset showplan_text on

Answer Question  Select Best Answer

How to transfer data from a text file to SQL table, Which is the best method to do that?

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by sakthi.jaganathan

• Aug 25th, 2008

By using OPENROWSET commandExample:                   INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLED...

Answer Question  Select Best Answer

How to select Distinct columns from the table, table having 20 columns and i want all columns

Thenchinnu

 Profile Answers by Thenchinnu Questions by Thenchinnu

• May 15th, 2008

SELECT DISTINCT *FROM Tabe1

Answer Question  Select Best Answer

Explain what is Distributed deadlock?

What is the different between Logging and Transaction?

sreddy_bond

 Profile Answers by sreddy_bond Questions by sreddy_bond

• May 9th, 2008

Rownum is the id which is assigned to recored, by the time of record set selected (executed).Rowid is, the id which is assigned physically to each record in table.RegadsSarele

Bill

• Nov 10th, 2006

   sql dbname < script_filename > output.out 2>&1

Answer Question  Select Best Answer

Hello:I would like you to help me guys for my Project Dynamic Document Management System (DDMS) .I was looking for any information to help me to make my project ,but I couldn’t find good recourses to help my. If you have any idea to help me or books ,I’ll be very grateful. Especially about how to create and design Dynamic database SQL Server 2005 .

rudatha

 Profile Answers by rudatha Questions by rudatha

• Apr 23rd, 2008

Select * into new table name from old table name where 1=0

ramakrishnasri

 Profile Answers by ramakrishnasri Questions by ramakrishnasri

• Dec 6th, 2007

Hai,here is the example for ypour qustionselect * into emp1 from emp where 1=9execute this u can have the structure of the new table as old with out the data in the new tablei hope it will solve your problem

Answer Question  Select Best Answer

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Mar 29th, 2008

DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.The Import/Ex...

Answer Question  Select Best Answer