• How can I reduce the size of an LDF file?

    How can I reduce the size of an LDF file?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Tuning and viewing SQL Server reports

    I have developed several reports and deployed on the remote server. While running reports on a browser, it takes about 20 to 30 seconds, but when i browse the same on the remote server, reports get displayed in 5-8 seconds. Do I need to tune my server to enhance its performance, and how should I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Import AS/400 files into SQL server

    Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)

    Yenyen5 pointsBadges:
  • SQL Server

    Thanks Carlosdl! You understand mychallenge. But i dont understand how to store the documents in the file system, and store the document’s path in a varchar field in the database. Please can you help by a step wise solution because i'm a starter. Thank you.

    Phunmie10 pointsBadges:
  • Oracle 10g process each record exactly on time multiple processes

    I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to process...

    Wileecanislatrans15 pointsBadges:
  • Small network setup

    Is there any good tutorials for a novice user to set up networking with sql server.I had 1 server running server 2003 and 2 vista workstations.

    Renulaks135 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • web application

    hi, I want to develop a webapplication to integrate whole school system including principle, teachers, admin staff and parents, using the C# and sql server. can you guide me about the basic modules which i have to develop?

    70085 pointsBadges:
  • SQL Server Table and View Index

    Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

    Db23290 pointsBadges:
  • 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:

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