Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Performance DEV vs PROD - Same Equipment???
Jim Douglas - 14 Apr 2007 11:29 PM - 5 messages
DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query takes over an hour in PROD and about 20 minutes in DEV? As far as I can tell their SQLServer settings are the same, I do have limited access. ...
Score SQL 2005 Port Change
erfaiz - 14 Apr 2007 10:06 PM - 4 messages
We recently changed the port our SQL server runs on . Even after a reboot, and instance bounce , the SQL server Agent wont start (gave a login timeout), although the server ran fine When we added the old port back it worked fine , so its running on ...
Score Use of Blade Servers for SQL
Hassan - 14 Apr 2007 9:24 PM - 4 messages
Any pros and cons of using Blades for SQL ? I hear they take a lot of power.. Is that true ? .. ...
Score move terrabytes of data to new data center
Hassan - 14 Apr 2007 9:22 PM - 6 messages
How does one go about moving terrabyes of data to new data center to say establish log shipping across a WAN with huge latency ? I can manage moving the logs , but I am concerned about the first time transfer of all the data ...
Score Problem with SQL 2005 install. Can Microsoft.SqlServer.MSMQTask.dll be recovered?
John Peterson - 14 Apr 2007 7:47 PM - 4 messages
Hello! I am trying to install SQL Server 2005 (Developer Edition -- the version that came with my Visual Studio 2005 Professional Edition software). For the most part, the install went pretty smoothly.  However, during the Integration Services portion, I got the following error: ...
Score Microsoft Search service can't start after SQL2005 installation!
PG - 14 Apr 2007 3:32 PM - 4 messages
Hi everybody I had a server with SQL2000 Standard on Server2003 Standard working, but I was told to uninstall and install SQl2005 Standard, but now when I start the server I receive an error saying that a service could not ...
Score A problem when Critical updates are applied
Ray - 14 Apr 2007 2:27 PM - 3 messages
Hi there, I'm wondering who has the same problem when you applied the recent Critical Updates for SQL2k5. I tried three times, one hour each, but all failed to install it. ...
Score complex query!!
Abhi - 14 Apr 2007 10:50 AM - 3 messages
Hi, I have Below query with me. but it's showing me error i.e "[Microsoft] [ODBC SQL Server Driver]Syntax error or access violation" I am not able to understand what to do exactly ???? Please help Query: -------------------------------------------------- SELECT sla.sla_sc, incident.incident_id, incident.inc_resolve_due, ...
Score AWE
Leila - 14 Apr 2007 9:02 AM - 13 messages
Hi, Imagine that my server has 4GB physical memory. I have added /3GB switch to boot.ini. Should I enable AWE configuration for my SQL Server to use 3 GB address space? Or AWE must only be used when I have more than 4GB memory? ...
Score Read throughput between RAID 10 and RAID 5
Hassan - 14 Apr 2007 3:56 AM - 3 messages
I know writes to RAID 5 are slower than RAID 10( I think). What about when it comes to reading data ? Is it the same between reading from RAID 5 and RAID 10 or is one faster than the other ? If so, let me know which one. ...
Score Licensing for SQL 2000 and SQL 2005 for public website that uses database?
Leythos - 14 Apr 2007 3:00 AM - 6 messages
I'm under the impression that SQL 2000 requires a CPU License for any internet website that allows access to a database - even if you don't use Windows authentication. Is this true of SQL 2005 Workgroup (or any other version) also? ...
Score REPLACE with NULL
sck10 - 13 Apr 2007 11:44 PM - 5 messages
Hello, When I use the following:     REPLACE(CategoryType_ID, 'Non Selected', null) all the values are replaced with NULL even when the value is not "'Non Selected". Any help with understanding why this happens would be appreciated. Thanks, sck10 ...
Score TRY Block with CTE and semicolons
sck10 - 13 Apr 2007 11:21 PM - 3 messages
Hello, I am trying to figure out where the semicolons go in a BEGIN TRY block.  For this to work, I need a semicolon after the BEGIN TRY.  However, if I place a semicolon after END TRY I get the error:  Incorrect syntax near ';'  If I ...
Score Finding Test Grade based on score
sck10 - 13 Apr 2007 11:15 PM - 3 messages
Hello, SQL Server 2005 I am trying to build a query that will give me the final grade from the summation of the project points "strTotalScore".  How would you do this with a join?   Below is what I came up with, but was wondering if there is a ...
Score Assigning permissions
sck10 - 13 Apr 2007 10:04 PM - 3 messages
Hello, I have the following: schema: xproject Database Role: WebPublisher User: MyUserHandle sproc: xproject.MyProcedure I added the role "WebPublisher" to the schema "xproject" with Delete Execute Insert Select Update I added the user "MyUserHandle" to the database role "WebPublisher" ...
Score Query notifications (service broker) and mirroring
sqlboy2000 - 13 Apr 2007 9:02 PM - 4 messages
Hi, I'm trying to turn on service broker so we can use query notifications in a mirrored database. However I get the following when I try to run ALTER DATABASE <db> SET ENABLE_BROKER: Msg 9778, Level 16, State 1, Line 2 ...
Score MSDE 2000 and SQL2005
Mark Bohlsen - 13 Apr 2007 8:45 PM - 4 messages
I have to install MSDE 2000 with a backup application (CommVault Express 6.1) that does not yet support SQL 2005.  I also need to install 2005 for apps that will utilize this version.  Are there any known problems with ...
Score Change table owner to dbo
sxa222 - 13 Apr 2007 8:44 PM - 4 messages
How do I change the table owner back to dbo? ...
Score Licensing for Database Mirroring
Paul Smith - 13 Apr 2007 8:12 PM - 4 messages
The MS FAQ on SQL Server Licensing seems to make it clear that in clustering and log shipping scenarios, a standby server does not need additional licenses, provided it has no more processors than the production server.  Does this apply to a mirror server operating in High Availability mode as ...
Score Full Text - Cannot Delete
Gabe Matteson\ - 13 Apr 2007 7:49 PM - 2 messages
We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same name etc. Everything is working fine with the exception of one database. The issue is that this database full text index is pointing to 'D:\MSSQL ...
Score change MSDE to SQL security
Darin - 13 Apr 2007 7:38 PM - 3 messages
We have an installation that already has MSDE (SQL 2000) loaded on their machine, so there is no enterprise manager or QA. I need to change this to use SQL security and I need to set the sa password. How can I do those from the osql prompt? ...
Score Receiving "Error: 18456" when for a specific user who has rights via AD Group
Keeper of the Bits - 13 Apr 2007 7:06 PM - 3 messages
I have a user who is a domain admin and has rights based on a group policy (OURDOMAIN\Developers) to access the SQL Server.  He can access other Sql Servers, and every other member of the group can access all ...
Score sql server 2005 design
omar - 13 Apr 2007 7:04 PM - 4 messages
We have 160 users using TS session to connec to are sql data base. We whant to know how many sql server do I need for this # of users? CLuster VS Mirror application? Servers requirement? sinle or blade servers (dell power edge)? ...
Score SQL Server 2000 Memory Config
mattde - 13 Apr 2007 7:01 PM - 2 messages
We just put into production our new SQL Server. It is a dual processor quad core 1.86 GHz with 16GB of Ram and the OS is Windows 2003 R2 Standard x64 Bit.  We have the 32-bit version of ...
Score moving SQL data and then shrinking file
Danne - 13 Apr 2007 5:30 PM - 2 messages
I have added a new drive to a server and want to move one of the databases to this drive to alleviate space problems on the original drive.  I wanted to do this with as little downtime to the system as possible and the size of the ...
Score Backup methodologies
Tim Greenwood - 13 Apr 2007 4:54 PM - 3 messages
We have a backup plan that seems  to be working quite well.  My question is more related to ease of using these in case of a restore.  Currently we do full backups weekly, diffs daily and hourly logs.  This leaves alot of files ...
Score Searching whole database
Willie Bodger - 13 Apr 2007 4:49 PM - 5 messages
So, I have as situation where I have a front-end to a database and nothing to tell me what the mappings are from the front-end to the database. And I frequently get asked if I can change this drop down or find this value. It ...
Score Backing up Database
Gabe Matteson\ - 13 Apr 2007 4:36 PM - 3 messages
When I try to backup a SQL 2000 database I recieve the following error in the output log. Any ideas? Thank you. SQL 2000 w/ SP4 [39] Database SolRounder: Database Backup...     Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] ...
Score cannot back up database to a disk file
bing - 13 Apr 2007 3:50 PM - 5 messages
Hi, In EM, I selected a database and 'backup database' from all the tasks list.  But no matter I selected 'append to media' or 'overwrite existing media', I got this error: The volumn on device 'source_webspace' is not part of a multiple family ...
Score SQL 2005 upgrade advisor's impact on the production server?
bing - 13 Apr 2007 3:34 PM - 3 messages
Hi, I'm going to run the SQL 2005 upgrade advisor against our production SQL 2000 server which is running on a windows 2003 machine.  I've downloaded and installed the advisor on my windows XP.  Any pitfalls I need to be aware ...
Score Fulltext index and insert performance
Hardy Wang - 13 Apr 2007 3:00 PM - 4 messages
Hi all, If I enable fulltext index on some tables, does if affect insert performance as much as regular clustered/non-clustered index on same columns? ...
Score Time Needed to Install SQL Server 2005
Jerry - 13 Apr 2007 2:31 PM - 2 messages
We will be installing SQL Server 2005 soon on a new server with 200gb drive, Raid 5, 4gb RAM. About how long should I plan the installation to take? Thank you, ...
Score question about secondary file
Ben - 13 Apr 2007 2:16 PM - 3 messages
Hi, i read about primary and secondary files, but not everything is obvious to me. If i define a database with a primary + log file and 3 secondary files: 1) do i have to also define for each secondary file a log file? ...
Score Free Text Search
Madame Artois - 13 Apr 2007 2:02 PM - 3 messages
We have two SQL Server 2000 servers with SP4 loaded.  We have copied a database from one to the other.  The free text search runs on the original server and produces results but on the new server it runs but produces a nil ...
Score SQL login failed
Mx_Adm - 13 Apr 2007 12:53 PM - 2 messages
Why, This below user login failed SQL ? And this "maximo" user, (dbowner and security admin database roles right) This batch file result screen Fri Apr 13 12:25:49 EEST 2007 --- Starting ---- Reading properties file : maximo.properties com.inet.tds.ap: Msg 18452, Level 14, State 1, Line 1, Sqlstate 01000 ...
Score SQL Server 2005: Lock Escalation
riggson - 13 Apr 2007 7:28 AM - 10 messages
Hi! We are running a client/server application with .NET and SQL Server 2005. Since a few weeks we have some performance problems on the SQL Server. I think the problems results from long locks which sometimes ends in timeouts. ...
Score SQL Server 2000 SP4: Adding a new foreign key relationship hangs
Gorgsenegger - 13 Apr 2007 6:03 AM - 2 messages
Hi all, When I try to add a new foreign key relationship between two tables in Enterprise Manager and then try to save it, the program freezes and doesn't react anymore. There are plenty of tables in the database on ...
Score Application Role
Abhi - 13 Apr 2007 5:40 AM - 2 messages
Hi, We have many applications in our organisation and the backend we are using is sql server 2000 with SP4. some Application using window Authentication and some using sql Authentication. but i do not want user or other person can use the same login details ...
Score server maxing out processor
Ken Smith - 13 Apr 2007 4:43 AM - 4 messages
Greetings, I have SQL Server running on my laptop and for the last few days, everytime I start the laptop I notice that everything is running very slowly.  When I go to Task Manager and look at the processes that are running it shows that ...
Score Log shipping data
erdos - 13 Apr 2007 4:41 AM - 2 messages
For log shipping, is all of the data entered into the primary shipped via the transaction log to the secondary?  I guess it is more of a transaction log question.  Does the transaction log also contain all of the data stored in the db tables?  If yes, does this mean there is ...
Score TEXTIMAGE_ON
Toty Santana - 13 Apr 2007 3:18 AM - 4 messages
I Have a table with TEXTIMAGE_ON specifiying a different file group for BLOB data, but when i insert BLOB in this table i notice that the primary file group file size is increasing instead of the Image file group file. ...
Score database mirroring -- failing over in stored procedures
stevehunter_1 - 13 Apr 2007 2:36 AM - 3 messages
If I have a stored procedure that accesses two databases, both databases are on server#1 (primary) and server#2 (backup) if database #1 fails over to server#2, what is my stored procedure going to do??? SET @value = SELECT FirstName FROM [nameofserver].databaseA.table ...
Score Option (MAXDOP 1)
Ken - 12 Apr 2007 10:51 PM - 13 messages
On more than one occassion I have put this hint "Option (MAXDOP 1) in my queries to get them to run faster, dramatically faster. And this is after optimizing the query for everything else. I've done a lot of ...
Score Help with Reindexing all tables in a Database?
Tmuldoon - 12 Apr 2007 10:47 PM - 2 messages
Hello, I was provided this script: DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN DBCC DBREINDEX(@TableName,' ',90) FETCH NEXT FROM TableCursor INTO @TableName ...
Score Moving databases from one Server to another
tshad - 12 Apr 2007 9:54 PM - 3 messages
I have a new server that I am moving my Sql Server to. I already installed Sql Server on the new machine but didn't create it on the D: drive as I did on my old server.  If I try to use a backup from my ...
Score How to Use Login-Less Users the Alternate to Application Roles
Terry - 12 Apr 2007 9:44 PM - 2 messages
SQL Server 2005 introduces a new type of database user, one that is created using the "WITHOUT LOGIN" clause. This user is not mapped to a login, and is being touted as an alternate to Application Roles because no password is needed.. What I do not understand is how to use ...
Score Execution plan behavior
FredG - 12 Apr 2007 9:00 PM - 10 messages
hello Guru's. Environment: SQL 7.0 SP4 TableA: col1 int Primary Key NONCLUSTERED identity NOT NULL col2 int NOT NULL col2 nvarchar(255)  NOT NULL No other indexes select distinct COL2 from tableA The execution plan performs a hash/match aggregate operation ...
Score etation
Scott H. - 12 Apr 2007 8:34 PM - 7 messages
Folks, Objective: Is there enough resources on this server to create another instance of SQL Server? SQL Server 2000 Enterprise Edition SP3 Windows 2003 Enterprise Edition SP1 4GB Memory The server currently has 1 instance. SQL Server is dynamically managing memory ...
Score Performance in SQL Server
ieuuk - 12 Apr 2007 7:56 PM - 9 messages
Hello, At the moment we're using the free version of SQL Server 2000 and we're wondering whether to upgrade to a full version of SQL 2000 Standard or SQL 2005 Standard but the only problem that we have at the moment is the ...
Score :_17883_in_sql_error_log
db - 12 Apr 2007 7:42 PM - 10 messages
Hi PRODUCT: SQL SERVER 2000 STANDARD EDITION Version: 8.00.760 (SP3) O/S: MS windows NT – 5.0 (2195) ==================================================== Entry in sql server log: Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x03CC38E0. ...
Score Filter records during Transactional Replication.
Query Builder - 12 Apr 2007 6:09 PM - 8 messages
Hi All, I have a table with a column DeletedDate which stores a logical delete of a record. I need to set up transactional replication for reporting purposes that this deleted records should not be replicated to the subscriber. That ...
Score Sproc plan changing over time
Frank Rizzo - 12 Apr 2007 5:38 PM - 5 messages
Hello, I have a SQL Server 2005 (32-bit) system that is pretty much read only.  I have a carefully tuned proc that runs a pretty intense set of queries.  The proc is called once per second.  One query inside the proc ...
Score AWE? / Windows 2003 R2 x64 / SQL Server 2000 x86 / 8GB RAM
mikemiller.innova - 12 Apr 2007 4:33 PM - 2 messages
We had to install SQL 2000 on a 64-bit Intel x64 server. We quickly learned that SQL 2000 x64 can only be installed on 64-bit Intel Itanium (IA64) servers, so were forced to install the 32bit x86 version. ...
Score Restore backup on different machine
JayKon - 12 Apr 2007 4:12 PM - 2 messages
We are moving backups from being written on a local box, to writing tham on a NAS and making a daily copy to a report server. So, to start, I made a manual copy of the backup files to the NAS and then wen't to restore tham. ...
Score Trace SA Login
graz79 - 12 Apr 2007 2:23 PM - 6 messages
I have something trying to get access to my sql server through the SA login (Mixed mode is turned off) so it will never get in but I need to identify what is trying to use the account. I ran a sql profiler and this captured the login failure but supplied ...
Score Long Backups with SQL Agent
brymer28303 - 12 Apr 2007 2:20 PM - 3 messages
We use Omniback for a backup solution.  However most of the time, we could not restore a database from the backups.  We changed our strategy last week to have the SQL Agent to backup all of the SQL Severs to a central location ...
Score how to quote the tabel?
Michael - 12 Apr 2007 2:09 PM - 3 messages
Hi, I have table name like 'xyz\abc1234.test' in SQL Query Analyzer. xyz is the network name. If I put select * from xyz\abc1234.test, it will give me an error msg. What shall I do? Thanks a lot! ...
Score Report of bigger tables
Gustavo Villaran - 12 Apr 2007 1:56 PM - 2 messages
hi, anyone have a script for creating a report of the bigger tables of a database in SQL 2000? ...
Score Databases not showing up in EM on sql 2000, but do in 2005.
Eric - 12 Apr 2007 12:52 PM - 2 messages
We have a SQL 2000 server that started showing 'no items' in enterprise manager. However, when you connect with SQL2005 client tools they show up.  Any ideas? ...
Score Update wizzard (2000 to 2005)
Martin Schweizer - 12 Apr 2007 11:56 AM - 2 messages
zHello I started Microsoft's update wizard  (hope is the correct explanation) to check if something can go wrong if start the real sql update (from 2000 to 2005). As a result I get: I/O error (bad page ID) detected during read at offset 0x0000000020e000 in ...
Score indexed views
Fotis Mylonas - 12 Apr 2007 9:52 AM - 8 messages
Hi all i find the indexed views promising but so limited in their implementation they become uselss. i cannot have the basics like a union or a left outer join inside them. Provided of course that according to the way i have written the query and ...
Score How to print reports automatically
a - 12 Apr 2007 9:29 AM - 3 messages
Hi, We are using SQL Server 2005 for our database. I would like to have a report automatically printed, based on a schedule. In Visual Studio I have created the report. What steps need to be taken to have this report printed without user ...
Score SqlServer 2005 database over VPN
E®!k Visser - 12 Apr 2007 7:38 AM - 4 messages
Hi, Is it possible to access a SqlServer 2005 database over VPN? Are there any articles available on this subject? Tia, Erik ...
Score sql server 2005 -- high availability with multiple databases
stevehunter_1 - 12 Apr 2007 1:54 AM - 2 messages
I am looking to incorporate database mirroring -- "high availability" operating mode in sql server 2005. I am confused, though, because the books online do not recommend this mode with multiple databases on 1 sql server instance.  The thought is ...
Score Why so many logical reads when joining in an empty table?
Eli Tucker - 12 Apr 2007 12:12 AM - 2 messages
Hello.  I'm performing a query that  does a left outer join on several tables that will not have any relevant data in them and will likely be "joined out" of the results.  Here's what the query boils down to: ...
Score Disaster recovery planning question
pdx - 11 Apr 2007 11:42 PM - 4 messages
I have two SQL 2000 Std servers (running on W2k3 Std) connected to an HP MSA 500 G2 storage array. Each SQL server runs distinct/different DBs. The SQL data and logs are on RAID arrays in the storage array. The servers only have ...
Score How to loop through a table
Michael - 11 Apr 2007 8:54 PM - 7 messages
Hi, I have the following table X create table x ( a int ) ; insert x values(1); insert x values(2); insert x values(3); Is there a way to extract each a in table X to get the following print ...
Score Where do I find Management Studio?
jrheltmach - 11 Apr 2007 8:41 PM - 2 messages
Hi All, can anyone tell me where I can get Management Studio? We have a development server with Sharepoint 2007 on it and it has SQL Server 2005 as a backend.  I do have Standard, Enterprise and Developer editions of SQL Server 2005 on cd but don't know which to use to get ...
Score SQL Server 2000 Job / Error 14258: Cannot perform this operation
Joe K. - 11 Apr 2007 8:28 PM - 2 messages
I have a new 2000 database server on a window 2003 server.  When I try to create a new SQL Server job I received the error listed below. Error 14258: Cannot perform this operation while SQL Server Agent is ...
Score Deleted default database, now can't get in
Nancy Lytle - 11 Apr 2007 8:21 PM - 11 messages
Excuse my cross post but I wasn't sure which group was best. I was cleaning up my SQL 2005 instance and deleted my default database (obviously I forgot that i changed it to my default database), now I cannot ...
Score table size
Michael - 11 Apr 2007 8:07 PM - 7 messages
Hi, Isn't there a system view for table size under a database??? I am trying to get the table size information into a table. Thanks a lot!! Michael ...
Score table owner
Michael - 11 Apr 2007 7:40 PM - 5 messages
Hi, Is there a quick to know the table owner in the system table/view or whatever in MS SQL 2000? Thanks, Michael ...
Score In-place upgrade - SQL Express to Standard
Barton Friedland - 11 Apr 2007 7:40 PM - 3 messages
We are trying to upgrade SQL Express Edition to Standard using the SKUUPGRADE=1 parameter as follows: start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=DEVELOPMENT\OFFICESERVERS UPGRADE=SQL_Engine SKUUPGRADE=1 /qb We turned off the SQL Services before attempting the upgrade. ...
Score large varchar update fails on sql 2000 server, works on dev. machine
tkent - 11 Apr 2007 7:26 PM - 5 messages
A production system (server 2003 enterprise edition) sql 2000 server, service pack 4 won't update a sort of large varchar field, which works fine on my development machine, (xp pro sql 2000). try this in the query analyzer: CREATE TABLE [dbo].[tbl_why] ( ...
Score LIKE query slower in SQL2005 than in SQL2000
Fred M. - 11 Apr 2007 7:25 PM - 4 messages
Hi, I had a lot of performance issues when migrating from SQL 2000 (32 bits) to SQL 2005 (64 bits), so I tried to setup a testing environnement to achieve some tests : - Server1 : Win2003 x64, with SQL 2000 32-bits (8.0.2039) ...
Score How to store the result?
Michael - 11 Apr 2007 7:13 PM - 3 messages
Hi, If I want to store the result of "sp_spaceused XXX" into a table? What shall I do? Thanks a lot! Michael ...
Score Finding duplicate based on records in same table
paulcasso@gmail.com - 11 Apr 2007 6:20 PM - 6 messages
I need a help with a sql... Is there a way to find a duplicate value based on different records inside the same table? I got a scenario, where I'm getting same ID with different date... I need to get rid of one with earlier date... ...
Score Usedspace size for each table in a database
Michael - 11 Apr 2007 5:37 PM - 5 messages
Hi, I have about 200 tables under WorkDB database. What's the quickest way to get the used space size for each table in WorkDB? Thanks! Thank you!!! Michael ...
Score SQL2005 Recovery when master log file is missing
Chris Wood - 11 Apr 2007 5:35 PM - 3 messages
Hi, I had posted this problem earlier with no answers. I had a situation where the log file for master was missing. Is there any way to recover from this situation? Thanks Chris ...
Score d99_tmp
gdunnjr - 11 Apr 2007 5:17 PM - 5 messages
I noticed a table named 'd99_tmp' in my SQL Server 2000 db. I nor anyone on my team creatd the this table. The fields are 'subdirectory', 'depth' and 'file'. It contains basically the entire file structure of the D: drive on the server. ...
Score SQL Server 2005 SP2 Backup Errors???
jonphilip - 11 Apr 2007 3:04 PM - 7 messages
Hello, I am getting over 100 errors in the Application event log AFTER installing SP2.  The source of the errors are SQLWriter, SQLVDI, and a few from MSSQLSERVER.  I am using Acronis True Image Server 9.1 to do a image backup ...
Score 2000 to 2005
Steve Westwood - 11 Apr 2007 2:54 PM - 2 messages
Hello.  I am currently using SQL 2000 for developmet for several clients.  I have a new client who wishes to use SQL 2005.  My questions concern the versatility of SQL 2005. 1. If I installed SQL2005 developers edition will I still be able to connect ...
Score Select takes 5 minutes, With linked table takes 35 minutes.
rmcompute - 11 Apr 2007 2:22 PM - 7 messages
A simple select statement is  taking 5 minutes to run in SQL Server.  There are no sorts, groupings or where blocks, simply a Select Field1,Field2, .... From Table.  The table contains 606,775 records.  When a query is run from ...
Score Dropping all Data but keeping constraints and Structure Intact!
wiseteufel via SQLMonster.com - 11 Apr 2007 2:20 PM - 2 messages
Hi All - I have a SQL 2000 database of 60 some tables, with constraints, indexes, PK- FK, and other relationships on them. I would like to drop all data in all tables, knowing that a lot of the tables have full PK-FK-PK-FK .... ...
Score SQL Server 2005, Locks and problems
regismelo@softsite.com.br - 11 Apr 2007 2:10 PM - 8 messages
Hello!    I turn on the "AllowRowLocks" e turn off "AllowPageLocks" in some of my large tables, that have many updates and inserts. SP_INDEXOPTION 'table_name', 'AllowRowLocks', TRUE GO SP_INDEXOPTION 'table_name', 'AllowPageLocks', FALSE GO    But, I'm experiencing many locks, deadlocks and many kinds of ...
Score Installed SQL Server 2005 but Enterprise Manager is missing and so are the databases like Master and
Spin - 11 Apr 2007 1:52 PM - 10 messages
Gurus, Installed SQL 2005 for the first time.  I noticed Enterprise Manager is missing.  So I went into Configuration Manager since it sounded similar and low and behold I discovered that all the databases that get created in SQL ...
Score Execution Plan Query's
Carlo - 11 Apr 2007 1:50 PM - 4 messages
how to save or allocate execution plan sql server...?? Atte., Carlo ...
Score need help with file import
paulcasso@gmail.com - 11 Apr 2007 12:36 PM - 2 messages
Hi, Every week, our credit department gives us a extracted text files.  I have a automated process running as package in the sqlserver and run some scripts to differentiate duplicates and other business rules...Problem I'm having right now is that, the import portion of ...
Score DR Testing
md - 11 Apr 2007 12:21 PM - 3 messages
Hi all - I am working with the DBA's to do some DR testing to see how to recover the Master db if it became corrupted or unusable. We found a bunch of links about doing this, but nothing seems to work. We used the SQL Server 2005 ...
Score identity, indexes, datetime
jb - 11 Apr 2007 10:26 AM - 6 messages
Hi, We have an largish audit table with many columns. There are inserts/deletes only on this table, no updates. Its never been indexed or had a pk. Reports are run against this table, usually on date ranges (datetime col) with joins to other tables on userid etc. ...
Score getting the most out of sql server 2005 express
hlossie - 11 Apr 2007 10:09 AM - 4 messages
Hi Everyone, I know there is a 4GB file size limit and a 1GB RAM limit build into sql server 2005 express. 1. Does this 4Gb file size include the LDF file? 2. If i place multiple databases on one server, does the total file ...
Score Can SQL Server 2005 run on Windows XP SP2
Kjell Arne Johansen - 11 Apr 2007 9:22 AM - 3 messages
Hi In "[link]" I read that SQL Server 2005 Standard Edition can run on Windows XP SP2.  I am sure that I read some place that SQL Server 2005 Standard edition must ...
Score LSN Error: 9003
mpWong - 11 Apr 2007 8:30 AM - 4 messages
Recently I encountered an error related to LSN. The error message was like this: Error: 9003, Severity: 20, State: 1 The LSN (4:304:1) passed to log scan in database 'model' is invalid.. I have to overwrite the model database ...
Score Import Script(repeat)
italic - 11 Apr 2007 7:35 AM - 2 messages
Hello All, I need import some data from one db in one server to another db in another server. I can do it by import/export wizard, but I need do that by script for deployment time. Do you know how to do that? ...
Score Do you disable parallelism on OLTP SQL Servers ?
Hassan - 11 Apr 2007 1:33 AM - 2 messages
We have seen a few problems when we notice high CPU all of a sudden and realize that parallelism is the culprit on our SQL 2K SQL Servers. We have tried to use the maxdop hint to disable parallelism for the respective ...
Score Disaster Recovery - Backups Unusable
Bernard Sheppard - 11 Apr 2007 1:06 AM - 8 messages
Here's the scenario: SQL Server installed (against my recommendation) with Data, Log & Backup all stored on SAN Disk (my preference would to have Log at least on local disk). In theory, SAN was snapshot backed up nightly - transparent to OS / DBMS (it ...
Score After doing in-place upgrade from 2000 to 2005, compatibility mode is still 8.0
cobra - 11 Apr 2007 1:03 AM - 5 messages
After performing an in-place upgrade from SQL 2000 to SQL 2005, the entire instance is still 8.0.  I want it to be 9.0, but don't know how to do that. Next to the server name under object explorer in SQL Server Management ...
Score How can I change a column with datatype "text" to "int"?
Karolus - 11 Apr 2007 12:54 AM - 3 messages
I made a mistake when I first created the column and just found out when I tried to calculate.  I tried using the design feature on Enterprise Manager, but got an error message that this couldn't be done.  Any help is deeply ...
Score High rate of log file growth
OwenC - 10 Apr 2007 10:57 PM - 10 messages
We added several indexs to a DB. We have not changed our number of transactions. The rate of log file growth has moved from about 320MB per hour before the indexes to 2GB per hour after the indexes were added. ...
Score SQL 2000 - Best way to synchronise database across ftp only DMZ
GazJ - 10 Apr 2007 10:46 PM - 4 messages
Hi, We have a need to synchronise data from a number of (Active) SQL Server 2000 databases within a corporate network to 'copies' in our DMZ. Whilst log shipping was originally thought to be the answer I have been informed the DMZ DBs would have to be non-operational which isn't really an ...
Restore database
who deleted primary constraint?
SQL 2005 Hotfixes post initial SP2
Backups to network share fail
Administering SQl 2000 from SQL 2005
2000 SP3 DST Backup Problems?
Lagging behind with 2005
ODBC and user accounts
Import script
DTS package desined in server 2000, but update 2005 database
Can't create partitioned table in Developer Edition?
Stored procedures hanging
Transact SQL Order By problem
query to use
order by does not work
Problem with UNION ALL
Filegroup Restores
sql job history
Noob Diving into DTS Packages
Help with SSIS and Job Scheduling
Moving an encrypted SQL Server DB to another server.
Inserting large amount of rows?
Declare a local var
GO Statement
MSSQLSERVER Service Shuts down
char and varchar
how to select table name
How to backup for network drive
Problem with replace function
copy of existing table and data
Differential backup/restore
Export database as SQL scripts - Primary key
Sql Linked table from Access
Is it possible to determine which user created a table?
Resetting DB
Permission to access dB problem in SQL Server 2005 Express from inside VS2005
can someone please tell me what this dql code does.
SQl Server 2005 clustering
Database benchmark
Next »