• Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limiting users to one concurrent login in Active Directory

    We wish our users to login once only to one PC. Microsoft say we can only do this by limiting them to one designated machine, this is not possible for us. We need to know that if a particular user did something we can rely on the audit trail. We understand this may get tricky with Citrix use....

    Stanslad0 pointsBadges:
  • Stored Procedure for dropping indexes

    I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name as...

    Dangagne30 pointsBadges:
  • Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    LindaLawson10 pointsBadges:
  • Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    LindaLawson10 pointsBadges:
  • Settng Memory Sql Server 2005 SP2 64Bit

    Hi I've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

    Nuanda777720 pointsBadges:
  • Securing dynamic file uploads to a SQL 2005 Server database

    I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks

    RJpoorvin0 pointsBadges:
  • 29 Feb incorrect in DateAdd and GetDate command

    Hi, Does anyone know Why the day of date different ? when i used : select GetDate() --> It's Return 2008-02-29 11:01:45.310 and then when used : select DateAdd(yyyy,543,GetDate() ) ---> It's return 2551-02-28 11:01:45.310 My SQL Server is MS SQL Standard Edittion VERSION 6.5 Anyone have any...

    283036050 pointsBadges:
  • Using SELECT statements

    Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

    OracleATE190 pointsBadges:
  • Fixing a corrupted file

    I have a 2801 router, but the Nvram file is corrupted. When we try to copy the Running config is not working. The command I use is the following: copy running-config startup-config The error says it cannot save it. I don't know what's wrong. What should I do? Do I need to download the new IOS in...

    NetworkingATE1,545 pointsBadges:
  • RPG with Dynamic SQL Problem – SQLCOD 501/312

    I'm trying to do simple dynamic SQL in a program to select records for a subfile but it doesn't seem to be working. sSql = 'SELECT orderno FROM ordhdr ' 'WHERE custno = :scSrchCust '; following this I have: exec SQL CLOSE @Orders; exec SQL Prepare Stmt from :sSQL; exec SQL Declare @Orders SCROLL...

    MMAGuy85 pointsBadges:
  • Replication in SQL Server 2005 deleting records

    We just converted from SqL 2000 to 2005. We were replicating from 2 instances on the same server every 30 minutes. A record from Intsnace A was copied to Instance B, then the record in A was deleted. Worked great for years. Now with 2005 it is deleting the records on B on the second pass. We think...

    Getmygto5 pointsBadges:
  • rows to columns

    I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields. ex : form_id field_id unique_id field_value 1000 631 1 john doe 1000 632 2 washington 1000 633 3 john@ws.com 1000 631 4 anny...

    Aabbccddee25 pointsBadges:
  • How to control SQL Server transaction log growing to a maximum size

    Transaction log in SQL Server getting completely growed to maximum size frequently even when it is being backed-up and shrinked.. Please provide early and feasible solution.. What is the possible cause for the growth of transaction log to that extent.. and how to avoid it...

    1909198110 pointsBadges:
  • Problems with sp_send_dbmail in SQL Server 2005

    I am trying to convert my stored procedures in SQL 2005 from using xp_smtp_sendmail to using sp_send_dbmail. When I use the "Send Test Email" option in the management studio, I am getting the following error message from the sp_send_dbmail: The mail could not be sent to the recipients because of...

    Randym1,740 pointsBadges:
  • Upgrading two instances of SQL 2000 running on the same SVR to SP4

    I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I'm sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem is...

    Cridgy35 pointsBadges:
  • SQL Server transaction log problem

    An error like" Transaction log full.. backup thelog and shrink the database .. " occured.. Many times the transaction log was backed up and shrinked.. Niow a stage has come where even doing the phenominal process.. the error still re occuring.. Afetr going thru a website transaction log was...

    1909198110 pointsBadges:
  • documents on sql server upgrade from 2000 to 2005

    Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks Sam

    Pslsql10 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 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.

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