Hi, I am trying to write a query in SQL 2000 to produce a slightly more than just basic xml schema. I can do the query using FOR XML EXPLICIT, but as the schema that I want to produce is quite large (with a reasonable amount of repitition) this seems unnecessarily complicated. A simplified ver...more >>

One of the drawbacks of SQL Server Log Shipping is that SQL Server must either be in Single User mode or the Log Shipping process must kill all user connections before restoring the logs. This limitation makes it difficult or unrealistic to use the standby server as a reporting server. Is anyone...more >>

I noticed that when I call a stored proc, sqlserver create a session. When I finish executing stored procedures, the session do not logout. As a result, I have to manually kill hundreds of session every day from enterprise manager. May I know anyone encounter this problem? In my stored pro...more >>

Can someone please tell me what the fnal build number is for MSSQL 2005? I just took over a network where the old admin did a lot of playing around on the network and installed a lot of "Test" software. This includes MSSQL 2005. There has also been a change in some of managment and no one k...more >>

Hi, For a hosting company, I need to protect databases from unrelated logins. I mean logins must not be able to see other databases while using SSMS. But be able to view their own database in the list. Any help would be greatly appreciated. Leila ...more >>

I'm trying to copy my databases (and ideally do this as a regularly scheduled job but getting it to happen once will get me started) from the old SQL Server 2000 to a new SQL Server 2005 database in another domain. There is no trust between the domains. I've gotten export/import using the G...more >>

How can i switch my istance from case-insensitive to case sensitive ? MM ...more >>

I am looking at the graphical estimated execution plan in Query Analyzer for a query. One of the steps in the query is in red and indicates "Warning: Statistics missing for this table..." for a column. However I have used both sp_helpstats and DBCC SHOW_STATISTICS to verify that statistics do ...more >>

What is the query needed to find the records that has a duplicate in a certain field? Thanks ...more >>

Hi, I've been putting together a database naming convention standard for our SQL developers the last couple of days. I've chosen a more verbose standard to help reign in my developers and to help improve the documentation, use and understanding of their T-SQL code. I've looked over it a f...more >>

Hi, Can someone please tell me if it's possible to run SQL Server 2000 and 2005 on the same machine? Does anyone know of any related problems. Thanks Jon Derbyshire...more >>

Hi I have a calendar that the user selects a date from without a time. Anyhow I need the query to return the record even though the data in the table contains a time. this works but I do not have a time in the search. select * from table where DateTime ='2003-05-09 10:00:00' this does not work...more >>

Hi, I want to import an Excel file that has many Excel sheets within it. I need to get this into an SQL database using the DTS. I have set the DTS task to import the Excel sheet successfully, but I ONLY get the 1st sheet imported. What have I forgotten? Can someone assist in getting all sh...more >>

Is there a way to grant users (non SA's) to view and execute Jobs on Sql Server 2000 and SQL Server 7 without granting SystemAdministrator previleges? Thanks ...more >>

Hi guys, I'm not very familiar with backups, and I have a simple question. Let's suppose that I do one full backup and 10 differential backups. If sometime later, I delete the first 9 of those differential backups and I keep only the last one, should I be able to restore the whole databas...more >>

Hi Guys, I installed ASP.NET 2.0 on a windows 2000 sp4 box. Then I installed SQL 2005 Express edition and the server management studio experss CTP. I then created a web-site under default web-sites and just put a default.aspx page in it that just has a drop down box which is filled up using t...more >>

Hi everyone. This is what I am facing with now, 1. A tape driver which runs Veritas BE 9 to backup DBs (complete backup, daily) 2. Also, in EM, a SQL Server job to backup DBs to a local hard disk (differential, every 6 hours) My question is, if I want to restore, I need to do the following ...more >>

I hear a lot about different ways of pulling data off of sql servers. When you go to register a server in enterprise manager what method of data access is it using? ole db, odbc, ??? ...more >>

hi, can anybody give me any suggestions on how to speed up the performance of our sql server? Here's the current setup: We got a main transaction database of 80gb of data, indexed by recordID,lastname,firstname,( at least 15 fields). When our clients (about 50-100) start viewing the s...more >>

Hi, I have with me Sql Server 6.5 production server and its DR server(read only, truncate log on checkpoint, no checkpointon recovery => option's set ). I hourly refresh DR server with log from production. Due to some issue i had to re create DR server DB. After recreating i loaded it with...more >>

When installing sql server, do you need to install a separate license or is it a part of the installation process of sql server enterprise edition 2000? Thank you. -- New SQL Server DBA...more >>

Hi All, I'm looking at the replication security on one of my servers (admittedly I haven't used replication that much before), we are running transactional replication and I wondered what the distributer_admin login does... ...is it safe to remove the distributer_admin login? - or at least ...more >>

I have a datetime field in a database, but want to query on the date portion only. 1. Can someone provide an example? 2. Any good online SQL resources specific to MSSQL dialect? Thank you, -- Warm Regards, Lee "Upon further investigation it appears that your software is missing ...more >>

Hello I am very new to sql server, my experience is as a Progrss DBA. I want to start monitoring the database growth on both all tables and database files etc within SQL. In a Progress Environment I could run table analysis job to display each table, number of records, size/blocks used,...more >>

We have a SQL 2000 SP3 Server hosting the MOM 2000 application. We are running the MSSQLSERVER service and SQLSERVERAGENT service using a Domain service account. Our audit level is set to All - this is in accordance with the customer's requirements. The application log is constantly bein...more >>

I'm writing a simple application that stores/pulls data into/from SQL 2005 Express Edition database. In one process data is inserted to the database, on another process same data gets pulled out. Both operations complete successfully and fast however the puller sees the inserted data way after...more >>

When trying to connect to my SQL Server I'm getting the followin error: ****************************************** A connection could not be established to (local). Reason: Logon failed for user. Please vertify SQL Server is running and check your SQL Serve registration properties (by...more >>

I have a back up file of a database which is residing in a different server. I need to restore the database with the .bak file which is available with me. How should I proceed to set up this....more >>

Hi, Is it possible to recover data from a log file? I don't have any backups, i only have a database in SQL 2000 with recovery model full, and i need to recover some data from two tables? is there a way of do it? Thanks in advance, Mestre ...more >>

Hi We have SQL 2000 Ent in cluster mode, we move the database in to different drive and log in to different drive. but now we want to move All the database (the default one also, which is master, tempdb, etc). (its mainly for backup purpose, otherwise SAN not supporting) Ok in this case,...more >>

I'm trying to pass a query from sql server 2000 to Oracle using linked servers. I don't want to use DTS. While it's easy enough to use OPENQUERY to pass thru a query that returns a dataset, I can't seem to pass thru a query that doesn't return a dataset eg a create table query or a drop table ...more >>

I have an SQL server going on my Notebook. I want to move it to another location and then reattach it. I have forgotten how to get to the commandwindow where I can start with EXEC ...... reidarT ...more >>

Hi NG, #1: Is there a utility from microsoft that can monitor who is connected to our Windows 2000 server similar to netwatch.exe from the resource kit but instead of monitoring the shared folder I would like to know who is connected to my Oracle, Sqlserver databases without going to enterpri...more >>