Hi, I have "SQL 2005 express edition" running on 2003 standard (R2). I used the "SQL Server Configuration Manager" to changed the listening port from 1433 to 1722. I do this by following these instructions: http://msdn2.microsoft.com/en-us/library/ms177440.aspx Under "Protocols for ...more >>

Hello I have a DOB field in text file I am importing into an SQLExpress database with the field data type is set to 'datetime'. For some reason the date imports as 1958-08-01 00:00:00.000 ( with a decimal and 3 zeros appended to the end of the field ). What am I doing wrong? There is no ti...more >>

Can you access a database mirror via sql while it is being mirrored to, not after failover? ...more >>

Hi: I want to have a dynamic top function that return me different number of rows based on a variable. For example, I have two tables. One has the region name and the row count that I need. Another one is the table that has student information of the region. So, is it possible to write a to...more >>

One of my servers was running slow this morning so I got a call. I started looking around and saw that my MDF was almost 2 months older than my LDF on the main database for the slow application. I am running W2K3 SBS with SQL Server. I'm not sure where to start looking. Any help would be g...more >>

Hi Folks, We have some inhouse applications developed using microsoft technologies like C#.net,asp.net and sql server 2000. All our applications end users are sql users in that sqlserver with their windows domain credentials. Recently Sarbanes-Oxley Audit conducted in our company. One...more >>

I am using MS SQL Server 2005. I want to create a stored procedure that has optional parameters meaning they can be null sometimes. Example simple test sql (only select stmt would be in proc): declare @Last varchar(30); select @Last = null select lastname, firstname from clients ...more >>

Hi there. We currently have an application which requires separate databases for each "project" we work on. We are in the process of replacing our 2 SQL 2000 servers and are unsure whether to purchase 1 or 2 servers. Previously, we implemented with 2 servers due to performance reasons. Tha...more >>

The SQLlog is indicating the following error: "Autogrow of file 'templog' in database 'tempdb' cancelled or timed out after 15 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size." and "The log file for database 'tempdb' is full. Back up the transaction log for th...more >>

I have placed a SQL server on a DMZ that is on my internal network. I understand that as a Windows system starts, it advertises its services through Service Advertising Protocol, which allows client computers to browse and select servers of a particular type (in my case SQL Servers). Is this...more >>

I am looking for the program that you need run after you restoring a SQL Server database that will correct orphan userid within the database. Thanks,...more >>

:-) I am assuming that all jobs are run under the SQL services login ID, and would use those access rights. But if that's so, what is the purpose of the Owner: field on the job?? Thanks ...more >>

Hi All, I have a problem with one of my filegroup. Every files have been removed, but when I try to remove the filegroup, I have the following error: Msg 5042, Level 16, State 8, Line 1 The filegroup 'TEXT' cannot be removed because it is not empty. When I run the following query, to see...more >>

Folks, Hope you can help with this one please. I want to regulary copy the contents of a particular table in a database to another database server with an identical setup. My question is: does SQL Server 2000 have the ability to do this automatically? Any comments/suggestions/user-exp...more >>

Hi all, I am having a database which is having 10GB allocated space for the data file. But actually the currently used space is only 1GB.I just want to decrease the size of datafile from 10GB to 5GB. For achieving this i have tried the following. right click on the database ->Go to prope...more >>

We have 2 web applications. One uses SQL Server 2000 for the DB, while the other uses SQL Server 2005. Rather than have 2 seperate servers to supply redundancy in the form of replciation, can we use a single server running 2 virtual servers with different versions of SQL server on each virtual...more >>

I have a few maintenance routines created and SQL 2000 has options to email the reports. Do I need to have Outlook installed on the SQL server to do these emails. Also, since outlook uses user profiles I assume that I must log onto the SQL server as the account used to run SQL server to co...more >>

Hi All, I have sql 2000 on Win 2003. I think my drive is dying (once I got in to work and machine was dead and drive check showed a lot of errors) Anyways, now I am having problems backup up certain SQL db's (in order to make the log smaller again). I get the error Nonrecoverable I/O erro...more >>