Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
How to simplify XML Query? (SQL2000)
Posted by Greg Bacchus at 2/6/2006 11:11:26 PM
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 >>
SQL Server Failover/Reporting Server
Posted by Hugh at 2/6/2006 11:04:50 PM
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 >>
Stored procedures do not logout
Posted by andrew at 2/6/2006 7:57:26 PM
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 >>
What is SQL2005 final build number?
Posted by Clayton Sutton at 2/6/2006 7:33:57 PM
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 >>
Viewing Particular Databases
Posted by Leila at 2/6/2006 6:59:00 PM
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.
copying data from sql server 2000 in one domain to sql server 2005 in another
Posted by news.microsoft.com at 2/6/2006 5:25:03 PM
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 >>
SQL Express case-sensitive
Posted by Mauro Miotello at 2/6/2006 5:23:03 PM
How can i switch my istance from case-insensitive to case sensitive ?
Execution plan says statistics are missing but they do exist
Posted by pshroads NO[at]SPAM gmail.com at 2/6/2006 3:11:29 PM
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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
Posted by Johnfli at 2/6/2006 2:54:42 PM
What is the query needed to find the records that has a duplicate in a
Database Naming Convention - Sanity Check
Posted by Jerry Spivey at 2/6/2006 1:51:37 PM
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 >>
Posted by Jon Derbyshire at 2/6/2006 1:30:30 PM
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.
Jon Derbyshire...more >>
date query question
Posted by Paul at 2/6/2006 1:30:10 PM
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 >>
Importing data from Excel file w/ multiple Excel sheets
Posted by 4pcd at 2/6/2006 1:27:56 PM
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 >>
Allow users to run jobs
Posted by shub at 2/6/2006 11:58:45 AM
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
Question about backups.
Posted by Star at 2/6/2006 11:47:38 AM
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
Regarding the SQL Server 2005 Express Edition
Posted by Bali at 2/6/2006 10:49:23 AM
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 >>
SQL Server Backup w/ both Tape(Complete) & Disk(Differential) Scenario
Posted by mr.maoji NO[at]SPAM gmail.com at 2/6/2006 10:47:55 AM
Hi everyone. This is what I am facing with now,
1. A tape driver which runs Veritas BE 9 to backup DBs (complete
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 >>
ole db, odbc, mdac what does enterprise manager register server use?
Posted by tbone at 2/6/2006 10:45:37 AM
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, ???
sql server performance issues
Posted by ChiWhiteSox at 2/6/2006 8:31:29 AM
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 >>
Sql Server 6.5 DR server Backup Load???
Posted by Sreejith G at 2/6/2006 7:22:44 AM
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 >>
Installing SQL Server 2000
Posted by Newbie at 2/6/2006 7:02:30 AM
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?
New SQL Server DBA...more >>
Posted by BenUK at 2/6/2006 4:57:29 AM
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 >>
Cast DateTime To Date?
Posted by Lee at 2/6/2006 4:47:31 AM
I have a datetime field in a database, but want to query on the date
1. Can someone provide an example?
2. Any good online SQL resources specific to MSSQL dialect?
"Upon further investigation it appears that your software is missing
Posted by new_sql_dba at 2/6/2006 4:09:27 AM
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 >>
Possible SQL 2000 Performance Issue
Posted by georgejuggins at 2/6/2006 4:01:29 AM
We have a SQL 2000 SP3 Server hosting the MOM 2000 application. We are
running the MSSQLSERVER service and SQLSERVERAGENT service using a Domain
Our audit level is set to All - this is in accordance with the customer's
The application log is constantly bein...more >>
SELECT right after INSERT returns empty
Posted by vichai.levy NO[at]SPAM gmail.com at 2/6/2006 3:56:19 AM
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 >>
SQL Server 2000 - Conection could be not be established
Posted by JamesNZ at 2/6/2006 3:12:01 AM
When trying to connect to my SQL Server I'm getting the followin
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 >>
Restore backup file
Posted by VBB at 2/6/2006 2:20:27 AM
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 >>
Posted by Mestre at 2/6/2006 12:00:00 AM
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,
Moving master database in cluster
Posted by Gopi at 2/6/2006 12:00:00 AM
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 >>
linked server to Oracle
Posted by arch at 2/6/2006 12:00:00 AM
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
Posted by reidarT at 2/6/2006 12:00:00 AM
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
Posted by Praetorian Guard at 2/6/2006 12:00:00 AM
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 >>