• Linked SQLServer

    Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

    Db23290 pointsBadges:
  • User account management

    I have taken over the management of around 50 sql servers with responsibility for the creation and deletion of user accounts on each server. To assist with the maintenance of user accounts how would i create a central respository of all users names by server that i could query. Could i use linked...

    AardvarkDBA5 pointsBadges:
  • Stored Procedure

    Hi Guys. Any help would be greatly appreciated. I have three tables Table 1 ID PurchaseOrderNo Value Table 2 ID PurchaseOrderNo WorkID Table 3 WorkID Cost Tables 2 and 3 have a many to one relationship with table 1. I want to display all the PurchaseOrderNo from table 1 and then the sum of Costs...

    Andy199997215 pointsBadges:
  • Output errors from SQL Server stored procedure

    I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details to a...

    Spionred35 pointsBadges:
  • Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

    Therockatmsu15 pointsBadges:
  • Link microsoft SQL server to Active Directory

    I am getting an error while running a qurey for excuting against OLE DB provide'ADSDSOobject' Please advice Thanks Rajaa

    IT45 pointsBadges:
  • The difference between VARCHAR and NVARCHAR

    What is the difference between varchar and nvarchar?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Describe in brief authentication modes in SQL server.

    Describe in brief authentication modes in SQL server.

    Technowise305 pointsBadges:
  • Creating an 180,000 record database in SQL Server

    I have to create a database for 180,000 records in SQL Server, and each of these records have 5 documents to be attached against them. How can i go about setting this up?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Left outer join

    I have 5 related tables. The main table is meeting. The other tables are participant_meeting, vendor,user_id, address. I need the meeting information and the particpant who attentds the meeting(participant_meeting), and their address(address) the vendor for the meeting (vendors) , user_id for the...

    Niveanand5 pointsBadges:
  • SQL in RPG (Error when TESTING (i.e. running under ISDB) RPG program which builds SQL statement and then uses PREPARE,DECLARE,OPEN,FETCH,CLOSE)

    Under ISDB, JOBLOG showed' Internal Error 1001 has occurred SQLCOD -901' SQLCOD was ‘-901’ (i.e. minus 901) which according to manual ’SQL Programming’ is associated with Message SQL0901 – ‘SQL System Error’ SQLERP was ‘QSQROUTE’ - According to Manual ‘DB2 Universal Database for...

    TonyC15 pointsBadges:
  • Attaching files to row information in SQL server

    I'm a new babie in the use of SQL server. Infact i've never used it though i use SQL and Mysql but just as a beginner. Now i find myself in a company where I have to create a database for 180,000 records. whereas, each of these records have 5 documents to be attached against it. Please how can i go...

    Phunmie10 pointsBadges:
  • sql2005 with share point 2007

    I installed sql server2005 and sharpoint 2007 for two times in two seprate windows server2003 but i give same error when i want to start share point : failed to start the database service MSSQL$Officeservers.repair this product by selecting it from the add/remove programs menu. now how can i do?...

    4425195915 pointsBadges:
  • Multiple Tables to Bulk Import .sql script

    I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • Shell script within Stored Procedure

    How do I execute a UNIX shell (.sh) script from within an MS SQL Stored Procedure?

    VelameLaCosa110 pointsBadges:
  • ODBC Connection to iSeries

    Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

    MBell40 pointsBadges:
  • Increasing SQL Server performance by excluding files from anti-virus scanning

    To increase our SQL Server’s performance, we would like to take these certain steps: 1. Exclude the anti-virus software from scanning .mdf, .ldf, .ndf, .dtsx, .sql and .msc files. 2. Turn off I/O scanning for the writing to disk and reading from disk processes. 3. Disable buffer overflow...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to config iSQL Plus on computer without a domain

    Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

    DerrickOra5 pointsBadges:
  • SQL 2008 Identity column values 0

    We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

    Swetaleena5 pointsBadges:
  • Does something similar to Oracle’s optimizer hints exist in SQL Server ?

    In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

    carlosdl72,910 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following