SQL Newsgroups: Microsoft SQL Server Administration

Tables Disappeared from Enterprise Manager

Daniel - 5 Nov 2005 10:17 PM - 3 messages

Hello Everyone, My problem is: the list of tables in Enterprise manager had disappeared. The data is still there, because I can query it from Query Analyzer, but I cannot access the tables through Enterprise Manager. Have anyone experienced the same problem? ...

Is there any difference...

Frank Rizzo - 5 Nov 2005 9:42 PM - 5 messages

....in speed between if exists(select top 1 id from table) or if exists(select id from table) Thanks. ...

SQL 2000 / Windows 2003 Server Licensing Question

carlos4382 - 5 Nov 2005 8:41 PM - 3 messages

Hi All, I hope someone can be of help in answering a few questions which I have regarding W2K3 and SQL 2000 Server. I have been searching the web and newsgroups for any info, but I have not found any articles which are clear ...

boot.ini /3GB problem

Pawel Mylka - 5 Nov 2005 6:41 PM - 4 messages

Hello, I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB swich with awe enabled on sql 2000 without any good result. I could said even ...

MSSQL and Firewall

FOX - 5 Nov 2005 3:10 PM - 5 messages

Hi, Yesterday i've activated the SP1 firewall on a win2003 server. On this server i've Mysql and MSSQL running. I've activated all the ports needed Right now everything works except MSSQL On the firewall i've opened port 1433 tcp and udp and the port 1434 ...

SQL query to replace a particular word from all the entries in a column

John - 5 Nov 2005 10:54 AM - 3 messages

There is a field (column) named 'A' of the type 'ntext' in a table 'B' of a database 'C'. Column A has millions of entries carrying a word 'X' e.g. one entry under this column is "There is a boy named 'X' who used to stay here ...

to use or not to use /3GB

Hassan - 5 Nov 2005 7:08 AM - 6 messages

We have SQL Server with 8GB of RAM. And the only purpose of the server is to run SQL. So if i specify AWE enabled and obviously /PAE in boot.ini, and keep the max server memory to 6GB , will it benefit to use /3GB or does it not matter ? ...

management tools for sql 2005?

mp3nomad - 5 Nov 2005 4:49 AM - 3 messages

what tools are available to manage sql server 2005 (std version) databases if you don't have a copy of SQL Server 2005? i.e. connecting to a remote sql server 2005 system for development. Thanks! ...

DELETING 100 million from a table weekly SQl SERVER 2000

harish - 5 Nov 2005 4:03 AM - 7 messages

DELETING 100 million from a table weekly SQl SERVER 2000 Hi All We have a table in SQL SERVER 2000 which has about 250 million records and this will be growing by 100 million every week. At a time the table ...

Types of backup supported with SQLServer Express ?

Mark Townsend - 5 Nov 2005 1:35 AM - 3 messages

I'm an Oracle guy looking at SQLServer Express. From what I can tell from release notes etc, Express comes with the 'simple recovery model' as the default, which is not recommended for applications etc that cannot survive data loss. Can you switch it into one of the other ...

database rename

Paul - 4 Nov 2005 10:53 PM - 6 messages

Hi just wondering how to rename the database using enterprise manager. thanks. ...

"Could not find stored procedure 'sp_sdidebug'" SQL 2005 VERY URGENT

Inês Pires - 4 Nov 2005 10:32 PM - 4 messages

Hi all i have installed SQL 2005 and when i try to run my application it gives me this error . Could not find stored procedure 'sp_sdidebug' what can i do to solve this .... thks JSB ...

security model

ChrisR - 4 Nov 2005 10:10 PM - 2 messages

I need to add developers to a QA box, but need to do it carefully so Im not having to redo it months from now, and am not devoting tons of time to supporting it. Basically they need to be able to read data from certain DB's, but not from ...

cant find file id 3 when trying to restore

Paul - 4 Nov 2005 10:10 PM - 3 messages

Hi I am trying to restore a dbase in mssql2000 and am getting the error cannot find file id 3 on device so it does not restore, just wondering what the problem may be. Thanks Paul. ...

about SET IDENTITY_INSERT

bing - 4 Nov 2005 9:59 PM - 3 messages

Hello, If I did this, SET IDENTITY_INSERT [ database. [ owner. ] ] { table } ON how do I verify it's ON in EM? Bing ...

How to run a script against all databases

Rob - 4 Nov 2005 9:24 PM - 4 messages

I want to run a script to get the file details on each database. Script: Use DBname Select * from sysfiles I want to cycle through the databases using dbname as variable. I tried a bunch of different ways with no luck. Any help or pointers would be great. ...

Poor performance with NEWID()

Dean J Garrett - 4 Nov 2005 9:05 PM - 7 messages

We're experiencing very poor performance on successive runs of queries such as the following: '-------------------------------------------------------------- SET NOCOUNT ON TRUNCATE TABLE tblSurveyTemp INSERT INTO tblSurveyTemp (FirstName, LastName, Email,Sex,Age,City,State,Country,ZipCode,Married,ChildrenAtHome,Education,Em ploymentStatus,Occupation,Industry,Income,Ethnicity,DateSent) ...

PK Index Cluster/Non Cluster

Joe K. - 4 Nov 2005 8:56 PM - 3 messages

I have application that I inherited. Looks to me the indexes where set up incorrectly. Numerous tables have Non-Cluster indexes as Primary Keys that were set up with Identity Incremented by 1. I was told the primary keys that are increasing in numerical value should be ...

Table and File Group

CLM - 4 Nov 2005 8:51 PM - 4 messages

First of all, everything I'm about to talk about is Sql Server 2000 and Raid 5. Right now I have a pretty large table that has grown tremendously (140G) and is on one drive in the PRIMARY filegroup. ...

Q: copy database to another server

JIM.H. - 4 Nov 2005 8:05 PM - 2 messages

Hello,, I backed up my database and it created a BAK file. Now I move this file to other server and trying to restore from it. It is giving me error: Device activation error. Do I have to create database before restoring. I do not ...

Varchar Question

Johnny Fugazzi - 4 Nov 2005 6:56 PM - 3 messages

If I declare a column as Varchar(1), can insert or store data that is longer than 1 character? I thought you could, and was part of the nice features of a Varchar. I am getting errors what I test this. ...

MSDN version of SQL Server 2005 Connections

gencode - 4 Nov 2005 6:52 PM - 7 messages

If I put an MSDN version of SQL Server 2005 on a server that has IIS for testing does the IIS users get limited to 10 connections to SQL at once or is it considered 1 connection? I need to know so we can use it as a test platform of load testing of ...

SQL 2005 Mirroring

Ashkan Daie - 4 Nov 2005 6:40 PM - 3 messages

I got excited when I saw that MS had database mirroring as a new HA option in SQL 2005. After reading through the documentation it seems that it is an unsupported option. "Microsoft support policies do not apply to the database mirroring feature ...

Query: Timeout depending on number of rows retrieved

Alex V - 4 Nov 2005 5:07 PM - 2 messages

I have a query: select * from projet where prcleunik between 70 and 110 Runs fine from all workstations and/or servers. If I change the between statement to: select * from projet where prcleunik between 30 and 110 It runs fine from all workstations and/or servers EXCEPT from our web ...

Does JOINs and VIEWs lose performance when used with more than one DataBase?

Pieter - 4 Nov 2005 4:59 PM - 3 messages

Hi, My application consist of 2 big parts, which work together but are in some way seperate. In case I should store the 2 parts in different databases (but on the same server), will I lose performance when doing a query that joins tables from ...

Huge Transaction Log

Sohail - 4 Nov 2005 4:58 PM - 8 messages

Hi Guys: Any help will be greatly appreciated. I have a database with size around 50 GB where 31 GB is the log size and 19 GB is the data size. By using sp_spaceused, I see around 20GB of unsed space. ...

What does 'refresh services' do?

bing - 4 Nov 2005 4:51 PM - 2 messages

Hello, Can anybody tell me what 'Refresh services' button does in SQL Server Service Manager? I've googled but the search results do not really answer my question, for instance, === Refresh servicesâ€¦ Select this button to refresh the services. ...

SQL Server 2005 Express Edition.... Q

John Smith - 4 Nov 2005 4:46 PM - 3 messages

1.Is the SQL Server 2005 Express Edition is free for production use? 2. Is it available for free download from Microsoft website? 3.Can it be installed on Windows 2000 Professional? Thank you, John Smith ...

Export fails copying dbase from 1 server two another

Paul - 4 Nov 2005 4:16 PM - 3 messages

HI I tried the export wizard mssql2000 and for several dbases it works for most but for 1 dbase it stops after creating all the tables and just says that it fails. I noticed that it only copies over a few of the views so not ...

[OT] SQL 2005 Launch - San Francisco

Kevin3NF - 4 Nov 2005 3:29 PM - 5 messages

So...who's going to be at the Launch in San Fran on Monday? I'd like to meet some of you face to face either Sunday or Monday.. Chime in if you will be there :-) Thanks! ...

truncate on checkpoint fails

paulc - 4 Nov 2005 2:56 PM - 4 messages

SQL 2000 sp4 running W2K sp4 Recovery mode set to SIMPLE. Our hospital software vendor, Meditech, is running a program that checks and validates the information stored in the SQL server with the information stored in the Meditech system. (Our SQL is used as a data repository from ...

Querying table with systemdate

Fred L - 4 Nov 2005 12:36 PM - 4 messages

i have a table vedors linkt wit purchase orders with a due date i only want to se the records with due date = systemdate In criteria of the stored procedure i used = date() ( ms acces query) but this is not working ...

Service vs Standalone : Reason: Not associated with a trusted SQL Server connection

Paul Sjoerdsma - 4 Nov 2005 10:59 AM - 5 messages

Hi, We have an application server that can run as either a service or as a standalone GUI program. If we run the application server as a service on a computer where the SQLServer is not located we get the message above. If we run the ...

Serious SP4 query optimizer bug

Yuri Shustrov - 4 Nov 2005 10:35 AM - 4 messages

Hi! Lets see on example. We have a table with 3 fields (ID, Number, Att).Table is named "test_tab". Unique clustered index created on ID, nonclustered index created on field Number and have very good selectivity. Att field is one of 2 ...

BLOB

Marre - 4 Nov 2005 10:28 AM - 7 messages

Hi all! I want to save some .exe files in a database, but I dont get this BLOB thing How do I declare a BLOB in the database table and as a variable in a stored procedure? Regards Marre ...

Automate Generate Sql Script?

Grant Merwitz - 4 Nov 2005 10:07 AM - 4 messages

Hi I would like to autmate the Generate Sql Script. I am running NUnit testing with one of my projects and i am resetting the database frequently Now, whenever i make any change to my database, i need to regenerate the Sql ...

check memory pressure

Hassan - 4 Nov 2005 7:59 AM - 4 messages

Whats the easy way to check for memory pressure to SQL or if its time to add more RAM or if theres a memory leak Its easy from a CPU or disk perspective to look at processor % or queue length to atleast judge there is some bottleneck, but I have been very ...

Analyse Memory Leak from sqlsrv.exe

MV - 4 Nov 2005 7:39 AM - 3 messages

Hi, Did somebody know what is the best practice to detect Memory/CPU Leaks on SQL 2000/WIN 2000 ? On Performance Manager I can see that sqlsrv.exe use lot of Memory/CPU, now I would know wich DB, Connection or ...

SQL Server 2005 Dev Edn - Limitations?

R3dD0g - 4 Nov 2005 6:55 AM - 4 messages

On the MSDN subscribers download site, the only SQL Server 2005 currently listed (besides SQLExpress) is the Developers edition. What are the limitations imposed by this edition? If I install the Dev edn on a server will other developers (and users) on ...

TRIGGER

-00Eric Clapton - 4 Nov 2005 6:35 AM - 4 messages

Can I implement trigger with visual basic or other programming language and how is it? Thanks. ...

how to test a stored procedure in a sql query analyzer?

Jason Huang - 4 Nov 2005 5:37 AM - 7 messages

Hi, How do we test a stored procedure in SQL Query Analyzer? Thanks for hlep. Jason ...

memory portion tied to -g switch of sqlservr

Hassan - 4 Nov 2005 4:37 AM - 2 messages

I want to know what this is virtual memory address space is . Where can i understand more about this particular allocation and why just 256MB is given for it ? Just a bit confused ...

trigger

-00Eric Clapton - 4 Nov 2005 4:34 AM - 2 messages

Can I implement trigger with visual basic or other programming language and how is it? Thanks. ...

SQL: How to Select MAX(Val1, Val2) ??

bgeris - 4 Nov 2005 3:44 AM - 5 messages

Im trying build a query from c# like below, but its not work, how should I wrote MAX section? int xValue = someIntValue; string sql; sql = "SELECT xmin, xmax, ymin, ymax FROM COORDS "; sql += "WHERE MAX(xmax, " + xValue.ToString() + ")" >= 100"; ...

Deleted Database

LarryF - 4 Nov 2005 3:18 AM - 4 messages

Accidently deleted a db and my backup is two weeks old...any way to recover the db. It was a quirky thing, I was in query analyzer and I must have right clicked and hit delete... I have a quirky laptop keyboard...anyway...is there ...

Login is blank

Colette - 4 Nov 2005 1:46 AM - 3 messages

The DBO Login under Users in the new database we created is blank. In the other databases, it shows "sa" as the Login for DBO. We removed the database and tried again but still get the same effect. Why is it leaving the Login ...

SQLSRVR.EXE High CPU Utilization

msnews.microsoft.com - 4 Nov 2005 12:58 AM - 3 messages

On one of our SQL servers the SQLSRVR.EXE process runs constantly around 80% utilization, and often peaks at 100% for minutes at a time, causing end-user performance experience to degrade significanly. The server is a Proliant DL380 with a single 1.266 GHz PIII CPU and 2GB of RAM. Performance monitor ...

SQL 2005 Copy Database Wizard

John Solgat - 4 Nov 2005 12:53 AM - 4 messages

I have SQL 2000 DE and SQL 2005 DE (RTM) installed on the same machine. I run the Copy Database Wizard and have successfully completed the wizard and now have a database in SQL 2005 that was copied from SQL 2000, approx 23GB. ...

Agent job fails, why?

Olav Tollefsen - 3 Nov 2005 10:46 PM - 4 messages

SQL Server 2005 RTM: I have created a job to copy a database from another server, but the job fails when I try to run it. This is the only information I can see in the Job History: Date,Source,Severity,Step ID,Server,Job Name,Step ...

Attaching Database 'AdventureWorks'???

Steve - 3 Nov 2005 10:43 PM - 2 messages

Hi, I have installed SQL Server 2005 CTP/Trial Version. When I try to attach the database 'AdventureWorks', I get the following error. Could not find row sysindexes for database ID 11, Object ID 1, index ID 1. Run DBCC ...

Disable/Enable Triggers

Joe K. - 3 Nov 2005 10:30 PM - 2 messages

I have stored procedure that disable triggers from another table then completes the body for the stored procedures then enables the triggers. Is there an easy way to complete this task of disable and enable triggers with very little overhead. ...

Database Mail and Application Roles

rogue.wombat - 3 Nov 2005 10:03 PM - 2 messages

I am in the middle of converting our application to use SQL 2005. I need to support "Database Mail" (I guess it was called SQLiMail) as a replacement for SQLMail. As soon as I change into the Application Role lose my access to MSDB ...

SQL 2005 Question

A.M-SG - 3 Nov 2005 9:12 PM - 4 messages

Hi, Which tool replaces Query Analyzer in SQL server 2005? Thank you, Alan ...

Is there a way to group by a rolling count ?

F12 - 3 Nov 2005 8:41 PM - 2 messages

If I have a table of test resuls with a date field I can easily go back and group by month day year etc. But how do I go back and query by groups of 2000 tests? or 4000 or any ...

Excessive locking

__Stephen - 3 Nov 2005 7:49 PM - 6 messages

I inherited a hell hole of a system. This is how a key is generated in my current system: --GET A NEW ORDERID SET @OrderId= (SELECT MAX(Orderid) + 1 AS LastID FROM LAST_ORDERID with (TABLOCKX)) --UPDATE LAST ORDERID TABLE UPDATE LAST_ORDERID SET OrderID = @OrderID ...

Raid 10 with lots of disks. Where to place datafiles

Paul Cahill - 3 Nov 2005 7:26 PM - 4 messages

I'm in setup new server mode so I'm just checking a few things. Say you had 8, 12 or 16 disks purely for data (log on other disks). Do you think it's best to create a single big raid 10 set for a single ...

Why does the presence of a UDF (that is not referenced) in a view cause the execution plan to change

smaully - 3 Nov 2005 6:59 PM - 4 messages

I am running the TPC-H benchmark query 1 and I noticed the execution plan changes drastically if I create a view that projects all of the columns of the table and calls a UDF on a column that will not be ...

6GB Ram, /PAE, /3GB, AWE etc. set Max SQL memory to 4.5GB or 5.5Gb?

Paul Cahill - 3 Nov 2005 6:51 PM - 5 messages

With /PAE /3GB and AWE on a 6GB machine for sql server 2000 only plus the odd windows/compaq util running. Should I set max server memory to roughly 4.5 to 4.75 GB as windows kernel has 1GB with the /3GB switch or am I not understanding correctly? ...

SQL Errors

docsql - 3 Nov 2005 6:45 PM - 2 messages

I am working on a test table AdDB with 5 rows and 3 columns (char 10) COL1 COL2 COL3 ------------------------------------------ null test test ...

Security only to Index

JG - 3 Nov 2005 6:34 PM - 2 messages

Is it possible to create a roll that will allow users to index a database but have no additional administrative functions? ...

DBO

docsql - 3 Nov 2005 6:28 PM - 2 messages

On our dev server the app developers have been granted dbo access to their individual databases. They do not have sa rights on the Dev SQL Server. The problem is that when the app developers create new objects, they are the ...

Creating DDL (create statements) and data (insert satement)

Hendrick - 3 Nov 2005 5:05 PM - 4 messages

Hi, I have about 10.000 rows of data to be copied to another server in another city, I want to create a DDL (create statements) and data (insert statements) via EM but I only get the DDL. How to create the insert ...

SQL Server 2005 & Visual Studio 205 RC

Erik - 3 Nov 2005 4:54 PM - 15 messages

I'm really sad guys... I installed Visual Studio 2005 RC with SQL Express 2005 (included on CD) and it worked very well Today I removed SQL Express 2005 and I was really enthusiastic to install SQL Server 2005 Developer Edition because I belive that is more flexible use ...

What are these "State:" numbers in error messages?

Sarah - 3 Nov 2005 4:02 PM - 3 messages

What is the significance of a "State: " number in an error message in SQL Server 2000? I am using SQL Server 2000 SP4 Standard edition, and I am seeing the below error message hundreds of times if I profile a database for a few minutes: ...

avg of timestamp

chrismtoth - 3 Nov 2005 3:59 PM - 2 messages

Is it possible to use AVG with timestamp? I have a timestamp column with format 00:00:00, and I want to get the average time of all rows for that column. When I try it, I get this error: ...

linked server, join, same query, different plans for different use

CGW - 3 Nov 2005 3:52 PM - 5 messages

We recently moved a database from one SQL server to another and replicated logins, users, permissions, etc. The problem occurs when joins are run from the original server, referencing tables on the new server, using the four-part name. Using the same query, some users time out with an execution ...

Problem replication complex database

Mark Broadbent - 3 Nov 2005 3:30 PM - 3 messages

I have been have real trouble over the last few weeks trying to get an application database to replicate. The database is relatively complex in structure - but not ridiculously so. It doesnt seem to matter what replication technique that is used we always ...

Server Sizing Reccomendations?

rahlquist - 3 Nov 2005 3:01 PM - 2 messages

I was recently alerted to a server request from a division in the company I work for. They were looking for a MS SQL server running quad xenon, Windows 2003 Enterprise with 8 Gigs of RAM and I think their ...

More than 1 mdf and ldf

TroyS - 3 Nov 2005 2:18 PM - 5 messages

I have a database where there are multiple primary files for both the data mdf and log ldf. In this case, there are 2 mdf and 4 ldf..... I want to restore this database to another test environment and I'm having ...

Restore through drive in other server

Alejandra Cornejo - 3 Nov 2005 1:42 PM - 7 messages

Hi all, Does SQL Server 2000 allow restore through drive in other server? This driver is in the Network. Thanks for your help, Alejandra ...

Prerequisites for a hash join

Oskar - 3 Nov 2005 1:31 PM - 2 messages

Hi, In few words: under which circumstances will the query optimizer use a hash join on Microsoft SQL Server 2000 SP3? ...

Help! Oracle linked server not working

ch - 3 Nov 2005 1:12 PM - 2 messages

we upgraded servers and now i can't link to an oracle server old config: windows2000 sql2000 sp4 mdac 2.8 oracle client 9.2 with latest patches new config: windows2003 sql2000 sp4 mdac 2.8 oracle client 9.2 with latest patches ...

Hyperlink

Brennan - 3 Nov 2005 1:09 PM - 3 messages

Is it possible to store an email address as a hyperlink in SQL Server table? Thanks ...

mission impossible: How to protect a Sql Server (with VB.NET) from somebody who as administrator rig

Pieter - 3 Nov 2005 11:26 AM - 10 messages

Hi, I'm sorry for the probable cross-posting, but I need a solution that can be either via Sql Server (preferable) or via .NET... In one of our commpany's we're having a huge problem with a crazy situation: ...

Why LIKE '%' returns result different than LIKE '%%'

mcwiklinski - 3 Nov 2005 10:39 AM - 9 messages

Hi everybody I've encountered a strange behavior of Microsoft SQLServer (version 8.00.194). The following SELECT statement: returns rows with NULLs on column "rdsc", and the statement: returns rows without NULLs. I've checked the same on Oracle (version 9.2.0.5) and PostgreSQL ...

Running the related program on the save server as the database

Andy - 3 Nov 2005 10:21 AM - 3 messages

Hello Community I have a question relating to the recommended setup of the sql server. We use sage with sql backend, both running on the same server. we are experiencing major performance degradation over the WAN but not on the LAN, ...

help

kalikoi - 3 Nov 2005 10:15 AM - 2 messages

Hi I got a table with 2 columns as follows col1 col2 10 193.51 10 194.5 10 202.71 ...

Serious bug in SQL2000 SP4 query optimizer

Shustrov - 3 Nov 2005 10:10 AM - 7 messages

Hi! Sorry for long post. We have an indexed view and about 17 000 000 rows in it. There is 4 fields in it. Clustered index created on unique field. Created nonclustered index with good selectivity on two other field. 4th field may be one of the two ...

Integrity check failures during maintenance plans

DeanM - 3 Nov 2005 7:22 AM - 2 messages

Hi I have maintenance plans which run weekly to check the integrity of all my databases. I have the option 'repair minor errors' turned on and I then recieve the following error when the maintenenace plan runs. I have placed ...

SQL server running out of memory

pradeep_TP - 3 Nov 2005 6:57 AM - 2 messages

Hi all We are using SQl server cluster consisting of 26 servers. Recently our web site has started giving us "time out" error. We do not have access to the production server and we are restricted to only access of the web site. ...

daily data refresh problem

Bob - 3 Nov 2005 6:06 AM - 2 messages

Hi We are a relational datamodel with 123 tables of which we would like to refresh data in 7 tables using sql scripts . The tables should be refreshed with new rows or updated rows. But the problem is that these 7 tables have ...

SQL and NAS

mozziejj - 3 Nov 2005 2:24 AM - 8 messages

Hi To save cost our company wants to move some of the OLTP SQL Servers from our current SAN or direct attach solutions to a NAS solution. Previously NAS was not recommended for SQL Server due to potential I/O ...

Multiple instances

Aziz - 2 Nov 2005 11:55 PM - 4 messages

If I installl 2 standard edition SQL 2K instances on a Server with 4 G RAM. Does it mean each instance can can use its own 2G RAM without interfering with other instance? ...

Alert not triggering

Big Ern - 2 Nov 2005 9:52 PM - 4 messages

I've configured an alert for the TLog that when the server generates error 9002 (out of log space) to kick off a job that will backup the TLog to clear it. I am testing the alert and I receive the error message, but the it will ...

SSPI Context error; SSrvr 2000; occurs when online

L Mehl - 2 Nov 2005 9:47 PM - 3 messages

Hello -- If another ng would be more appropriate for this post, please let me know. I am developing using (LOCAL) server on my laptop. After being connected to the web for a while (not always the same amount of time), querying the db using Query Analyzer or my VB application results in ...

restore database

terry - 2 Nov 2005 9:34 PM - 8 messages

I have a copy of a backup from a user site. a .sbk file.. I have a development server at my work site and an old copy of the database that I use for testing. I would like to overlay my old copy of ...

WARNING: Failed to reserve contiguous memory of Size= 65536.

Carlos - 2 Nov 2005 9:31 PM - 3 messages

I have been noticing this error messages in the sql logs for the past 2 weeks. "WARNING: Failed to reserve contiguous memory of Size= 65536. Buffer Distribution: Stolen=10644 Free=520 Procedures=242566 Inram=0 Dirty=35828 Kept=0 ...

SQL Server 2000 SP4 Performance Problems

Russell Fields - 2 Nov 2005 8:01 PM - 5 messages

Due to conservative adoption policy regarding vendor code changes, we are just now installing SQL Server 2000 SP4 in development. In general things are running OK, but I have a test data warehouse rebuild that is now running about 50% longer. If that reflects the same reality in production then SP4 ...

Problems installing SQL Server 2005

Denis Repke - 2 Nov 2005 7:49 PM - 5 messages

I am trying to upgrade my computer from Visual Studiio 2005 Apr CTP and SQL Server 2005 Apr CTP to the "released" versions. Unfortunately, I made the mistake of uninstalling the Visual Studio CTP "first". After uninstalling it, I was able to complete the installation of the "released" version of Visual ...

Learning SQL Query Analyzer

jhu - 2 Nov 2005 7:31 PM - 2 messages

Hi - I need to learn Query Analyzer for Data Mining as a Product Manager. I know basically no programming but need to learn how to select and manipulate data from databases, etc.. Could someone point in the right direction? ...

Performance: what is faster?

Frank Rizzo - 2 Nov 2005 7:05 PM - 2 messages

I am trying to improve a very performance sensitive piece of the application. The code is trying to ascertain whether there is anything in the table that matches the criteria. I don't actually need the matching data, I just need the knowledge of whether it exists or not. ...

Checkpoints

Naj Parandah - 2 Nov 2005 6:33 PM - 3 messages

Do I understand correctly that iIf I execute the CHECKPOINT statement from query analyzer for a selected database, all uncommitted transactions in the transaction log are physically written to the database at that time? If so then do I need to manually truncate the log at another time to reduce ...

SQL Server 2005 ordered view - not ordered ?

Alex CH - 2 Nov 2005 6:22 PM - 6 messages

Hello, In SQL Server 2005 I have a view which should return ordered data from table. create view View1 as select top (100) percent f1,f2,f3 from T1 order by f1,f3 go but if I execute : ...

Query Analyzer problem

Gregg - 2 Nov 2005 6:19 PM - 3 messages

Hello All, I am having a strange problem with Query Analyzer. I have no problems loading the first script, after the script runs I attempt to open another script to run. At this point Query analyzer hangs, it gets to the point where ...

TDS Problem

Savas Ates - 2 Nov 2005 5:56 PM - 2 messages

Microsoft OLE DB Provider for SQL Server error '80004005' TDS buffer length too large how can i solve it ? ...

Stack Dump

CLM - 2 Nov 2005 5:41 PM - 2 messages

A couple weeks ago I had a stack dump occur but the interesting thing is that the server didn't go AF. So I take it a stack dump can be non-fatal? Is the concept that is just for debugging/troubleshooting purposes and doesn't ...

Mass Import of data into Sql 2000

Brandon Owensby - 2 Nov 2005 5:39 PM - 9 messages

I am working on a project that involves importing lots of data into SQL 2000 from an Access database. One of the tables that I am importing is atleast 95% of the total data being imported. Its 1,600,000 records. Not only is ...

Query Assistance Requested.. Summing Data

EvilReportingGenius - 2 Nov 2005 5:37 PM - 2 messages

Howdy gang, Quick query question for the query gurus I want to crete a query that SUMs a field for the last 7 records in its own field. Here is my @example table Date Money ------------------------ 1/1/01 $100 ...

where did the connections come from?

bing - 2 Nov 2005 5:34 PM - 3 messages

Hello all, SQL 2000 on Windows 2000. I saw quite many login failures for user 'sa' in the SQL server Logs. But except 'Login failed for user SA', no more detailed information about the failures. I also checked Application in the event viewer. For each sa login ...

SQL Server using too little memory?!

Rohan Hattangdi - 2 Nov 2005 5:25 PM - 5 messages

We have two, two node, active/active clusters. Multiple client databases on each node. Web sites with ASP pages go against these databases. Now all these websites are pretty much the same. Same kind of work done on them and so on. ...

daily refresh of data

Latest and next-to-latest query?

Index on foreign key [newbie] ?

Index Fragmentation

Suspect Database

need book reccommendation

SQL 2k Performance help...

Error: %1 is not a valid Win32 application

Bad performance in some questions (100% CPU)

SQL Server Evaluation Copy

SQL Server speed problem

Problem with backup and restore

SQL Server Views question

Sql Agent Job Stuck

Stuck on this outer join

SQL Server Communication.

Permissions question on SQL Server 2000

SQL Server 2005

Precision Scale Problems Between SQL 2K SP3 and SP4

Frustrating Authentication Errors

when/how do you apply patches ?

MDF,LDF,ipaddress

Atomicity

Remove Character from a table?

Index Tuning Wizard (My Workload File)

MS SQL ODBC Enterprise manager

Error restoring MSDB database

Memory Specifications for SS EE running on W2K3 EE

subquery?????

2k5 Management Studio Object Explorer Error

Backup with SQL2000

Time-out error on buffer (Error 845)

tempdb space

drive configuration on new sql server 2005 box?

How to set up Private Network on SQL 2000 EE on Windows 2003

odd deadlocking behaviour

Problem running full text search - it's broken!

multiple instances of spid's

porting dbase user login info ?

SQL 2005 Mirroing Error

Restoring to get a single table

The best way to recreate the index for long reords?

Backup process lock others out of DB?

SQL with linked Access db - problem with ADO update

Update in SQL Trigger Slow - all perf. tuning done.

Delete all content from all tables

sql server 2000 and MSAccess temp table

Job ownership problem

Question about querying database with select statement in SQL Server 2005

Question about NT fibers

trusted connection

SQL Mail/Database Mail niche?

which Is the best way to recreate the index for long reords?

NotificationServices tutorial samples missing (SQL 2005)

Is there any way to tell when a database file grew

table locks

Is Replication of entire server possible?

Database Auto Shrink

SQL 2000 Evaluation

Log Shipping or Replication

Backup job doesn't finish.

How to determine isolation level

DTSRun string

Problem with Charindex function

need suggestions for indexing

What does this look like to you?

Truncate Log 7.0

How to sppol out a query result into a text file?

Cluster Indexes / Non-Cluster Indexes

sqlmaint and differential purges

SQL Server Assertion error

Mirroring problem(sql2005)

SQL Server not recognizing tables that a user owns.

Security Question - Can this be done?

Set simple recovery model to existing DB via sql

Replication between 64-bit and 32-bit?

oracle and sql

MS-SQL 2000 Tape/Hardware Support

Can you create databases that are hidden from SQL 2005 mgmt Studio

Limitations of SQL Server 2000 Personal Edition

Tracing activity on specific object

license question

BCP Temporary Tables

sorting a linked list

Using triggers for hirechical data

What privileges does a DBA need?

Export a table data in INSERT statement

use with SQL server notification services for Auto refresh DataGrid?

Congrats on SQL Server 2005 RTM