• VB.NET code ideas on a SQL Server

    What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it

    Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then how ?

    21748165 pointsBadges:
  • Implementing access from a remote site to a SQL Server 2000 database

    I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 Maintenance Plans – overwrite vs. append

    I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to 'append existing...'. I want 'oversrite existing...'. Can anyone help me find where that is set? Thank you Carla

    Cecrane10 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught'...

    SQL Server Ask the Experts2,585 pointsBadges:
  • failure to register an SPN

    Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098,...

    Tiz5 pointsBadges:
  • RAID Levels on SAN

    When deploying SQL Server 2005 Enterprise whether it is 32-bit or 64-bit versions using a SAN backend, does the Storage Methodologies regarding RAID1 (VRAID1) or RAID5 (VRAID5) change? There are differences of opinions in our organization regarding this issue. From the DBA Standpoint we strive to...

    ROWENS07150 pointsBadges:
  • Identifying data in SQL Reporting Services

    I am using SQL Reporting Services, and one of the files has the same ID but a unique position number. The field names are ID, pos, phone number and extension. Now, for example, a person with three phone numbers will have three records (pos 1-3). In this scenario, how would I identify a phone number...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to find out what is happening in a Database?

    We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database's tables. All I can report is that an insert, update or delete has occurred, the...

    Mjf75 pointsBadges:
  • Creating View With Xml file and table in sql server 2005

    Hi, I have an Active Directory Xml File and I have archived Table with Active Directory With Limited Information like(GUI,FName, Userid) I like to create a view By left join active directory file and archived table. Thanks for reply in advance Please reply to this question

    1 letters5 pointsBadges:
  • How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent

    I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!

    Jean.young5 pointsBadges:
  • Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic

    Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.

    Karanam5 pointsBadges:
  • MSSQL$BKUPEXEC Service won’t start.

    Hi All! I have a problem with this MSSQL$BKUPEXEC service after a power failure on my SBS Server Premium Edition, this service and along with these below are also not starting as they're meant to be; Backup Exec Device & Media Service Backup Exec Job Engine Backup Exec Server BlackBerry Dispatcher...

    RicoSoya45 pointsBadges:
  • Restrict a script to reduce SQL injection attacks

    I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Toggling a case sensitive query in SQL Server 2005

    It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sage Mas 500 setting up Microsoft Project link.

    I am running Sage M500 - I need to be able to link my project files to my M500/SQL data and vice versa. I see lots of information on functionality but only consultants that want to set it up! HELP Me do this for free and save the day!

    Karl Gechlik9,860 pointsBadges:
  • Avoiding shut down to update windows

    If an sql server is being used for asp solutions, what is the best way to avoid having to shut down when running windows updates? Trying to come up with solution to keep clients from losing access to software.

    Newbie275 pointsBadges:
  • Increasing the performance of a slow query in SQL Server 2000

    I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this from the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL: Using a column created in the SELECT in the WHERE CLAUSE

    Can I use a column in the WHERE clause that I created with 'AS' in the WHERE clause. I have tried and SQL tells me that the column is not in the table? Thanks, Ray

    RayT30 pointsBadges:
  • Initialization DB-Connect Failed, Return Code 000256

    I have migradted 4.6C with 4.6D Kernel from HPUNIX, and Oracle to Windows 2003 Server, 4.6C, and MSSQL 2000, when updating the Kernel getting above mentioned error, can someone please help

    Budi4655 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