Hi All, I plan to run SQL Profiler because my SQL Server 2000 get the users timed out after running some time, and happen every day. (see http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/fc287e2b9eb78b92/a05b0496982d258b?lnk=st&q=&rnum=24#a05b0496982...more >>

Hello, When i create a Maintenance plan in SQL Server 2000 and include backup of all my databases, I can specify the number of days after which the backups are automatically deleted. For instance, I setup a backup to the folder and tell SQL server to delete all backups if they are older tha...more >>

Really having a problem... I have a full backup in a file where RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DeviceTest_db_200608060200' shows the results... DeviceTest E:\Microsoft SQL Server\MSSQL\Data\DeviceTest.mdf D PRIMARY 27590656 351...more >>

I have a table in a database that has six indexes. Four of those indexes have a FillFactor = 90. Two of those indexes have a FillFactor = 0. My Reads in relation to Writes are approximately 100:1. Does it make sense that some indexes would be set at 90 and other indexes set at zero? It se...more >>

I have a new installation of SQL 2005 x64 SP 1 Standard Edition installed on Windows 2003 x64 SP 1 Standard Edition. I installed using unattended install. In the ini file for unattended install I specified ADDLOCAL and amoung other features I specified SQL_Tools90, which according to the tem...more >>

hi, i have a table with columns A,B,C,and D where D is ntext i want to do a select distinct on A B and D. I dont care if the values in column D are not distinct, i just care about the values in column A and B being distinct and just having column D values in the result. What is the best pract...more >>

I get "Unable to load MAPI profiles" error message in DTS Designer trying to add "Send Mail" task. SQLMail has been installed and configured (and tested, it works) on the same server. Please help, thank you in advance...more >>

All- I have typical the log shipping enabled between a prod server and another server. If I restore the log sipping source[production] say with a 6 hours back full db backup + diff [1 hour], what will be effect of this on the log shipping? Looks like I will end up reconfiguring the...more >>

Hi, I am using several triggers on delete on insert etc. I was wondering do the triggers get "rolledback" if the main process is interupted Thanks :) ...more >>

Hello, I have two application running on two different database, and I have only one Windows 2003 server. Which way is best to go: two instances on the same server or two different databases under one instance? ...more >>

Dear all, We have a server with 2 SQL2000 Instance, A & B. Some of our clients need use IP to connect to the SQL2000 Instance. If the Server IP is 192.168.1.200, how can I set the client to use IP to connect to Instance A ? Ivan ...more >>

The computer I work on has Sql Server on it. We also have a main server in the office with sql server on it. The sql server on my computer has test data that I do my development with but part of the data needs to be kept up to date by copying it from the main server. This is done by the mai...more >>

Here are two queries I have (top one is for SQL 2005, the bottom is for SQL 2000): I know SQL 2000 likes the sp_addlogin, and I can use that in SQL 2005, but SQL 2005 likes the CREATE LOGIN. My query below for 2005 works great in 2005, and I like it because I can use the CHECK_EXPIRATION=O...more >>

Hello, When the "Max Worker Threads" parameter is lower than the number of client connections, SQL Server pools the worker threads. Is there a performance counter to see the worker thread pool queue length (connections waiting a thread to handle requests)? TIA. ...more >>

Hi everyone, I am new to this so any help will be much appreciated. I have a problem running triggers between two linked SQL servers. I am running Windows Server 2003 and SQL server 2000 SP4. Both Allow Outbound and Allow Inbound boxes are checkboxes. My trigger work when it connects to ...more >>

Below is a subset of some returned data I'm getting from a query. Through reporting services the user is choosing which team's projects he wants to view. Here is the projects for "SE -Platform Services", but I'd like to always have the projects they own at the top of the list and then the re...more >>

I am having issues with SQL Server 2005 logshipping. Everytime the secondary server restores the logs my users are kicked out of the database. Is this a comman issue? I was under the impression that SQL Server 2005 addressed this issue and this only occured with SQL Server 2000. Is there any ...more >>

Hi all, Does anyone know if you can put an identity column into a table that has been created by SELECT...INTO query, either at the same time as your creating it or after? Thanks alot! Rob ...more >>

Hi, My server is currently installed with SQL Server 2005. I checked in the Event Viewer log file I noticed that I get the error message which the source is MSSQL$SQLEXPRESS, following is the detail of the error message: Event Type: Error Event Source: MSSQL$SQLEXPRESS Event Category: (2...more >>

Hi there, I am running SQL2005 SP1 Standard. I have a database that was originally a SQL2K db that was rolled up to 2K5. Everything was fine with it until I truncated a few tables and dropped a large column & index on a few tables. Since then the following symptoms are present: 1) T...more >>

Hello, I guess this is a good brief definition for Normalization. I am trying to understand what is the sentence "and are not and are not dependent on any non-key ATTRIBUTEs." in the definition. "Normalization is the process of designing database tables to ensure that the fields in each ...more >>

I am trying to run a unattended installation for SQL 2005 in quiet mode (qn). I will be using a ini file to run the installation however the question I have for the group is how do I copy both the installation disks in the network share? Do I copy both the disks in two different folders and then...more >>

Hi *.* I've a table with 14 columns and 640.000 rows, a simple select (* from table ) is very slow (about 16 seconds on my P4 2800, 750 MB of Ram), Is it normal? How can I reduce this time? With some reports that use this table, I've use Index Tuning Wizard and performance is now a little be...more >>

I've got both SQL2000 and SQL2005 running side-by-side and now I want to test a ClickOnce deployment of my app with SQLExpress. Anyone been down this road and know whether I will step on the toes of the installed servers? ...more >>

We have a size able database files in the production. In order to minimize the time to do a full backup, is it possible to take a snapshot of all the database files while the database is online with the following method: - lock/freeze all the data files and turn on the transaction log while ...more >>

Hello, I'm not experienced user of ms sql, but i have stupid problem. I restored database from my backups. This database is used by one old application and this application uses sql user to authetificate (not AD). Problem is my server has no such user in users section (it appears as an owner ...more >>