SQL Newsgroups: Microsoft SQL Server Administration

Contraint on table

wb - 15 Apr 2006 11:12 PM - 2 messages

I have a table with two attributes (PriceReduction and DiscountPct). Each record must have a value in one of the attributes but not both. When creating a new record, how do I create the constraint when the record isn't ...

Failed to reserve contiguous memory

Gary - 15 Apr 2006 8:41 PM - 3 messages

Hello, (I have to repost it under different header since I didn't get any comment or answer) We faced a problem running Perl script which creates big XML file and inserts it into ntext data type column of the table. ...

q: an update query

JIM.H. - 15 Apr 2006 8:37 PM - 2 messages

Hello, I have two tables. T1: ID,Desc1 T2: Desc1,Desc2 Now, I need to update T1.Desc1 with T2.Desc2 if T1.Desc1=T2.Desc1.Some Desc1 may not be available in T2. How shoud I do this? ...

Dont want stored procs to recompile..

Hassan - 15 Apr 2006 6:40 PM - 4 messages

How can I not have my stored procedures not to recompile whenever ? The reason being is that when they recompile, they at times choose sub optimal plans and causes a lot of pain to our applications. Is there any way ...

SQL Server 2000 Block Analysis (MSSQLSERVER.tempdb)

Scopus69 - 15 Apr 2006 5:55 AM - 3 messages

I have MOM2005 SP1 monitoring my SQL 2000 Server. I am getting the following error: "The program "SQLDMO_1" has been blocked for 38 minutes on database Test in the SQL instance MSSQLSERVER. The defined acceptable blocking threshold is 1 minute(s). "SQLDMO_1" is running on SPID 66 as login DOMAIN\SQLServicesAcct ...

worker thread issues

Hassan - 15 Apr 2006 5:52 AM - 4 messages

Receiving a lot of batches and one slight blip causes our sever to run out of worker threads... how does one go about resolving such issues ? I hate to increase it to 512 if there is a huge cost to it. ...

convert SQL 2005 back to SQL 2000

guoqi zheng - 15 Apr 2006 12:55 AM - 6 messages

Dear Sir, Our new test environment running MS SQL 2005. We have finished an application and need to migrate that to a live server which run SQL 2000. I have tried enough but with no luck. How can I convert our new SQL 2005 ...

Need Extra Rows

michaelloveusa - 14 Apr 2006 10:52 PM - 5 messages

Here is the basic sql I am trying to implement: select classid, count(*) as [COUNT], dtmready from unit where rmpropid = '123' group by classid, dtmready order by dtmready; Here is my result set: A1 3 2006-07-01 00:00:00.000 LUP ...

Query for service pack version

Jeff Kendrick - 14 Apr 2006 10:24 PM - 2 messages

How can I get the service pack version from SQL2000? thanks ...

DB Server Load

Gal Steinitz - 14 Apr 2006 10:00 PM - 4 messages

Hi, My DB server is continously at a very high CPU usage. (80%-100%) It is running a large scale web site with millions of users, so this is expected, but recently we have been getting increased user traffic and ...

SQL Server SP4 Build 2148

Chris F - 14 Apr 2006 9:29 PM - 2 messages

I have a third party software that is requiring SQL Server SP4 Build 2148. When I search for this build, I can't find it. I can locate the hotfix rollups for 2040 and 2174, but not 2148. Does anyone know the link to the ...

Posting?

jcfrith - 14 Apr 2006 8:53 PM - 3 messages

Can you post a question to multiple Discussion Groups? ...

SQL security - hiding databases

Wingman - 14 Apr 2006 7:48 PM - 2 messages

Hi, We are using SQl 2K with sp4. We need to allow one of our customers to connect to our SQL server using EM. The only things they can do are 1. execute a few ReadOnly views in one database. ...

Please help me I am at the end of my tether trying to install the Evaluation copy of SQL Server 2005

ian - 14 Apr 2006 6:10 PM - 6 messages

Please help me I am at the end of my tether trying to install the Evaluation copy of SQL Server 2005. I have installed & uninstalled numerous times but now do not seem to have any component that allows you to navigate through the databases or execute ...

Can you turn off Parallelism in a single stored proc?

landesjoe - 14 Apr 2006 6:09 PM - 7 messages

Hi, I have an INSERT query into a table that hold around 40 million records. For certain values fo the parameters, the insert by the stored proc takes about 50 seconds, if I use the SQL and execute it via Query ...

Tracing Analysis

cbrichards via SQLMonster.com - 14 Apr 2006 5:06 PM - 2 messages

I have these steps set up as a guideline for my tracing; 1. Initially, storing the data in a trace file on a computer other than the SQL Server being traced. 2. Lastly, storing the data by importing the trace file data into a SQL ...

Net Protocols - what if none are enabled?

Thuan - 14 Apr 2006 3:54 PM - 3 messages

Hopefully there's some SQL architect gurus reading... I have a couple servers where none of the Net Protocols are enabled. I'm not sure how they ended up that way. Usually we have at (default?) for TCP/IP then Named Pipes, we have no need for other net protocols. However, ...

Resore all databases with the same logical filename in a loop

q_test - 14 Apr 2006 3:52 PM - 10 messages

I have about 500 databases. They all have the same logical filenames "application_db_data" and "application_db_log". I am moving them from SQL 2000 to SQL 2005 on a new server, keeping all logical filenames. I have a table that stores all database parameters needed for RESTORE: ...

Restore msdb file

Joe K. - 14 Apr 2006 2:08 PM - 2 messages

I had a problem with operating system so copy copied all of my database backup files to another. I reinstalled the operating system and restored all of the except the msdb database. I received the following error when trying to restore msdb database. ...

blob info

Hrvoje Voda - 14 Apr 2006 10:57 AM - 2 messages

I put an image as a blob into database. When I return it and put it into picturebox can I somehow get it's information: PictureSize, PictureType(jpg,gif...) ? Hrcko ...

Production DBAs roles in different groups under a DB Manager

Hassan - 14 Apr 2006 3:09 AM - 2 messages

I am curious to know how some of the big organizations have their DB org structure from an Operations perspective Can someone let me know how its done in your organization and how it has helped ? I am looking for the different groups under say a director/manager ...

SQL Server 2000 query time out

Charts - 14 Apr 2006 2:22 AM - 4 messages

I was shrinking a database of 240 GB size of SQL Server 2000. I ran SQL script in 2005 management studio. DBCC SHRINKFILE (N'db_Data' , 0, NOTRUNCATE) DBCC SHRINKFILE (N'db_Data' , 0, TRUNCATEONLY) GO I made sure the job was not blocked. However after about 10 minutes, I got ...

Backing up to another server problem

Chris - 14 Apr 2006 1:36 AM - 2 messages

I am trying to back up a SQL Server 2000 dbs to another server. The server that the dbs resides on is Windows 2000 Server and the Server I am trying to connect to is Windows 2003 Server. I can map the drive through windows ...

DTS Package And Schedule Job

Travis - 14 Apr 2006 1:35 AM - 2 messages

Hi , I create a DTS package to run a SQL Task. This task will call a batch file. This batch is to unzip the specified file. It works fine in the DTS design enviroment but after I scheduled this package , it failed to run. ...

Import from sql 2000 to sql 2005

Ray Brown - 14 Apr 2006 1:11 AM - 2 messages

We keep running out of space due to the temp file getting so large on the source server. Is there any way to prevent this ? Thanks ...

Urgent : Data Synch between SanFrancisco And Vegas

DKRReddy - 14 Apr 2006 12:38 AM - 2 messages

We are planning to setup Production Database servers in the new location for disaster recovery. Following is my requirement.Please advise me. LogShip Setup from SF to Vegas ...

selecting a set for min value

shivamy - 14 Apr 2006 12:36 AM - 2 messages

Hi, I have the following set and would like to select all rows that have min value of column 4 for a given column 1 and 2 group, irrespective of column 3, as below: C1 C2 C3 C4 ...

selecting a set for min value

shivamy - 14 Apr 2006 12:10 AM - 4 messages

Hi, I have the following set and would like to select all rows that have min value of column 4 for a given column 1 and 2 group, irrespective of column 3, as below: C1 C2 C3 C4 ...

sqlmangr.exe looking for MSVCR71.dll

Randy K - 13 Apr 2006 10:43 PM - 3 messages

We have a brand new Windows 2003 server running SQL Server 2000. Initially we had it set up running one named instance. Things had been running fine. Yesterday when we went to add a second named instance we typoed the instance name. Noticing it after the install ...

SQL time vs OS time

Nergock - 13 Apr 2006 10:39 PM - 2 messages

Does anyone know where SQL Server 2000 gets its time from? Is it still getting it from the OS at startup and then keep its own counter? ...

Alerts not firing off jobs.

ChrisR - 13 Apr 2006 10:36 PM - 2 messages

sql2k sp3 Howdy all. I set up an Alert for deadlocks (# 1205) and have the checkbox checked to fire off a job when it occurs. I then generate a deadlock, but the job never gets fired off. Some important fun facts: ...

How to set ANSI_NULLS on on a existing table?

aj70000 - 13 Apr 2006 9:49 PM - 4 messages

Hi, I was trying to create an index on the indexed view, when I got this error Msg 1935 : Cannot create index.Object 'tablename' was created with the following SET option off: ANSI_NULLS. Is there anyway inside the database to set ANSI_NULLS on for the ...

Transfer DB from one collation to diferent collation

George - 13 Apr 2006 7:21 PM - 2 messages

This is solution # 325335 Or link [link] Transfer a database from one collation in SQL Server 2000 to a different collation in SQL Server 2000 To transfer a database from one collation in SQL Server 2000 to a different ...

SQL 2005 Service Icons

Matthew - 13 Apr 2006 6:53 PM - 2 messages

Is there a way to show the SQL 2005 Service Icons with in the Active Icons on the Start Bar, like SQL 2000 had? ...

cpu going high (100%) after Index is created

subbu - 13 Apr 2006 6:42 PM - 12 messages

Hi, Any idea why CPU is going to 100% utilization as soon as i created index (non clustered) on a table which has indexes already on the table. before creating index the CPU is about 10 to 20% busy, after creating index ...

What's required for reducing tempdb contention with SQL 2000 SP4

dwaine - 13 Apr 2006 6:15 PM - 4 messages

Questions to fix this issue with SP 4 installed: 1) Is -T1118 required? 2) Are multiple data files required? 3) Why isn't this clearly stated? KB article 328551 is unclear as to whether any of the remedies are required ...

query question

Paul - 13 Apr 2006 5:48 PM - 5 messages

Hi I have 3 tables and am wondering if there is a way to do this. I would like a qerry that returns data for a data item but will return only the # of records for the event and not the destination. For example if the query ...

Diagram bug in 2005 Developer edition

Doctor Who - 13 Apr 2006 5:22 PM - 2 messages

I have a few databases which were created using sql server 2000 developer edition. I copied them to the directory where the sql server 2005 databases are located. I used "Attach" by right clicking on databases and attached the databases. When I went to view the diagrams, I got a message that database ...

REPOST: optimizations job for db maintenance plan failed

Jim Moon - 13 Apr 2006 4:55 PM - 5 messages

This is happening on two of our servers. We get the warning in the application log as seen here: [link] But we don't get the SQL Server log entry that is mentioned in that KB ...

Ownership in SQL 2005

Bobby Henningsen - 13 Apr 2006 3:44 PM - 2 messages

Hi there, maybe I've misunderstood something but i just read this phrase in BOL : "All tables in the partition's schema must have the same owner; for example, you cannot have a FROM clause that references the tables [tk].[customer], ...

SQL Server 2005, Compatibility Level 90, and unexpected file size growth

Aidan Marcuss - 13 Apr 2006 3:41 PM - 4 messages

After a hardware crash, we upgraded a development machine from SQL Server 2000 to 2005. We re-attached the 2000 database and changed the compatibility level to 90. In the week since doing this, we've noticed that our database has almost doubled in size, from 100 GB to 200 GB, ...

SQL 2005 Memory Usage Problem

Jim King - 13 Apr 2006 3:34 PM - 2 messages

OK, I MUST be missing something. We have a server running Window Server 2003 Enterprice Edition Service Pack 1. This server has 32 GB of RAM (32767 MB). We have SQL 2005 Enterprise Edition (version 9.00.1399.06) on this machine. ...

Sql 2005 testing with Virtual Server 2005 or Vmware 3.0

jestump - 13 Apr 2006 2:38 PM - 2 messages

I hear there are issues with this setup ? Does anyone have any tools that can test sql pretty hard to see how the 2 are going to act together ? ...

Exec xp_cmdshell in sql2k box

mecn - 13 Apr 2006 2:28 PM - 2 messages

Hi, All users login into an internal application have rights to run a DTS package through app interface. We have a NT group. I need to setup that group has permission to run from the application. That NT group is non-sysadmin to the sql box. ...

Running out of connections in the connection pool.

UJ - 13 Apr 2006 1:57 PM - 5 messages

I inherited a web site that is starting to get the error message: "The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use ...

SQL Server does not exist error

Hong Wang - 13 Apr 2006 1:27 PM - 4 messages

Hi, I have a fail over SQL Server cluster, everything is working fine until this morning> Now all the sudden, I can not open up Enterprise Manager from the server cluster any more. The error message I got is 'SQL Server does not ...

@@SERVERNAME sql 2k

mecn - 13 Apr 2006 1:17 PM - 2 messages

Hi, Diff server name for same sql box. Select @@SERVERNAME and select * from sysservers WHy? @@SERVERNAME returns incorrect name. How do I correct it? THnks ...

Sql 2005 Network Utility Option

neeju - 13 Apr 2006 11:52 AM - 3 messages

Hi All, We had one option in Sql Server 2000 Client Network Utility i .e "Automatic Ansi to OEM Converstion". But i didn't find this option in Sql Server 2005. Our client is using client tools to connect to some of the databases ...

Index Defragmentation

BenUK - 13 Apr 2006 11:10 AM - 2 messages

None of the system tables in our databases have a significant number of pages, and I can't see there would be many scans happening, but in the interests of completeness should system tables be defragmented if they show high fragmentation? ...

DB locked up - mid restore

CJM - 13 Apr 2006 10:57 AM - 5 messages

I have just tried to restore an SQL2000 database to a point in time (using SSMS). It claimed to work successfully, but now the DB is offline, and is marked as "(loading)". I cant detach it, restore it, delete it...I can't do anything with it at ...

Logon failure in sql server 2000

Ernequei - 13 Apr 2006 10:16 AM - 3 messages

Hi every one I have got a problem with my Ms SQL Server: I have defined a server and in the server i am running a rainbow portal, however i cant get my rainbow working because it says that SQL does not exist or access ...

all the data coming from sql unreadable like this one (C???C?E C??CI??)

malbar99 - 13 Apr 2006 9:11 AM - 2 messages

all the data coming from sql unreadable like this one (C???C?E C??CI??) If you go to this page [link] you can see the Arabic character which is typed in the page coming ...

Performance Counter Disappear

theking2 - 13 Apr 2006 8:45 AM - 4 messages

During normal processing SQLServer Performance Counters Disappear. A reboot normally restores the Performance Counters but this is not feasible. How do I restore the Performance counters without having to reboot the server? ...

Save SQL 2000 DB Maintenance Plans

Johnny - 13 Apr 2006 5:48 AM - 2 messages

I have some DB maintenance plans on a SQL 2000 server. This server will be replaced. How can I save the DB maintenance plans and then recreate to the new server ? JT ...

sql cluster install question

kunalap - 13 Apr 2006 4:07 AM - 2 messages

hello hi i have a small doubt. when installing sql 7 or sql 2000 cluster....i usually just begin with the installation off the install files. but i have read soemwhere that you should install MS DTC by running 'comclust.exe' on each node etc before doing an SQL cluster install. ...

sp_help_revlogin

Joe K. - 13 Apr 2006 3:12 AM - 4 messages

Please help me resolve the errors listed below: Must declare the variable '@pwd'. I applied the output from the sp_help_revlogin to the new database server and received the error listed above. Output from sp_help_revlogin: SET @pwd = CONVERT (varbinary(256), 0x01005F43C82227A15DA370F02814C6C0881B3E24BE36761D5CC427A15DA370F02814C6C0881B3E24BE36761D5CC4) ...

Change the collation on the user DB

George - 13 Apr 2006 3:11 AM - 5 messages

Changed the master db collation by using the rebuildm utility from SQL_LATIN1_GENERAL_SP1_CI_AS to Latin1-General, Binary. How do I change the user dbs now? Issue is critical. Please help. George ...

Stored Procedure Error

Joe K. - 13 Apr 2006 12:06 AM - 4 messages

I received the LOGINPROPERTY error when I tried to compile the store procedure from microsoft website. Please help me resolve this error. Thank You, [link] Error: 'LOGINPROPERTY' is not a recognized function name. ...

SQL Server 2000 and 2005 Service Broker Integration?

Paul Widner - 12 Apr 2006 11:19 PM - 3 messages

I'm wondering if I could use SQL Server 2005's Service Broker and integrate it with SQL Server 2000 via a linked server? Is there some other way I could some how use Service Broker with SQL Server 2000? ...

copy a table with sql2005

Mauro Miotello - 12 Apr 2006 10:57 PM - 2 messages

Using managment studio, how can i copy a table and his records, from a server (2005) to another server (express) ? I know how to create a script with table structure, but not with data into.. thanks Mauro ...

Maintinace Plan 2005

RS - 12 Apr 2006 10:06 PM - 2 messages

I have created a DB mantiance plan for SQL 2005 had no luck setuping diffrent schudle for diffirent task in the same DB manitance plan . e.g: Daily backup for the Full Backup Houly backup for the trx log As we used to do in sql2000 ...

Which ODBC drivers should I use???

HNM74 - 12 Apr 2006 9:39 PM - 2 messages

Have a SQL Server 2005 DB hosting tables for a legacy ASP application (meaning, not a .NET solution, no framework installed on server). We are experiencing problems with SPs and I think it may be an issue with driver compatibility. Is there an explicit set of drivers we should be ...

avoiding cursors -- how to do this?

Tim Greenwood - 12 Apr 2006 9:06 PM - 6 messages

OK say I want to execute the following stored procedure for every order that matches specific criteria EXECUTE @RC = dbo.sprPassUpline @lngOrder If my set of orders to process is returned by this query: select lngOrderID from tblOrders where intstatus=3 ...

Tracking triggers in Profiler

Ric - 12 Apr 2006 9:03 PM - 8 messages

Is it possible to add a trigger event in Profiler? For example; I would like to know the start and stop times, duration, etc. for the code in the trigger when it fires. Thanks! Ric ...

implications of compatibility level set to sql server 2000 in sql server 2005

Vadim - 12 Apr 2006 8:34 PM - 2 messages

Hi, We are testing our app on sql server 2005, and it turned out that some sql statements that were allowed in sql 2000 are no longer valid in sql 2005, so we had to set compatibility level of the database to sql server 2000. So now ...

Frant permission to exec a DTS

mecn - 12 Apr 2006 8:20 PM - 2 messages

Hi, I created a DTS job, I need win user group able to exec that DTS through TDYrun untility. How do I grant permssion to that group Thanks ...

Showing execution time in milliseconds?

AFN - 12 Apr 2006 7:56 PM - 12 messages

I always laughed at the stupid executime time counter in the old SQL 2000 Query Analyzer because it showed HOURS (laugh) : MINUTES : SECONDS. But most of the queries I need to optimize return in <1 second. I assumed that ...

Problems with SQL Server 2005 Oracle Linked Server

Problems w/ SQL2K5 Oracle Linked Server - 12 Apr 2006 7:30 PM - 5 messages

I am experiencing numerous problems with a SQL Server 2005 Linked Server for Oracle. The first and most pressing issue is when executing the following statement: Select * from openquery( {Oracle Linked Server}, 'select * from target_table;') Using the above query the results set in SSMS is only a subset of all the ...

Moving Database

c_shah - 12 Apr 2006 7:29 PM - 2 messages

When you move database across different server, there is a problem of orphaned logins. I think this is only applicable to SQL server logins. Windows login are not affected by this. Can anyone confirm? ...

Moving Database

c_shah - 12 Apr 2006 7:16 PM - 5 messages

When you move a database across different server there is a problem of orphaned logins. Does this problem is specific for SQL Server logins? I believe windows logins are not affected by this. can anyone confirm? ...

Create Database's default ANSI settings are off?

RBarryYoung - 12 Apr 2006 5:59 PM - 2 messages

When I create a new database in SQL Server 2005, most of the database Options settings, including all of the ANSI settings are off (False). I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT) were recommended to be ON(True) by Microsoft. If that is so, then why ...

Dead Lock

Farhan Soomro - 12 Apr 2006 5:57 PM - 3 messages

We are using SQLserver 2000 SP3 Standard Version. We are having dead lock and following is log about deadlock 2006-04-12 10:57:05.31 spid4 Wait-for graph 2006-04-12 10:57:05.31 spid4 ...

Filegroups, CPU, & RAID

Brian Shelden - 12 Apr 2006 4:57 PM - 3 messages

Not sure if this is the right forum... I have a table that has its own filegroup on a dedicated RAID 10 array. Somewhere in Books Online I read that you should create a file in the filegroup for each CPU in the server. My understanding is that in SQL 2000, ...

SQL Server unresponsive after ALTER TABLE

Erik Moore - 12 Apr 2006 4:44 PM - 2 messages

When making schema changes to large tables, our SQL Server becomes completely unresponsive forthe duration of the operation. It seems this shouldn't happen on an enterprise database, especially on a multi-processor machine. Is there a configuration change I can make to ...

Licensing question

NetGear - 12 Apr 2006 3:52 PM - 8 messages

We have bought a SQL Server 2005 Standard Edition 1 processor license. Can we install as many SQL Server 2000 instances as we want to a one single processor server legally? ...

SQL Server 2000 DB Detach/Restore

Joe K. - 12 Apr 2006 3:23 PM - 2 messages

I have a new server setup to resolve several performance issues from the old server. New server has Windows 2003 OS and SQL Server 2000 Enterprise Edition as the database server. What is Microsoft SQL Server best practices to move databases from an old to ...

q:remove spaces

JIM.H. - 12 Apr 2006 3:09 PM - 2 messages

How can you remove spaces in the middle of a string, RTRIM and LTRIM does not work ...

Microsoft SQL Transaction Log

matthew.mccarty - 12 Apr 2006 2:35 PM - 5 messages

Can any one recommend a good Transaction Log viewer / analyzer for Microsoft SQL? ...

Maintenance Plan...what is it doing exactly?

stabbert - 12 Apr 2006 1:59 PM - 2 messages

I would like to know exactly what commands the "Maintenance Plan" is executing behind the scenes when the checkbox Reorganize data and index pages is checked on the Optimizations tab on the Maintenance plan. My thought is that it is executing some DBCC DBREINDEX commands across the ...

cannot shrink transaction log

cas - 12 Apr 2006 1:51 PM - 3 messages

I have problems with shrinking the transaction log. I have first backup the transactionlog and then I try to shrink de transaction log with the shrink file command but the log wil not shrink. When I use the DBCC loginfo I see ...

I/O error 1450(error not found) detected during write

neil_rutherford - 12 Apr 2006 1:28 PM - 2 messages

Hi, SQL Server 2000 SP3a, running on Windows 2003 SP1. 16GB physical Memory - /3GB and /PAE enabled in boot.ini 8CPU's 3GB, Showing 16 due to HyperThreading. Running on an Hitachi San. Running an intesive DSS operations and the following error appears. ...

output

Hrvoje Voda - 12 Apr 2006 1:10 PM - 2 messages

How to get a field from a specific column as output parameter? Hrcko ...

Trim All character columns

Ben Rum - 12 Apr 2006 11:51 AM - 3 messages

Is there a quick way to trim all char/varchar columns in a staging table? The current method I use is via stored procedure which generates and executes a SQL statement based on the table name - using syscolumns. e.g. sp_TrimColumns @TableName ...

Inserting data in a view with multiple base tables

joinz79 - 12 Apr 2006 10:28 AM - 2 messages

Is it really possible to insert data in a view defined upon more than one table (note: update works) ? (Maybe the matter's that simultaneous writes don't work and "atomic", single updates (this is the case of an update operation) work ...

Replicating Identity columns in SQL Server2000

John - 12 Apr 2006 9:57 AM - 2 messages

Dear, How can i Replicating Identity columns in SQL Server 20000 use replication tool? Regards ...

Indexed view not getting used - why?

Mike Hodgson - 12 Apr 2006 8:45 AM - 4 messages

I've come across a curious situation where an indexed view I've created is not getting used and I can't think why the optimiser wouldn't be choosing it. The SQL instance is SQL Server 2000 Enterprise Edition (8.00.840). I've ...

SQL BALANCED

GENNARO - 12 Apr 2006 8:24 AM - 2 messages

Hello Everybody, I just wanna know if is possible to balance sql 2000. I mean, my customer wants to install 2 new w2k3 balanced servers (with = WLB or CSS) , balancing Ms SQL2000 as well (read only). Do u think is possible? ...

connect to server name 2005!!!

soalvajavab1 - 12 Apr 2006 8:18 AM - 2 messages

First time I am using sql server 2005. What is the default server name???? I can not see anything in managment studio. whenever i tried to connect OR create database through SQL sever Management studio, it asked me: server type: (here i select Database Engine) ...

How much of memory is too much for SQL on 64 bit

Hassan - 12 Apr 2006 6:32 AM - 2 messages

We want to move to a 64 bit platform . First of all I would like to know if there are any cons w/ 64 bit. I would consider moving to SQL 2005 And second, how much of RAM do you use on such systems ? I dont want to buy ...

Applying the default collation sequence

Alur - 12 Apr 2006 5:50 AM - 3 messages

How can I apply to the all database tables columns the default collation sequence for the database ? ...

SQL 2000 Versions

Vincent - 12 Apr 2006 1:38 AM - 2 messages

Hi all, I was wondering if someone could tell me or advise me of a link for SQL 2000 versions that are avaliable. Is there a personal and standard edition or are they the same? Cheers ...

TempDB log growing

Dave B - 12 Apr 2006 12:09 AM - 5 messages

I am having a serious issue with the log on tempdb growing. I have been running SQL Server for over 5 years and this is the first time I have come across this issue. There are no active transactions (dbcc opentran) but my ...

MS SQL 2000 running on Windows Terminal Services Server 2003

DGBQ - 11 Apr 2006 10:30 PM - 3 messages

MS SQL 2000 running on Windows Terminal Services Server 2003 I have a client who is running MS SQL 2000 a Windows Terminal Server 2003. On this server they have install an ERP package that uses the MS SQL 2000. ...

Drop table's primary key with knowing the constraint's name

Richard - 11 Apr 2006 9:42 PM - 3 messages

Drop table's primary key with knowing the constraint name. Based on some logic, my program needs to create a new primary key. The problem is when the primary key was created, it was not given a name. ...

SQL Server 2k transaction log file

WB - 11 Apr 2006 9:26 PM - 6 messages

I have a very large transaction log file that I want to shrink and make the size smaller. I backed up the file, performed the shrink action and the file went from around 8GB to 25MB. However, it appears that the file size is still around ...

Delete multiple tables?

Olav - 11 Apr 2006 8:49 PM - 5 messages

SQL Server 2005: How can I select and delete multiple tables in Management Studio? Olav ...

Convert GMT to Local Time

hammerin.hankster - 11 Apr 2006 8:42 PM - 4 messages

Hi, I have the following query which works fine, but now I want to convert the date/time to local time (-7 GMT). Select DateAdd(ss, LastOccurTime, '19700101') as EventDate Order By EventDate DESC The LastOccurTime field is in seconds in the database so I have to ...

Displaying customer data

helpful sql - 11 Apr 2006 8:37 PM - 2 messages

Hi all, I need to design a solution that will display customer data from Sql Server tables in an Internet Explorer tab of a third party app, e.g. the third party app has a tab that can display web pages. ...

Raid 5 vs Raid 10 - reads

Dave - 11 Apr 2006 8:21 PM - 5 messages

Will a 6 disk Raid 5 array beat the 6 disk Raid 10 array on reads? ...

How to view permissions for a user?

Olav - 11 Apr 2006 7:39 PM - 2 messages

SQL Server 2005: When I look at the Properties page for a user in the database all the pages seem to be blank, but still I know that the user has some kind of access to the database and to tables. ...

Snapshot replication issue

SSRS 2005 and SQL2000 as the DB engine

Copy Database Wizard and Logins?

Change SQL Server Recovery Model Simple To Full

Query Compilation Plans

Copy Database, can't attach it?

Operations Master Question

bcp out with column name.

Optimizing SQL 2000 SP4 for large amount of memory

file names in backup and restore output

is it possible to alter a table to remove IDENTITY attribute

SQL Server 2000 Backup Plan

exectuing a .bat from cmdexec

Maximum Row Size in SQL Server 2000

sending email alerts from Sql Server

Deleting SP syntax check please...

Database Maintenance Plan

Default database location?

Replacing the disk array

Modelling Active Directory Data

No ability to create maintanance plan in sql server 2005

How to delete the log shipping on the sql server2000??

Where the query is executed ?

insert operation time out

Differences between SQL Server 2005 on Windows 2000 or W2K3

sp_smtp

create a view

Database mirroring?

Problems with SQL users, groups and table access

Setting up SQL Server columns for unicode

SQL Express on Laptop

Specifying identity for inserts

SQL 2005 - How to move database to another partition

UMS Scheduler Hang

SQL Server Express in a shared hosted environment.

time format question

Syntax in dynamic SQL

Profiler trace looking for index usage

Memory managment question

Network I/O error in SQL 2000 ?

Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties

email alert on job failure

Full-text indexing

Query Optimizer

SQL: two count summary table

Replacing the disk array

optimizations job for db maintenance plan failed

Maintenance Plan

Why NOT to buy SQL 2005...

Error when shrinking data file in SQL 2005

good book for 70-431

What is a full-text index?

Disk Array Optimization

SQL Server 2005 Question

DB Last Access Times

Transaction logs will not shrink

Query to another DB

Which Edition is installed?

SP4 Upgrade

error '80004005' on .asp

Cannot Re-attach SQL Server

Upgrade to SP4

Splitting DB into multiple MDF/NDF's, Filegroups, safely reversible...?

Ran out of disk space..

Error message when trying to save modified maintenance plan?

How to create a new Backup device?

Assumptions on Indexing

datatype text is limited to 900 chars

selecting dates out of a char(10) field rather then datetime

UNION ALL between two recursive WITH