Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Second Instance problem
Armando - 30 Dec 2006 11:03 PM - 7 messages
I installed SQL server 2005 on a Windows 2003 Server everything went well. I also installed sp1 everything went well. I decided to add a second instance in the process I received two warnings: 1 default installation path permission requirement ...
Score [Ugent] attach Database error in SQL 7.0
Gary - 30 Dec 2006 7:39 PM - 2 messages
Dear All I have try to detach and re-attach database from SQL7.0 (Production Server). The detach process was success, but re-attach database occur a error. There is a Error message show on my screen. ---------------------------------------------------------------------------------------------------- Changed Language setting to us_english. ...
Score Database Maintenance Planner option disabled
unimatter - 30 Dec 2006 5:59 PM - 4 messages
I am using SQL Server 2000 and need to run the maintenance plan wizard, but the "Database Maintenance Planner" option in the Tools menu is disabled (greyed out) no matter which node I click on.  Google searches have turned up nothing.  Help! ...
Score SQL Server 2005 Express vs MSDE
Peter Zolja - 30 Dec 2006 4:10 PM - 9 messages
Hi guys, I have two websites written in .NET that use MSDE and that I'm trying to migrate over to SQL Sever 2005 Express Edition. Both sites have a similar workload (i.e. very small). I wanted to compare the performance of the two ...
Score Open default DB in Enterprise Manager upon connecting to server (SQL2000)
Vsevolod Ukrainsky - 30 Dec 2006 12:25 PM - 3 messages
Hello, 1. My hosting provider hosts ~500 databases on the server where my DB resides. To open my database I use SQL Server 2000 Enterprise Manager. While server connection timeout is short enough (about 1-2 seconds), when I click "Databases" folder in server hierarchy, trying to enlist all ...
Score SQL 2005 useful catalog views and DMVs
Hassan - 30 Dec 2006 6:48 AM - 3 messages
I would like to grab a handful of DMVs and Catalog views one should get familiar with while working on SQL 2005 as a DBA. For eg: in SQL 2000, I would look at sp_who2, sysprocesses,dbcc inputbuffer,sp_lock,sysobjects,sp_dboption,etc. ...
Score Viewing column names of SQL table
Yvette - 29 Dec 2006 10:59 PM - 4 messages
Hi there, How do I get a list of the column names in my SQL tables?  Preferable a list that can be exported to Excel or Word. Thanks! Yvette ...
Score Could not continue scan with NOLOCK due to data movement
KizzyGaul - 29 Dec 2006 10:46 PM - 3 messages
I have a client that is continually getting this error message: Could not continue scan with NOLOCK due to data movement Intially they were not at SP4 of SQL Server 2000, so per this Microsoft Document they patched the server ...
Score SQL 2000 64 bit on x64 Win 2003 Server
Hassan - 29 Dec 2006 9:35 PM - 2 messages
I believe that SQL 2000 64 bit on x64 AMD Procs are not truly 64 bit, but some WoW and that true 64 bit is only suppoerted on IA64 for SQL 2000. Please let me know if this is true and if so, what would be the difference ...
Score server hosed? Very slow server
David C - 29 Dec 2006 9:02 PM - 6 messages
I ran a sql script which has a cursor to process about 5,000 rows on the test server as a test run before running it on the production server. It took 20 minutes on the test server, but over 7 hours on the ...
Score Moving the Reprot Server log files in 2005
MACason - 29 Dec 2006 8:50 PM - 2 messages
I have just setup a SQL Server 2005 instance and am seperating the log files on a seperate drive. Can the ReportServer and ReportServerTempDB log files be moved just like any user database or are there special instructions for moving the log file of these two databases? I have searched the MS Knowledge ...
Score Why the term "Truncate Log"
JayKon - 29 Dec 2006 8:45 PM - 3 messages
Why did MS use the trem "Truncate transaction log" to refer to the process of making the log space with committed and backed up transactions in the transaction log reusable? I keep dealing with people who think the term means the same as shrinkfile ...
Score representative sub-data
voldengen - 29 Dec 2006 7:59 PM - 3 messages
Since indexed views aren't going to work for me, I'm working on revamping a large, ugly query that hits a large, ugly database. The database stores inventory. Some items in inventory are single items (e.g. a calendar), while ...
Score How often and when should the sp_recompile procedure be used
thejamie - 29 Dec 2006 7:20 PM - 5 messages
We are at our slowest this time of year...  Having never set the sp_recompile directive for our procedures, would now be a good time to tell the server to recompile all the stored procedures?  I believe we have added perhaps 30 or ...
Score Sql 2003
n_t_schultz - 29 Dec 2006 7:18 PM - 6 messages
Is there a way to run a sql maintenance plan, and then at then have sql run a batch job to complete a post process onc the sql backup has completed? eg for SQL to call a command line script once the ...
Score q; INSRET/UPDATE trigger
JIM.H. - 29 Dec 2006 6:19 PM - 6 messages
Hi, I user RAISERROR(@Error, 16, 1) in the INSRET/UPDATE trigger, does this rollback record in the table? It seems it does and I am wondering if there is any workaround. Thanks, ...
Score Transaction log backups--file size
Harlan Messinger - 29 Dec 2006 5:02 PM - 2 messages
If I schedule transaction log backups on a file every half hour (using a database maintenance plan), and during the middle of the night I know no one is using the database, why are the backup files large? Depending on ...
Score Migrate jobs from production to backup
thejamie - 29 Dec 2006 4:53 PM - 3 messages
The backup server is using the agent to run log shipping.  If I were to migrate jobs prior to a disaster, the agent would run them.   Assuming I can turn them off so that having them run is not an issue, migrating them one at ...
Score stored procedure compilation - broken
jhbp - 29 Dec 2006 4:20 PM - 8 messages
Hi, I have a SP the runs fine during a period of time, but after a database back up, it stops working until it is recompiled again. What would break this? The SP does use a function that creates a tempDB table with about 8000 ...
Score Dump SQLExpress Data
Arne Garvander - 29 Dec 2006 3:58 PM - 5 messages
Does SQL Server have a command line program that can dump a whole database into sql insert statements. I would like to reload the whole database on another computer. ...
Score caching a view?
voldengen - 29 Dec 2006 8:14 AM - 12 messages
I've got a web application that does queries against a very large product database (SQL Server 2000).  The data that needs to be returned is such that the query is HUGE, and very expensive. Thus far, I've had great success by caching that big query (returning ...
Score Production DB Modifications
morphius - 29 Dec 2006 12:37 AM - 3 messages
We have a production database that is being used by at least 20 different applications. Some of the tables need to be modified (column added). Does anybody have a good way or best method of changing table schemas, objects, etc. without interrupting or at least minimizing the impact on the current ...
Score Is database mirroring the solution for this scenario?
DotComDBA - 28 Dec 2006 11:49 PM - 4 messages
We have an OLTP database handling our business production operations. Our reporting team wants to extract from the OLTP db every 15 min, but that will hammer the OLTP db I/O-wise, breaking the system.  The reporting team wants a copy of the OLTP system to do their extractions. ...
Score When will SP2 be released?
enrique - 28 Dec 2006 10:05 PM - 3 messages
When could I expect SP2 for SQL Server 2005 to be released (not beta or release candidates)? An approximate date would do, eg Jan, Feb... I want to run SQL Server 2005 Developer Edition on Windows Vista and I believe it's only possible when SP2 is released. ...
Score Auditing table access
stavros - 28 Dec 2006 10:01 PM - 2 messages
We regularly load data into hundreds of tables in a reporting database. I know that many of the tables were needed years ago for short-term projects, and are no longer used.  I'm trying to find a way to identify ...
Score Load Test
morphius - 28 Dec 2006 9:31 PM - 4 messages
Does anybody have a sample script to load dummy data in at table....say 10,000 times? Thanks.. ...
Score Security Permissions Question
Thunder - 28 Dec 2006 9:05 PM - 3 messages
Hi all, I have the following situation: SQL 2000 server 2 Databases "ARDC", "PMM" Users log into and use PMM. Stored procedures accessed on PMM by users, Select data in ARDC, such as: SELECT P.COL1,                 P.COL2, ...
Score Help With Query
Charles A. Lackman - 28 Dec 2006 8:12 PM - 2 messages
Hello, I am selecting DISTINCT records from a table: "SELECT DISTINCT Model, Description FROM Warranty" This works great, but I would like to concatinate some other data in the returned records (possibly with a JOIN) From the same table I would like the returned records to return "Family" and ...
Score About change log file folder after database was created
Iter - 28 Dec 2006 7:56 PM - 2 messages
Hi Guys, Can I change log file folder after database was created? I want to move log file to other folder, how do I do? Thanks. ...
Score How to find rows marked for replication?
tootsuite - 28 Dec 2006 7:55 PM - 4 messages
SQL Server 2005 Someone here attempted to update about 3000 rows in a table that is in replication (on the publisher side). We are using push replication. The rows were updated successfully on the publisher table, but for some reason, it serioulsy locked up the replicated table on the subscriber ...
Score Determine which edition of the engine is used by which instance?
Michael - 28 Dec 2006 4:33 PM - 3 messages
Hi, I currently have Windows Sharepoint Services installed using the SQL 2005 Embedded Edition (2005 equiv of WMSDE). I need to install SQL 2005 Express. I want to ensure that the already installed database isn't downgraded to use Express, due to the associated performance/capacity limits it brings. ...
Score I want to activate trace flag 1807 an have it persist across reboots/restarts
war_wheelan - 28 Dec 2006 3:29 PM - 9 messages
I've read the BOL about setting trace flags: DBCC TRACEON DBCC TRACEOFF DBCC TRACESTATUS Also - Via the startup parameters of the services applet '-T1807' Via the server properties sheet startup parameters '-T1807' Via the command line The problem that I am having is the flag doesn't persist across ...
Score SQL Server Express Service Pack 2 maintenance plan wizard
John - 28 Dec 2006 3:17 PM - 6 messages
I've installed service pack 2 for SQL Express but do not see the maintenance plan wizard.  Can someone point me in a direction. Thanks, John ...
Score Retrieve database size information
Tim Kelley - 28 Dec 2006 2:07 PM - 4 messages
On the General tab of a database properties screen there are two fields: Size and Space Available.  Is there a way to access the two fields programmatically?  This would be an easy way to keep track of when the ...
Score SQL 2000 on a em64T server.
Roberto Souza - 28 Dec 2006 1:22 PM - 9 messages
Hi, we have a new server, a 4 dual core cpu em64T machine. It has 20 GB of RAM. We need to install sql 2000 on it. We discovered that we must use SQL 2000 32 bits edition because the 64 bits ...
Score Silent installs
Mark - 28 Dec 2006 11:55 AM - 7 messages
Hi all I want to use SQL Server 2005 Express for my application The concern I have though is user installation. Is is possible to do a silent install as the installation process for SQL server would throw a lot ...
Score SQL Server statistics
steingold - 28 Dec 2006 10:35 AM - 3 messages
Hi all. Is there an API/table/view/stored procedure in SQL Server that enables collections of a variety of statistics per connection in the database ? I'm familiar with the master..sysprocesses table, but there is only 4 kind of statistics in this table, and I'm looking for more information ...
Score Why Clustered Index 'SCAN'.....instead of 'SEEK'
Dutt - 28 Dec 2006 7:34 AM - 19 messages
Hi Friends, When the following query is run, its performing Clustered Index Scan on 'EditHistory' Table though EH.Id is its PRIMARY Key. Its taking a lot of time. Cud u please resolve this? SELECT  EditDate,ObjectId FROM dbo.EditHistory EH (NOLOCK) ...
Score Load on SQL Server Database
sk.rasheedfarhan - 28 Dec 2006 5:36 AM - 2 messages
Hi,    How do we find the load on the SQL server database. even i am not asking in the right mannar but i will can explain my problem then u suggest me the right way to clear my problem. ...
Score PF Usage
morphius - 28 Dec 2006 12:32 AM - 2 messages
I have a SQL server 2005 box with 8 GB physical memory. The windows task manager reports 7.4G PF Usage. Is this accurate? ...
Score AWE /3GB performance
John Grant - 28 Dec 2006 12:27 AM - 7 messages
Is it possible to use AWE and /3gb option and cause the OS to become constrained?  Is so what key OS services are critical and which ones should be stopped? thank -John ...
Score listing of sp_who
JayKon - 28 Dec 2006 12:22 AM - 6 messages
How can I get the listing of sp_who (or any other procedure)? ...
Score Replacement for my LIKE Clause
varkey.mathew - 27 Dec 2006 11:24 PM - 4 messages
Dear all, I need some help from all my Transact SQL Guru friends out there.. Here is the scenario in its most simplified form.. .. I have two tables.. A(Lookup table) and B(Transaction Table) TableA Fields   EmployeeLocationID   EmployeeLocation   (This could have values say ...
Score SQL Server 2005 64 bits on a system with Windows Server 2003 32 bi
Ivar - 27 Dec 2006 9:50 PM - 6 messages
I have Microsoft Windows Server 2003 Enterprise Edition (32 bits) SP1 installed on an Itanium 2 system and also have SQL 2005 installed: Microsoft SQL Server 2005 - 9.00.2153.00 (Intel IA-64)   May  8 2006 ...
Score Update trigger
morphius - 27 Dec 2006 9:34 PM - 5 messages
How do you catch if the event was insert, update, or delete and then insert this into the Audit Table as Action type? CREATE TABLE AuditTable ( ModifiedDT DateTime, CustomerID nvarchar(60), ActionType int ) CREATE TRIGGER trg_InsertCustomerID on Customer FOR INSERT ...
Score DIFF Objects
morphius - 27 Dec 2006 9:32 PM - 2 messages
Does anybody know of a tool or script that will tell the difference between two tables including objects such as indexes? ...
Score Installing Multiple Instances of SQL Server 2000
PeterR - 27 Dec 2006 9:20 PM - 2 messages
I have a question in reference to installing a second SQL instance on the same server.  I installed it and it looks ok on the server except when you look at the server logs it appears to be listening on shared memory and named ...
Score SQL 2005 Agent is not available in Studio
geeknumb2121 - 27 Dec 2006 9:04 PM - 11 messages
Hello...   I am basically a SQL newbie, but I do have this problem:   I have several SQL 2005 Enterprise installations, each running a number of databases, which seem to work without problems...  but one of my ...
Score Latin1_General_BIN vs Latin1_General_BIN2 in Script
sqlextreme - 27 Dec 2006 8:39 PM - 11 messages
Hello I have this problem: test the generation of script with Latin1_General_BIN2 and the following error throws me:  There is already an open DataReader associated with this Connection which must be closed first but with Latin1_General_BIN do not I have that problem, why? ...
Score Insert a row in one table for every matching row in another table
Lauren Quantrell - 27 Dec 2006 5:03 PM - 3 messages
I have a table tblRecords: RecordsID (PK) int GroupID int rows: RecordsID    GroupID 1    0 2    1 3    1 4    1 5    2 ...
Score Has anyone here been both an Oracle and SQL Server DBA?
ChrisR - 27 Dec 2006 4:12 PM - 5 messages
If so, is the role different based on the platform? More stress/ hours in one than the other? Is the work a lot different between the two? Which did you enjoy more? Why? TIA, ChrisR ...
Score NOP in COMMAND column of SYSPROCESSES - any ideas?
bourgon - 27 Dec 2006 3:36 PM - 2 messages
We're having a problem with locking/blocking.  SQL 2000 running on an Active/Active cluster.  Every once in a while, under heavy load, we have an insert procedure start backing up.  This insert proc is run ...
Score Archiving Data
Ben UK - 27 Dec 2006 1:45 PM - 3 messages
I was exploring ways of archiving old data in our production environment whilst maintaining it's availability... ...the current data takes 90% of the queries, but grows very large and puts pressure on the disks... ...I wanted to explore using a "sliding window" on a partitioned view across a federated ...
Score q; How to write this function
JIM.H. - 27 Dec 2006 12:43 PM - 6 messages
How can I write a function that accepts a data as a parameter and if the date is 1.    Last Monday in May or 2.    First Monday in September or 3.    4th Tuesday in November ...
Score Anybody seen this error? - 37000 - Storage Allocation record not available
jonathan.beckett - 27 Dec 2006 11:08 AM - 7 messages
Hi all, I have a problem with a SQL Server database throwing an error I have never seen before, and cannot remember ever seeing anywhere else either (even a google search doesn't throw anything up). Here's the exact text... ...
Score ADODB.Recordset, save record at a time from different workstation
manojkumarshinde - 27 Dec 2006 9:07 AM - 2 messages
Hi, I am in trouble. I have developed an integreated package in VB and SQL Server. If two users sitting on different workstations tries to save records at a time (with the margin of 1 sec.) in a table (.e.g voucherheader), one ...
Score read out transaction log
Marcus Pink - 27 Dec 2006 9:07 AM - 4 messages
Hello! is there a possibility to get all transactions between two dates out of transaction log, an then inject this data into a new database? i need the data from 01.09.2006 to 24.12.2006. the last full backup - witch is not ...
Score High Availability Options
Andrew Hayes - 27 Dec 2006 8:05 AM - 10 messages
From what I've read, there seems to be 4 ways to ensure that if your main SQL Server 2005 machine dies, that you can have a backup machine up-and-running relatively quickly. 1. Backup the databases on the master server and restore them to the backup ...
Score Trigger
morphius - 26 Dec 2006 8:59 PM - 24 messages
How do you capture which trigger fired (Insert,update,delete)? For instance, CREATE TRIGGER trg_audit on Customers FOR INSERT,UPDATE,DELETE AS Insert into auditTable app_name(), [...which trigger fired?] Thanks.... ...
Score Query Plans of 2005 same in 2000 QA ?
Hassan - 26 Dec 2006 8:56 PM - 3 messages
I know there have been changes to certain execution plans in 2005.. For eg: , there is no more bookmark loolup thats displayed in 2005, but is represented as a nested loop join.. All i want to know is that if i run my query from SQL 2000 QA connected to ...
Score Any idea when the next version of SQL is out ?
Hassan - 26 Dec 2006 6:48 PM - 7 messages
I know the executives at MS have promised for a 2 year release moving forward and if thats true, we should be having one in the coming year. But I dont see any sight of the same happening. Can someone confirm ? I believe ...
Score SQL Server Backup Compression
Hassan - 26 Dec 2006 6:46 PM - 6 messages
Why doesnt MS implement a compression algorithm within their SQL Backups ? It seems to be simple, I guess . That way, we dont have to get some 3rd party products like LiteSpeed,etc that may have memory issues,etc. Is MS not implementing this just because of contractual obligations ? Just ...
Score Logical Processing of SQL
Hassan - 26 Dec 2006 6:44 PM - 4 messages
I just glanced at the logical processing flow of SQL Statements in Itziks TSQL Querying Book and wanted to know if this applies to SQL of any RDBMS such as Oracle, DB2,Sybase,MySQL,etc or is it strictly for SQL Server ? ...
Score trying to use password and username in an OPENROWSET command
Paul - 26 Dec 2006 6:42 PM - 11 messages
Hi I have a stored procedure that I have set execute permissions to for a role For this role I have an SQL username and user password.  In order to run this from a windows application I think I need to put the SQL username and password ...
Score sql where clause question
MarkAurit - 26 Dec 2006 6:32 PM - 4 messages
Ive a char(1) column (lets call it Admin) that can be 'Y' or 'N'. In one of my queries I need to treat non-admins is those with Admin='N', and admins as those with (Admin='Y' or Admin='N').  Easy ...
Score TROLL
Morse - 26 Dec 2006 6:19 PM - 2 messages
...
Score COPY Package from SERVER TO SERVER
thejamie - 26 Dec 2006 5:49 PM - 2 messages
SQL Server 2000 - After putting log shipping in place, there does not appear to be a method to move the packages on one server to the backup server.  The wizard allows for data, stored procedures, referential integrity constraints, security, and indexes.   I'd like to copy the packages.  Is there an ...
Score q: convert to DeteTime
JIM.H. - 26 Dec 2006 2:45 PM - 8 messages
I have a date filed 12/26/2006 and a time field 7:00am. How can I combine them in my select statement and get a DateTime field. ...
Score Reason for multiple filegroups/ files?
ChrisR - 26 Dec 2006 2:35 PM - 5 messages
SQL2K SP4 If my data is spread accross a Raid array, is there any real reason to use multiple filegroups/ files? Will I see any performance benefit? Will I only see it on VLDB's. If I do use them, is there a good way to group them ...
Score SQL database restore problem
Marcus Pink - 26 Dec 2006 11:06 AM - 14 messages
Hello @ all! I hope somebody can help me! In our company we use ms sql server 2000 as dbs for our financial software. because of a hardware-failure we had to reinstall this software, an there the problem began. The setup dropped all tables and data from the db and recreated the tables ...
Score **linked server**
M - 26 Dec 2006 9:49 AM - 3 messages
Hi I'm working with MS sql server 2000 and I want to add a linked server. but  there is an empty "provider name" combo box, with following message at the  bottom "Provider Name is one of the providers installed on the server"  ...
Score SQL 2005 versions
Hassan - 26 Dec 2006 6:03 AM - 2 messages
Is 9.00.2047.00 SQL 2005 SP1 ? ...
Score cannot connect to sql 2005 from isql
AH - 26 Dec 2006 3:07 AM - 5 messages
I have a sql 2005 server runs on Windows 2003 Standard OS. On the same server, I can use sqlcmd to connect to the database. However, I failed to connect to the database from a client machine using sql7's isql. The ...
Score Problems with executing ssis package by job
Qwert - 25 Dec 2006 2:14 PM - 4 messages
Hi All, I have created ssis package and am trying to execute it using sql server agent job. The problem is, that the job failes to find or load the package. It tries to run it from the server side and failes to find it. I don't ...
Score Web Service max out at 20 SQL connections
Erin Loy - 24 Dec 2006 7:13 PM - 13 messages
I have been tasked with load testing our .NET 2.0 web service, which is really just wraps 1 or 2 very simple and light weight SQL queries.  Under light load (less than 20 requests per second), everything works fine.  Each ...
Score best way to learn SQL Server
tmags23 - 24 Dec 2006 8:31 AM - 7 messages
I am an experienced database developer who has worked primarily with Unidata (a multi-value database). I wish to learn SQL Server, but will need to do this at home on my own. The only machine I have available is ...
Score HDD problem
xezo - 24 Dec 2006 2:56 AM - 2 messages
Hi, I used performance counter and find a large usage of one of hdd (both counters 'disk write' and 'disk read' are 100% for a very long time) so we have a very bad sql server performace. I'm wondering is it any way to see which exactly t-sql command (or stored ...
Score User 'guest' does not have permission to run DBCC shrinkdatabase for database 'tempdb'.
DaveF - 24 Dec 2006 1:00 AM - 3 messages
When I run a stored procedure from Management Studio that executes the command "DBCC SHRINKDATABASE(N'tempdb', 10, NOTRUNCATE)" I get the error message "User 'guest' does not have permission to run DBCC shrinkdatabase for database 'tempdb'." I have two questions;: ...
Next »