Hi: I'm trying to setup an email operator on a SQL Server 2000 box. I get the error "Error 22022 SQL Server Agent Error: The SQLServer Mail Session is not running: check the mail profile and/or the SQL Server startup account... Here is what has been done 1. A local NT user account has been...more >>

can you backup to UNC paths eg \\server\c$\sql ? i did a maintenance schedule and it didnt work - so im guessing not ? ...more >>

Hi, I need to change the column (nullable, no indexes, no constraints) from nvarchar(255) to nvarchar(500) on SQL Server 2000 production database. The table has over 6,000,000 rows. What's the best and less painful way to do this? Thanks in advance. ...more >>

Hello, Please forgive the newbie question. When I first heard of this database mirroring, I started wondering if it would be possible to have two identical databases accessible from two different locations. Currently, we have a database here in house were we do all of our account managem...more >>

What's the best way to handle this problem? News reports are written. Each report references a Consultant. Both the ConsultantID (unique identifier) and the ConsultantName are currently stored with the report (I changed this recently by adding the ConsultantID, previously only the ConsultantNa...more >>

I'm running the query below to replace one letter. I run SELECT replace(ePPA_No, 'n', 'Y') FROM medman_purge INNER JOIN in4_purge ON medman_purge.Col001 = in4_purge.eppa_no with no problem, and it replaces the 'N' with 'Y' perfectly. When I try to set it using this query: update in...more >>

Hi, I may be off on this, but I thought that if a user or role was given permission to execute a stored procedure, than anything in that procedure would be run, regardless of permissions to underlying objects. In my case, I have a procedure that loads test data into a database, and the pro...more >>

Hi all, Since we installed SP2 on our Windows Server 2003 I'm not able to connect to a linked server using SQLNCLI or SQLOLEDB provider. The error message is always the same: Cannot create an instance of OLE DB provider "SQLNCLI" for linked server "TEST1". (Microsoft SQL Server, Error: 7302...more >>

Hello, I would like to know if there is a way to know if a table field(s) is (are) used by application or stored procedures. I have an old DB with some tables. Those tables have fields, that were in use once - data was written into and read from them by application and stored procedures. ...more >>

I recently upgraded to SQL Server 2005 and prior to this was using SQL Server 2000. My main use of SQL-Server 2000 was to extract data from my database in XML format using the IIS, the Virtual Directory system and XML templates. This meant I could input a URL into Internet Explorer (in the ...more >>

Whats the best practice for monitoring disk space and managing it efficiently, or what to look out for ? (came in today to severe lack of diskspace - its a 700gig raid) (the data folder is 279gig - also ive noticed a lot of LDF files are bigger than the relevent MDF file) cheers ...more >>

Anyone have a script to generate a Create table, indexes, and any RI? ...more >>

Is there a way to change the disk location of data and log files from a database WITHOUT having to restart any services? Thank you ...more >>

Hello, I recently had what I believe is a hardware problem on a server. I have been able to pull the hard-drives and copy all of the information from them to a backup. My problem is there was a SQL Server database that I had never backed up. Is there a way that I can copy files over to another...more >>

I want to write the following condition in where clause SELECT * FROM Cust_Data WHERE Cust_ID IN (CASE WHEN Cust_No = 345 THEN 12,23,34 ELSE 56,67 END) but i know syntactically it is in correct. I also tried it this way WHERE Cust_ID IN (CASE WHEN Cust_No = 345 THEN (select ID Fro...more >>

Hi, We need to write a TSQL query to return the desired output, without using cursors. create table foo(c int) go insert into foo values (11) insert into foo values (27) insert into foo values (83) insert into foo values (24) go Desired output is as below: c1 c2 --- --- 11 27 ...more >>

Hello, There are two types of queries we are trying to write and I am not sure if they are possible. Any help is appreciated. The first type of query is being able to return the top N records for each grouping of data. For example, if we had a table with 2 columns, 'server' and 'applicatio...more >>

I'm migrating a database from SQL Server 2000 to SQL Server 2005. I can create an SSIS package using the Import/Export Wizard, but the details of that package appear to be uneditable in the designer. For instance, I'd like to modify some of the column mappings. The designer shows me a Foreac...more >>

Our Transactions/sec counter jumped quite a bit when we moved to SQL Server 2005. The move coincided with increased load so we didn't think anything of it until recently. Upon further review, the counter just seems too high. There was an article in SQL Server magazine a few years ago by Brian ...more >>

Hi, I need to know all the columns that got updated in an update query. for example if col1 and col2 got updated then i should return 1 | 2 =3 or if col1 and col3 got updated then i should get the number 1 | 4 = 5 and so on 1,2,4,8,16... for col1,col2,col3,col4..... respecively. since these va...more >>

I'm running into a problem upgrading a SQL 2000 instance in an Active/ Active Cluster Environment to SQL 2005. This is not the first time the cluster has been upgraded to 2005. It currently has 8 instances of SQL running on it, however only 2 are SQL 2005. The previous upgrade happened before...more >>

Hi! I have design question. thanks in advance.. this is what i need to store. i need to store soldierinfo.(name,id,weapontype). each soldier is allowed one weapon. weapon could be a knife or gun or and it could be anything else. guns(calibre,name) and knife(length,'name') have differ...more >>