SQL Newsgroups: Microsoft SQL Server Administration

Database diagram in SQL Server 2005

Dave - 21 Oct 2006 4:03 PM - 11 messages

I cannot create a database diagram in SQL Server 2005. When I try to create a diagram I receive the message that the database does not have a valid owner. I changed the database owner to sa and yet the ...

Memory

Erencan SAÐIROÐLU - 21 Oct 2006 9:44 AM - 4 messages

Hi All, I have a question. SQL Server 's memory increase always. How can i release SQL Server's memory? When i do stop-start so SQL Server release memory. But i have to release memory a different way. Thaks alot. ...

SQL 2005 SP2

Eric Renken - 20 Oct 2006 11:31 PM - 3 messages

Any idea when SQL 2005 SP2 will be coming out? It is required for a nice clean install of SQL Express on Vista, and we need to start working on setups for Vista, so I hope it comes out before Vista hits the shelves. ...

Cannot enable SQL Broker

mpaine - 20 Oct 2006 10:55 PM - 5 messages

Why would this TSQL fail with "Msg 5058, Level 16, State 8, Line 2, Option 'ENABLE_BROKER' cannot be set in database 'master'.? USE [master]; GO EXEC sp_configure 'clr enabled', 1; RECONFIGURE WITH OVERRIDE; GO ALTER DATABASE [master] SET ENABLE_BROKER I am running SQL 2005 Developer Edition (SP1) with everything ...

Easy Update

doodle - 20 Oct 2006 10:07 PM - 7 messages

can someone please enlighten me. why doesn't this work? It is supposed to remove any periods in the TSUSA_Code field. UPDATE tblLookupParts SET TSUSA_Code = REPLACE(TSUSA_Code, '.', '') ...

MSDE

Diane Walker - 20 Oct 2006 10:07 PM - 8 messages

We are running MSDE on Windows 2000 Server. The version number SQL2000, 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary to apply SP3a? If it is, is the "SP3a" file the same running on both SQL 2000 ...

can tables themselves be fragmented? Index ID 0?

Cory Harrison - 20 Oct 2006 9:47 PM - 5 messages

When I run DBCC SHOWCONTIG I see several tables who appear to be horribly fragmented for index ID 0. I'm assuming this is the table itself? If so, what do I do about it? I can't enter this ID into DBCC INDEXDEFRAG. All of ...

Capture Before/After Data from Multirow Update

Ymerejtrebor - 20 Oct 2006 9:47 PM - 5 messages

Problem: I only get one record of before and after data when performing multirow updates from a single update statement. I want to get before and after data for ALL updated records from the update statement. How can I do ...

How do I delete a registration for a disconnected server?

Dan Walter - 20 Oct 2006 9:32 PM - 2 messages

Hi all: I'm in Enterprise Manager, version 8. I have a SQL server registration pointing to our old db server. The server is now out of existence. I try to right click on the server to delete it, but I get a ...

SMTP Stored Procedure

Joe K - 20 Oct 2006 9:19 PM - 3 messages

I have already set up and configured SMTP server. I have a SQL Server 2000 database server, I would like easy stored procedure that I can send alert messages with this stored procedure. Thank you very much. ...

SQL Server 2005 Linked Server

illusion - 20 Oct 2006 9:01 PM - 2 messages

I'm trying to setup and Linked Server from SQL Server 2005 Standard Edition to Sybase Adaptive Server 8. There is already an ODBC connection to the Sybase server that is working fine. But when trying to execute a select statement from the Linked Server I get the error ...

database mirroring - correction to technet article requested

Keith Kratochvil - 20 Oct 2006 6:11 PM - 4 messages

This is a very informative document: [link] However, I would like to request one correction: Step 4 under "Setup and Security" indicates that you have to specify the partner and the witness. It tells you to to issue "ALTER DATABASE...SET ...

consistency errors and prevention

Stedak - 20 Oct 2006 5:41 PM - 5 messages

What causes consistency errors and what can be done to prevent them? We have a large number (500 or so) of SQL Server 2000 installations with database sizes ranging from 3 - 120 gig. Average database size would be 15-40 ...

Creating SQL Server CE database on server

Chris Karcher - 20 Oct 2006 5:35 PM - 3 messages

Is it possible to create a SQL server CE 2.0 database on a desktop running SQL Server? We're currently building the database on the device itself but would like to prebuild it on the server and just send it ...

Terminology

TM - 20 Oct 2006 5:04 PM - 3 messages

Is there an industry term for when you take one record, find a key, and pair up every other column in the record with the key and then insert each pair into another table. I'm not talking about normalization, I'm just talking about transforming one ...

Index Rebuilds on Clustered NON-UNIQUE Index

cbrichards via SQLMonster.com - 20 Oct 2006 5:02 PM - 14 messages

I have read (elsewhere, not in this forum) that if you have a clustered "NON- UNIQUE" index, that if you rebuild this type of index, the associated non- clustered indexes on this same table are rebuilt automatically. The basis for this is that when a "NON-UNIQUE" clustered index is created, a ...

upgrading from sql 7.0 to sql 2000

Rockitman - 20 Oct 2006 4:34 PM - 8 messages

we have 7.0 running on an old server (Pentium II), and have just purchased a new server. We also have SQL 2000 to put on this server. Can anybody point me to any Microsoft docs that deal with this kind of an ...

database creation durations

Oscar - 20 Oct 2006 3:40 PM - 2 messages

Trying to bring up a server at a DR site and running into what I think are excessive durations for .mdf / .ndf file creation. It takes SQL server 1.5 hours to grab each 50 GB file. Disk subsystem at the site is a local ...

Drop and recreate all indexes

Massa Batheli - 20 Oct 2006 3:11 PM - 8 messages

Sql server 2005 There are a couple of administrators who have repeatedly said they dropped and recreated indexes and performance spiked after a migration and it would be nice to leave no stone unturned in a bid to better performance. ...

The SQL Server collation on SQL Server instance 'xx\yy' is not sup

Shine Achuthan - 20 Oct 2006 3:02 PM - 5 messages

SQL server on a cluster server environment, and when I access SQL server instance and right click properties I could see right collation that I want, but MOSS(sharepoint 2007) installation throws an error in event log. Any one ...

Backup Job Sometimes Stops at msdb

Michelle - 20 Oct 2006 2:50 PM - 6 messages

Hi, We have been using the same stored procedures for backing up our databases for years with no issues. We now have a puzzling issue on SQL Server 2005 (sp1) and msdb. The stored procedure uses a cursor to get a list of databases ...

table row count in system table?

coenzyme - 20 Oct 2006 1:16 PM - 2 messages

Hi all, Is there a system table that tracks the row count of all tables in a single DB? Is there a stored procedure that displays that info? I've received some great scripts from you people that query the ...

Replication problem, update on table with varchar primary key

paolofresujazz - 20 Oct 2006 1:14 PM - 3 messages

hi i have a problem in the distribution of a replicated table. The execution sequence is: -i create a table (the primary key is varchar) -i publish this table -i insert a row in the table (no problem in the replication) ...

Error: can not connect to the database

Nicolas Heyer - 20 Oct 2006 1:03 PM - 2 messages

Hello First of all, let me tell you, I have no knowledge of SQL server at all. We have an SQL Server 2005 that has been installed by an external company. I have installed a new database on it, using the default settings that were ...

Compiled plans and syscacheobjects

tdunsford - 20 Oct 2006 12:56 PM - 6 messages

Hi, I'm wondering if someone knows what causes a compiled plan to get dropped from the cache. We've got one fairly complicated procedure that gets removed from cache every few minutes, and then compiled again the next time its run. The compile takes 10-15 seconds of cpu. The ...

case sensitive collation issues

Jack Vamvas - 20 Oct 2006 12:21 PM - 4 messages

I have a db - DB1 = Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52 It's sitting on a server Collation = Latin1_General_BIN The tempdb = Latin1_General_BIN Note: I created the db from scratch on the server When I run the following CREATE PROCEDURE test ...

case sensitive collation issues

Jack Vamvas - 20 Oct 2006 12:20 PM - 4 messages

I have a db - DB1 = Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52 It's sitting on a server Collation = Latin1_General_BIN The tempdb = Latin1_General_BIN Note: I created the db from scratch on the server When I run the following CREATE PROCEDURE test ...

Best Practice Analyzer scan

dunleav1 - 20 Oct 2006 11:41 AM - 2 messages

I have a scan that is returning an exception. The exception is on a trigger. The trigger does an insert and refers to another object and I don't have the object prefixed with a user/schema within the trigger. My ...

Reducing column size

jasonatkins2001 - 20 Oct 2006 9:25 AM - 4 messages

I want to reduce the length of a column in one of my database tables from varchar(2048) to varchar(900), basically so I can create an index on the column to gain much improved performance. To do this, I am executing the following statement: ...

SQL 2000 SP4 2000.80.2039.0 failed to apply cumulative hotfix KB91

Hong - 20 Oct 2006 7:12 AM - 2 messages

SQL 2000 SP4 2000.80.2039.0 failed to apply cumulative hotfix KB916287 This problem happened when first using a non-Windows Administrator account 10.234: SQL DLL: User Name: soadsgt1 ........ 130.312: 2006/10/18 19:36:00.294 (local) ...

Still Cannot Login sa

Charles A. Lackman - 20 Oct 2006 5:59 AM - 5 messages

Hello, I installed SQL Express using the following Silent Install: SQLEXPR.EXE /qb SECURITYMODE=SQL SAPWD=MyPassword ADDLOCAL=ALL INSTANCENAME=SQLExpress DISABLENETWORKPROTOCOLS= 0 SQLAUTOSTART=1 I cannot login using SQLCMD - E or -U sa -P MyPassword or with MyComputer\SQLExpress ...

Maintenance Plan Configuration

John - 20 Oct 2006 4:10 AM - 2 messages

Hi, I've just started using SQL Server 2005 Standard and I'm moving database across from SQL Server 2000. I have setup a maintenance plan to backup my databases in the new maintenance plan tool / SSIS but I cannot find any option to delete old ...

Database data file does not auto-grow

Ivan - 20 Oct 2006 4:00 AM - 3 messages

Dear all, We are using SQL2000 sp4 on Windows 2000 Svr. We found one of the database size become zero in Enterprise manager. We have checked the database setting and the database is already set auto-growth, without limit, by 1000Mb each time. ...

SQL Server 2005 Express Beta 2

ksspriggs - 20 Oct 2006 2:40 AM - 5 messages

When I try and uninstall SQL Server 2005 Express Beta 2 I get a message that says I must have .NET Framework 2.0 is not installed and I can't uninstall. But I do have .NET framework 2.0 installed! I even recently ran the repair ...

How to recover a corrupted backup file?

Julio - 19 Oct 2006 11:04 PM - 3 messages

(Posting to the right group) I backed up a database (SQL 2000) from EM but because some disk problems the file became corrupted. Aparently part of the problem was the transaction log did was not truncated before (it is twice the size of the data) ...

Selecting ntext from Excel using SQL

ola.alaa@gmail.com - 19 Oct 2006 10:58 PM - 3 messages

i used openquey to select data from Excel or Access files, but i faced one problem when i select a field with ntext datatype, i can't use "Select Distinct" or "Oreder by" with "ntext" datatype because it is not comparable, it gives me this error msg "The text, ntext, and image ...

SQL2005: Unable to allocate enough memory to start 'Query Processor'

Sachin - 19 Oct 2006 10:18 PM - 2 messages

Hi All, I am using SQL Server 2005. It was working fine. However all of a sudden I am getting following error. It fails to start the MSSQLSERVER and SQL Server Agent services with and error: The request failed or the service did not respond in a timely ...

Profiler - details of SP

Thomas.LeBlanc@NoSpam.Com - 19 Oct 2006 9:15 PM - 5 messages

How can I setup Profiler to track/watch the execution of the lines in a stored procedure? It looks like I just see exec sp_DoWork, as TextData. I want to see the sql statements in the SP and how long they each take. ...

SQL 2000 - Scheduled Job causes system errors

Andrew - 19 Oct 2006 7:50 PM - 10 messages

I have a scheduled job that is causing errors in the System Event Log, and I don't know why. The job is a DTS package that has two steps -- first step connects to our AS400 and copies down data, the second step takes that data an formats it ...

restore db from device in sql2005

mecn - 19 Oct 2006 7:20 PM - 10 messages

Need to restore the db from network location. After I click restore from device. The select path box is grayed out. I could not type the network path. (I know i could restore it in query analyzer by using restore code.) ...

Criteria in Inner Join clause

cbrichards via SQLMonster.com - 19 Oct 2006 6:49 PM - 2 messages

Is there any performance benefit by including filter criteria in an Inner Join, rather than in the Where clause? For instance, would there be any performance benefit in one over the other in the following two samples? SAMPLE #1 SELECT ... ...

table snapshot?

tootsuite - 19 Oct 2006 5:55 PM - 3 messages

Hi, I have a question about replication in SQL Server 2005, transactional replication. I have an already existing publication, and I had to add another table (article) to the publication. Obviously, this newly added table on the publisher and subscriber will not automatically be in sync ...

Upgrading O/S

Paul Bergson [MVP-DS] - 19 Oct 2006 4:34 PM - 2 messages

Are there any pitfalls to upgrading a sql server 2000 with W2K sp4 to W2K3 sp1? ...

double subquery...

franz - 19 Oct 2006 4:14 PM - 6 messages

can anyone tell me why this doesn't work??? is a subquery (double) INSERT INTO tCantante (cantanti_nome, cantanti_sitointernet, cantanti_descrizione, cantanti_genere_id) select 'xx', '[link]', label_nome, generi_id from tGenere where generi_tipo = 'soul' and from tLabel where Label_id = '1' ...

legal to sell old version

oakj423 - 19 Oct 2006 3:55 PM - 2 messages

we are no longer using our copy of SQL Server 2000 Enterprise Edition. i though i heard/read somewhere that it was LEGAL to sell/transfer the license 1 time to a new owner. anyone know if that is true. if it is, ...

Backup and Restore Anomaly

FredG - 19 Oct 2006 3:24 PM - 4 messages

SQL Server 2000 SP4 build 2187 Not sure what is happening with SQL Server backup Internals, I am hoping you can answer. A scheduled job backups up database named "Wells" to a device which points to a physical file as step 1. Same schedule job, step 2, then restores to ...

Autogrow Timeouts

Mitch - 19 Oct 2006 3:02 PM - 2 messages

Hello - Can anyone direct me to good articles on Alter database and Autogrow? We have a shared server where users in one database got timeouts. Looking back at the logs, the database was trying to grow during that time frame, but ...

Cross database integrity

Tom McLeesh - 19 Oct 2006 2:48 PM - 5 messages

Is it possible to create foreign key between to distinct SQL databases ? Database A contains table [customers] (primary key : customer_id) Database B contains table [invoices] (each invoice should be linked to a customer. Foreign key : customer_id) I would like to create an integrity constraint between ...

Applying sp4 advice on a server with sql and analysis services

burt_king - 19 Oct 2006 2:39 PM - 3 messages

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be applied together, one before the other, not at all? ...

Relationships and normalization

Nemisis - 19 Oct 2006 2:26 PM - 11 messages

Hi everyone, Hope ur all ok, i have some thoughts about our database design. The database design was already constructed before i came to the company, but we are now re-vamping the software so i would like to sort out the ...

Deleted Log file

Tecnica - 19 Oct 2006 2:20 PM - 11 messages

Hi, I have a database that use two log files. I deleted one of the logs going to database/properties/files select the log file, and remove. Everything goes well, but now when I go to database/properties/files I still ...

SQL Server

Cenk FIRAT - 19 Oct 2006 12:53 PM - 3 messages

do you know in windows 2003 X64 enterprise server and sql server X64 bit machine has a limitation in boot.ini /3G ?? (for sql server RAM is limited 3GB) ...

Kill Process

Cenk FIRAT - 19 Oct 2006 11:47 AM - 3 messages

Is there any T-SQL language command to kill all process in one database? ...

Merge replication publisher subscriber

maroucia - 19 Oct 2006 10:00 AM - 3 messages

Hello I have Publisher and 200 subscribers I need to unload Publisher having added N intermediate Publishers on 50 subscribers to everyone And each intermediate publisher stores data only for it's owns subscribers. Is this possible? ...

Linking Exchange Server to SQL server

Sudarshan - 19 Oct 2006 9:19 AM - 5 messages

I have SBS 2003 - Exchange and SQL Servers are on the same box. I have managed to create linked database and can see Exchange Public Folders in Linked database in Enterprise Manager. Now the problem is how do a access / read the tables ??? ...

Login failed when I execute a job with the command BCP out

Juanjo - 19 Oct 2006 8:49 AM - 3 messages

Hello, As I have already posted in this news group I am working on a SQL 2000 server Log shipping system. And I have found a new issue with one of the jobs needed for the role change. This is the command needed in the job for the syslogins transfer to the ...

how to create row locks

Miso - 19 Oct 2006 6:58 AM - 3 messages

Hello, We would like to use the following concept : There are two processes. First one creates the transacton, makes update on one row via the primary key (by the command UPDATE not by UPDATE CURSOR). We need to achieve that in the duration this transaction ...

sql 2005 analysis services

00KobeBrian - 19 Oct 2006 6:51 AM - 3 messages

Does anyone know where I can get SQL 2005 analysis services tutorial? Thanks. ...

sa not working

Charles A. Lackman - 19 Oct 2006 5:32 AM - 6 messages

Hello, I installed SQL Express in a silent install using the following: SQLEXPR.EXE /qb addlocal=all instancename=SQLExpress SAPWD=MyPwd Disablenetworkprotocols = 0 SQLAUTOSTART=1 The install works just the way I want it to. But when I try to connect to it using ADO.NET or from sqlcmd -U sa -P ...

64gb memory - recommendations, etc..

SQLCatz - 19 Oct 2006 5:20 AM - 2 messages

Multi proc server with 64gb memory. Applications that use SQL Server 2000 & 2005 run on this system. Can someone point me to a site / document / any material that has information about best practices, recommendations, etc about configuring SQL Server to use this much of memory ? ...

MSDTC and Win2K3

Sandeep Gupta - 19 Oct 2006 4:07 AM - 7 messages

We have Windows 2003 OS and SQL Server 2000. We are following the following procedure, as it is an alternate of executing a distributed transaction. Whenever we are tying to execute the following code begin distributed transaction SELECT COUNT(*) FROM OPENDATASOURCE('SQLOLEDB','Data Source= ...

primay key

00KobeBrian - 19 Oct 2006 3:57 AM - 14 messages

How do you assign a primary key to a column in SQL 2005? Thanks. ...

Is this possible with Full Text Indexing?

John Peterson - 19 Oct 2006 2:17 AM - 3 messages

(SQL Server 2000, SP4) Hello all! I am wrestling with a problem that I hope someone can help me with. I have a series of related tables (fairly normalized), each of which has a textual column whose data will, for the most part, be unique from the other tables. ...

BULK LOAD - worked, but with this error msg - meaning?

tootsuite - 18 Oct 2006 11:36 PM - 2 messages

Hi, My bulk load worked, however, I had some messages returned. Just wondering what they mean?? Thanks This is my Bulk Insert stmt: BULK INSERT dbo.[Table_Load] FROM 'c:\admin\myFile.txt' WITH (FIELDTERMINATOR='\t',ROWTERMINATOR='\n',CODEPAGE = 'OEM',FIRSTROW=2) ...

SQL server agent - many jobs starting at the same time

LehrSJ - 18 Oct 2006 10:00 PM - 5 messages

I have a SQL 2000 database server with 250 databases where I would like to do log shipping every hour. If I setup 250 databases for log shipping I am going to have 250 jobs that are set to run at midnight, 1am, 2am, etc. to ...

Processing Queries via Email

RogerT - 18 Oct 2006 9:07 PM - 2 messages

In SQL 2000, we processed queries and return results to user. In SQL 2005, we have not been successful in doing so. I do not see any way using DB Mail to process incoming mail. We have set up SQL Mail and are able to send mail with no problem. We had ...

Stored Proc Writing to File

Daniel Jameson - 18 Oct 2006 8:16 PM - 3 messages

Hi, What are some good ways to write to a text files from a SQL Server 2000 T-SQL stored procedure? Is there something better/more direct than using xp_cmdshell to launch "bcp... -c..."? Can I write line by line? ...

SSIS replace functionality for derived column using ASCII

billsdropbox - 18 Oct 2006 8:14 PM - 7 messages

Hello, This is a problem dealing with SSIS. I am trying to use to replace a value using a derived column data flow transformation. I would like to replace the character " with a blank space. Here is the code: ...

Restoring a database in sql 2005

mecn - 18 Oct 2006 7:53 PM - 6 messages

hi, I have question for restoring a database in sql 2005. After I clicked restore from device. I need to restore a db from \\abc\backup\dd.bak. a Network location. I need to type it the path myself. Sql 2005 doesn't have ...

Log shipping reversal - Two legs in SQL 2000

John L - 18 Oct 2006 7:25 PM - 2 messages

Anyone do log shipping role reversal when two legs are being shipped? ...

detach and attach VS restore from backup

Kim - 18 Oct 2006 6:27 PM - 7 messages

I need to migrate an application from one server to another. I have always in the past detached the db and re-attached to the new server. Was are the pros and cons from doing it this way? Should I be restoring the db on the new server from a backup? ...

Internet explorer lost from server

Bill - 18 Oct 2006 6:15 PM - 3 messages

Gurus-- I am not really sure how it happened but on a small local server that I admin seems to have lost IE, "The E" is missing, I am running xp pro I have a connection to msn dsl on this server and had to reload all os and ...

Reclaiming space on my harddrive after a mass delete.

Steve B - 18 Oct 2006 6:05 PM - 4 messages

I deleted about 20 million rows out of my DB that had about 200 million rows. I expected that I would regain diskspace when showing the properties of that drive, but the disk was not reclaimed. Do I need to shrink that DB in order ...

MIN, MAX and "non-zero" functions?

Maury Markowitz - 18 Oct 2006 5:52 PM - 8 messages

I was somewhat flabbergasted to find that SQL Server doesn't appear to include a mathematical MAX or MIN. No, I can't use them as aggrs, because its in a sub-select. Is there some way to simulate these? ...

Import fails on text field - help

tootsuite - 18 Oct 2006 5:34 PM - 2 messages

Hi, I am trying to import an xls file into SQL Server 2005. It usually works fine, except for when I try to import the "Notes" column. The notes column is just a really long text field. The table I'm attempting ...

SQL 2005 Standard - Cannot Delete SQL Agent Job

RandyH - 18 Oct 2006 5:26 PM - 6 messages

For the life of me, I can't delete a backup job that was created with the maintenance wizard. The job deletes from the Management\Maintenance tree, but doesn't delete from the SQL Server Agent tree. I script the job to drop and get this error msg: ...

Interpret Agent Log Entry

T Morris - 18 Oct 2006 4:59 PM - 2 messages

The log entry 2006-09-19 21:16:06 - + [000] Request to run job 0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused appears in our SQL Server Agent log. I'm try to track the source. So I'm wondering what the hex value refer to and the bit "(from Alert 11)". ...

Downgrade sql2000 to sql7

B. Horstmanshof - 18 Oct 2006 4:44 PM - 9 messages

I have a sql2000 server that I am contemplating downgrading to sql7.... The scenario is this: The server was originally NT4, upgraded to Server2000. The server ran Accountmate using SQL7. SQL was upgraded to 2000. Turns out that the SQL2000 is not entirely compatible with the Accountmate - ...

number of schemas limit 2005?

Stolicow - 18 Oct 2006 4:15 PM - 2 messages

Does anyone know of an upper limit in SQL Server 2005 on the number of schemas that can be created in the Enterprise version? Or any other version? ...

Looking for Info on Full Text Catalogs with a 'Recovering' Status

robcam817 - 18 Oct 2006 4:14 PM - 6 messages

I have not been able to find any information on Full Text Catalogs (FTC) with a status of 'Recovering'. If anyone can help me by responding to my questions, I would greatly appreciate it. 1. How does a FTC get a status of 'Recovering'? ...

nvarchar versus varchar performance

jasonatkins2001 - 18 Oct 2006 3:41 PM - 10 messages

Hi all, I am performing the following simple query: select [TestCol1] FROM myTable where ([TestCol2]= N'test-title' and [TestCol3]=28) TestCol1 is data type int TestCol2 is data type nvarchar(2048) TestCol3 is data type int myTable has approx 7.5 million records. ...

BCP Utility with null values

Ron - 18 Oct 2006 3:09 PM - 2 messages

Hi all, I am using BCP to output from a table that has some empty values into a flat file. I noticed that when I try to use BCP to upload the flat file into an exact replica of the table in another server I get an ...

Indexing a view that contains text or ntext

archuleta37 - 18 Oct 2006 2:56 PM - 2 messages

I've created a view and started to create my first index (unique, clustered) but got the following error: "Cannot create index on view 'MyDB.dbo.myview'. It contains text, ntext, image or xml columns. (Mircrosoft SQL Server, Error: 1492)" ...

case sensitive to case insensitive

Jack Vamvas - 18 Oct 2006 2:11 PM - 6 messages

I've just restored a db (which relies on CASE INSENSITIVE) to another db server which happens to have been set to CASE SENSITIVE. Is it possible to change the settings of just 1 db within the overall sql server instance, to allow it to continue as case insensitive.? ...

Restrict result rows with a database setting

Butch - 18 Oct 2006 2:02 PM - 4 messages

I am using SQL Server 2000 SP4. Is it possible to limit the number of returned rows in a query via some sort of database setting? We have a customer table with over 100,000 records and are not able to modify the ...

CHECKDB allocation error

peti - 18 Oct 2006 1:15 PM - 8 messages

Hello all, I've got this error as result of CHECKDB command: CHECKDB found 1 allocation errors and 4 consistency errors in database 'Data'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Data ). It looks like the CHECKDB with repair_allow_data_loss can solve the problem. ...

Differential Database Backups Strategy in SQL 2005

Olivier Matrot - 18 Oct 2006 1:13 PM - 9 messages

I would like to implement the Backup strategy that is documented in SQL 2005 BOL : "Differential Database Backups Strategy (Full Recovery Model)". Let's say that I would like to perform a full database backup every hour, log backups every minutes, differential database backup every 10 minutes. I ...

Upgrade hardware - WINNT vs Windows

Paul Bergson [MVP-DS] - 18 Oct 2006 1:03 PM - 3 messages

I'm in the process of upgrading my hardware on my sql 2000 server. The current sql server o/s is Windows 2003 with a system root of c:\winnt. The new windows 2003 system root (By default) is c:\windows. ...

Problems when performing RESTORE DATABASE on Windows XP Mediacenter with Intel Core Duo

Hilarion - 18 Oct 2006 12:47 PM - 4 messages

Hi! We have an application, which as a database server uses MS SQL Server 2000 Desktop Engine (MSDE; SP3a version). One of the application users reported that after he switched computers (installed our application with MSDE on a new ...

keeping TRN files

MSUTech - 18 Oct 2006 12:29 PM - 3 messages

Hello All, I was wondering if anyone has some 'general rules' on how long they hold on to TRN files? thanks... ...

Finding Indexes for a table

aaron - 18 Oct 2006 10:42 AM - 3 messages

I want to delete an index for a specific table. Normally I would use: IF EXISTS (SELECT name FROM sysindexes WHERE name = 'name_of_index') DROP INDEX table.name_of_index where name_of_index is called "ID" (I know, I know, but not my idea) ...

checkpoint process and flushing pages

Mark Baldwin - 18 Oct 2006 10:28 AM - 4 messages

I have a server that has just been upgraded from 1Gb RAM to 4Gb. Previously, the cache was only around 800Mb and I could see that alot of data was being flushed from the cache in order to bring in new data. ...

ASP query to SQL db

amatuer - 18 Oct 2006 9:57 AM - 7 messages

<% Datum = "1/1/2005" Datum = cdate(datum) Datum2 = datum + 9 Datum = Month(Datum) & "-" & Day(Datum) & "-" & Year(Datum) Datum2 = Month(Datum2) & "-" & Day(Datum2) & "-" & Year(Datum2) sql = "SELECT R_Reenval.NAAM, R_Reenval.Jaar, R_Reenval.Maand, ...

Need Advice on Reporting, End User Query and Data warehousing Tools

jcvoon - 18 Oct 2006 8:04 AM - 3 messages

Hi: I need an advice on Reporting, End User Query and Data warehousing Tools Below is my customer requirement: Reporting: - Flexible Reporting and Web Publishing - Development and / or customization of reports by systems users using a GUI based reports designer ...

Rebuild Index

Cenk FIRAT - 18 Oct 2006 7:46 AM - 8 messages

Today our rebuild index task worked about 4 hours. at this moment our table was locked and we didn't reach table. how many times in a month(or week) rebuild index task must work? ...

import an excel file

00KobeBrian - 18 Oct 2006 7:08 AM - 5 messages

I tried to import an excel file using import/export wizard. When I launch it, it gives me an error: The SSIS Runtime object could not be created. Verify that DTS.dll is avaible and registered. The wizard cannot continue and will terminate. ...

query in report model

00KobeBrian - 18 Oct 2006 6:14 AM - 2 messages

How do you define a query as a data source to report model inSQL 2005 reporting service? Thanks. ...

x axis legend in chart

00KobeBrian - 18 Oct 2006 5:15 AM - 2 messages

I am running a simple bar chart report using report builder in SQL 2005. In the x axis, origionally the value is 1,2,3,4, ... from the table but now showing a,b,c,d,e ... Does anyone know how to fix it? Thanks. ...

Increasing Storage in SQL Server 2005 Express

Soddy - 18 Oct 2006 5:11 AM - 4 messages

Hello! I believe I saw somewhere that the storage size in SQL Server 2005 Express can be increase from the default size. If this is true, where can I get the info on doing this? ...

clickthrough report

00KobeBrian - 18 Oct 2006 2:34 AM - 4 messages

What is a clickthrough report and how do you create it? THanks. ...

security in report created in report buillder

Cannot start up local server

Buying SQL Server 2000

Upgrade from 2000 to 2005

Updating the composite primary key?

Memory - PAE, AWE, /3GB

Msg 7391, Level 16 The operation could not be performed because OL

Table sizes in DB

When SQL Server reads a page does it always read 8k?

Convert System tables to User table in SQL 2000

Feedback on design issue sought

Back up the transaction log for the database to free up some log space.

Moving SQL Server 2000 from an NT4 to Active Directory

Deleting Database users in 2005

how can a sql server consume a web service

Export data without bcp

Multiple Databases/One SQL Server instance

Formatting a float in varchar but NOT in scientific notation

Compatibility level SQL Server 2000 (80) on SQL Server 2005.

Linked server on a different domain

How create Excel linked server without Security Admin

Null value in definition in table sys.computed_columns for UDF return table value. (SQL Server 2005)

High CPU utilization

Unable to create backup file on local pc if db is on remote server

SQL Server 2000 SP4

Missing Data folders

MSSQL2K and WIN2K3 SP1

Knowlege transfer Template

DTS from 2000 to 2005

Changing the table schema in Subscriber (only)?

Uninstall SQL 2000 on SBS

import an xml-file to sql2005

How to un-do a trigger?

Query results discrepancy

Low Processor Usage

SQL05 Import Wizard Truncation?

Cannot Access TempDB Statistics Info

SQL dies when it as soon as it takes all the available memory allocated to it.

Copying schema

error code 17058

SQL Connection Issues w/ Local Database

Log Shipping

Backup 2005 Express

query multiple databases on different servers

Encrypted Triggers.

Integration Services Configuration on Cluster

Architecture SRV pour Windows SQL SRV std

Error: 18456, Severity: 14, State: 16

What is a .trn backup log?

drawbacks of Saving documents to Sql server

Resuming Log Shipping (SQL 2000)

SQL server job schedule issue

T-SQL programming book

De-normalization

tune vb app

Using bcp with parameterized store procedure

how to check for column Existance

Need help to get automated emails

Recover SQL Server Data/Agent Tasks from old Data folder

Converting time to day

Outer Join Challenge

allow direct updates to systemtables

Restore Error

mssql 2000 v/s raid 5ee

Excel and SQL Server - Book?

Best practice for managing multiple servers

Query Question

Need help restoring a bak file