I read that SQL CLR can access regular expressions easily .. ...more >>

Does it help if you create a database with 2 or more data files on the same drive ? Or is it better just to create one especially since its just one drive ? ...more >>

I see some files with the following extensions in a folder .. They are .bnd, ..def, .dp1,.dp2,dr1,.dr2,.ext,.fky,.id1,.prv,.......... I had seen something similar a long time ago but dont seem to recollect what creates it . Anyone knows ? ...more >>

We have a lot of applications dependent upon SQL at the moment. If i change my default port number of 1433, is there something I need to add/modify to the existing connection info from my clients or will it just work ? Using SQL 2K ...more >>

I would like to download the latest Beta of SQL Server 2005. All I can seem to find on the MS site are links to SQL Server 2005 Express, which apparently is some sort of next generation MSDE. I want to become familiar with the fulll blown SQL Server 2005. Can anyone tell me what the lates...more >>

Hi, during a backup of a database with the following command I get an error: backup database TV_TOPO to disk='d:\Backup.nacher\TV_TOPO.bck' Server: Nachr.-Nr. 3271, Schweregrad 16, Status 1, Zeile 1 Nonrecoverable I/O error occurred on file 'D:\Database\TV_TOPO.mdf'. Server: Nachr.-Nr. 3013...more >>

Hello, On SQL 2000 I was wondering if there was a way to bring a database back online that we no longer have access to the transaction log? The volume has failed that held the transaction log and there is no backup of the log, just the database file. Thanks...more >>

DBCC blew up with: > DESCRIPTION: Error: 823, Severity: 24, State: 2 > > I/O error (bad page ID) detected during read at offset 0x0000111c264000 in > file 'D:\MSSQL\MSSQL\Data\production_Data.mdf'. > My boss doesnt want to to anything to the box during the day because we have users using ...more >>

Hello Everybody I have the question about the SQL Server Performance and design considerations. I am developing code that is going to deal with a lot of records (specific detail in the attachment). I am writing code right now that is working fine with a few records. My concern is to know ho...more >>

Ive been getting alerts like the following all morning: DESCRIPTION: Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset 0x0000111c264000 in file 'D:\MSSQL\MSSQL\Data\production_Data.mdf'. COMMENT: (None) JOB RUN: (None) What do I need to do h...more >>

According to BOL 2000: If a torn page is detected, an I/O error is raised and the connection is killed. If the torn page is detected during recovery, the database is also marked suspect. The database backup should be restored, and any transaction log backups applied, because it is physicall...more >>

Hi, My SQL server is has a public IP address admins and developers can access and manage remotely (this is the requirement) When I monitor the SQL server port I can see some one is brutally trying to hack my server. There are almost 70 connections from IP address 66.15.173.105 th...more >>

Hi What is the difference between a mdf file and the sql server database in the context of new sql server 2005? What are the capabilities and limitations of each? Thanks Regards ...more >>

Is there a way to programatically disable autogrowth of all database files residing on a particular drive ? Can someone help ? Even if I cant do it for all database files in one shot, how can I do them for individual databases ? Using SQL 2K ...more >>

Hello, I have a table of quotes. I would like to pull a new quote every 5 hours for my web page (asp.net). I have a field "WebTextKey" that is an identity key. My question is, how to go down the list and query the next quote? I have no idea where to start, so any suggestions would be great...more >>

Hi Everyone, I'm investigating a software called Live Vault (http://www.livevault.com) whose purpose is to continuously monitor and record changes in a SQL Server database, at the database file level, and periodically send these changes to a remote server where they're applied to matching files....more >>

I'm supporting a database that has a Unique Index and yet that column has duplicate values. How can that happen?...more >>

I am looking for some insight into performance issues with a query: SELECT bv.fld1, bct.fld2 FROM bct LEFT JOIN bv on BCT.VisitID=bv.VisitID WHERE bct.BatchDate>='9-1-2004' --bct has a clustered index on BatchDate this query takes about 8 sec If I change the select to: SELECT fn_LG(bv.fld...more >>

I basically need to send emails from MY DTS packages and also some of my stored procedures.There is no way of having any MAPI compliant software installed on the productions database server,so I came up with the idea of installing an SMTP server and use the extended stored procedure introduced h...more >>

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a computer. How do i create tables and stuff like I do in the standard version of SQL server? I tried connecting to it with enterprise manager but this fails. Are you allowed to use enterprise manager with this product? ...more >>

Hi. I am getting started using SQL. My primary objective is to be able to write ANSI SQL statements at a high level, outside of a certain platform. I am using the book SQL A Beginner's Guide by Forrest Houlette. To get started, I downloaded the Microsoft SQL Server 2000 Desktop E...more >>

i am get this error message every time I try to remove some old jobs that were created on a different server: error 14274: cannot add, update,or delete a job (or its step or schedules) that originated from an msx server What do I need to do to remove these jobs? ...more >>

Hi, I have been asked to give a realistic number of concurrent access to do the stress test to the sql server for our application. I used sp_who2, and there are about 187 rows in the result pane. However, most of them has"Sleep" status. 187 concurrent access is a lot. Am I using the right...more >>

I have SQL Server 2K installation with various databases created on them. All our staff are writing the queries and pumping the data at all the time. Sometimes the system is becoming too slow. How to find out which query/process is using the resource? Will the data in sysprocesses will help? A...more >>

Trying to understand what would trigger compilations vs recompilations . I see quite a few of them for both events in Perfmon.. Thanks ...more >>

One of our critical databases that is part of a log shipping-like set up is corrupt. This happened while doing a full DEb restore. DB was showing status 'Loading/Suspect' for about 5 hours. However, restore job has failed, and nothing is attempting to restore it. I am unable to get get any ...more >>

Hi - does anyone know of a sql server - server side resource limit that will timeout an oledb connection running a simple select statement ? I am only aware of the client side timeout options are there any server side limits that will do this ? A user of mine is experiencing a timeout and I ca...more >>

Problem: Contractor migrated Great Plains databases to new server (Win2000, SQL2000). Databases are set up in reverse. Data is stored in .ldf, and log files are stored in .mdf. Log file(.mdf) out of control and needs to be shrunk. (Know how to do this) Can I shrink the logs even th...more >>

Hello All, I'm wrote a program that uses the extended stored procedure XP_CMDSHELL . The user is not an admin and I'm not sure how to set up a Proxy account. I'm getting the following error when I try to add the user into the Non-SysAdmin job step proxy account. ERROR EXECUTING EXTENDED...more >>

sql2k A while back a Developer wrote an SP that cause a specific type of Deadlock. If memory servers correctly and from reading BOL it was a "parallelism" deadlock. Anyways, the resolution was to tell SQL to use only 1 processor when running the SP. Im now in a debate about the whole thing ...more >>

I have a query that does several joins and outer joins. When I run it with top 1000 it returns in about 10 seconds when I run it with top 100 it takes minutes to return. What could be causing such a problem? BTW, on other test servers the 100 does take longer than the 1000 but not minutes ...more >>

Hi, I want to search for multiple strings in a comma seperated text field e.g text1(John,Abbot,Bobby,Mark) I want to get the record which has Booby or Mark. I can use Where text1 like '%Bobby%', but this statement will only search for Bobby in the text1 field, I want it to search ...more >>

I need to change the password off the SQL Server service on about 70 servers, and I'm trying to automate this process. After changing the Service account password SQL books online states that I should change it for the service using enterprise manager since it does some other stuff in the b...more >>

We have a newly installed Windows 2003 (just hot fixes no SP) running on a twin 3.4GHZ system with 4GB physical and two 4GB swap files on separate disks and controllers. We have noticed that shortly after starting the system we are continually getting a high number of page faults. We think...more >>

I recently installed the SA versions of several MELL 2.5 collections. I can access the start page and the training with no issues; everything appears to work perfectly. The problem is, I also installed the SQL database and Reporting to monitor users and usage, but there appears to be nothing b...more >>

I have a web application installed on Windows 2003 Standard Edition with SP1, it accesses a SQL Servet 2000 database installed on Windows 2000 Server, the two computers are not in the same domain. The web application uses ASP pages and COM+ components written in VB6. After the installation of SP...more >>

Hi, I've done some SQL work before but what I need to do now is probably about the most advanced thing I've done. I have a fixed record length file that I need to import into an SQL table. During the import I also need to add an extra column. After doing a little research it would seem t...more >>

We installed SQL Server 2000 SP3 and created a number of databases. However after a while the backups of these databases appear to hang forever and required a reboot to clear. We then created a brand new empty database and tried backing this up, but had the same problem. Looking in the Even...more >>

Hi, Some SPs have more than one result set. How can I access a particular result set? For example, I want to insert the third result set of: exec sp_help 'Customers' into a table. Thanks in advance, Leila ...more >>

We would like to know what is the limitation of SQL Server 2000 Developer Edition. Besides, can it be installed on a Windows XP workstation ? Thanks ...more >>

Dear All, After I run sqldiag.exe, it leave a txt file. I don't understand what is the usage of the file. Does someone can give explaination about it? Thanks Robert Lie...more >>

Hi all, I must be overlooking the obvious (apologies) but can't seem to figure out why I'm unable to execute the following (where both parameters are 'int' datatype: ####### set objCommand = server.CreateObject("ADODB.command") objCommand.ActiveConnection = objConn objCommand.CommandText ...more >>

I'm trying to add a formula to a column in a Table, in Enterprise Manager, but I'm not being allowed. I want a column to be multiplication of two other columns, datatypes money and decimal. I'm typing SubTotal * TaxRate .... What's the big deal with this? ...more >>

Dear All, Does someone know how to use SQL Server Best Practices Analyzer? Is it really usefull? Thanks Robert Lie...more >>

Hi , Can I script the database with existing data e.g. insert statements in YUKON .. Thanks ARR ...more >>

Hi I have just noticed a difference in how BACKUP works when I back up to a local drive versu when I do it to a UNC path. When I run the backup to a local drive, I can see that the .bak file gets created, but then stays a 0 Kb until the backup is finished. When it's finished, the .bak file is...more >>

Hi, For database users assigned with database role "db_datareader" and "Public". Does it mean that he / she is able to browse all tables and execute Stored Procedures. OR He / She can only execute Stored Procedures ? If we want to give him / her access right to exec Stored Procedures only...more >>

SQL Mail Expert, I am avoiding using MS/Outlook as mail client for SQL Mail purpose. I would like to use my SMTP relay box to send mail from my SQL box to my clients. Is there a method to do this ? My Windows server is 2003 standard and SQL Server 2000 Standard. Thanks John ...more >>

I am attempting to set up SQL Mail, but I keep getting the following error in the SQL Server Agent Log: "The mail system failed to initialize; check that a mail client been installed" I'm running SBS 2003 with all SPs, but do not have Exchange running. I have successfully set up an Outlook...more >>

Hi Group, Three quick questions about the 2005 beta. 1) Is it likely that restoring a 2005 beta database backup to a 2005 release environment (when it is released) will produce errors? 2) Will the .Net framework 1.1 be able to call SQL server 2005 beta stored procedures? 3) Can I us...more >>