SQL Newsgroups: Microsoft SQL Server Administration

Creating relationship between column and replacement column

Steven K0 - 11 Feb 2006 11:49 PM - 2 messages

Hello, I have a table (tblManchineParts) that is the list of all machine parts. The second table (tblReplacementParts) is a list of all the machine parts and the machine part that replaced it. I tried to create two foreign key ...

Create query from table SS2K vs. SS2005

Steven K0 - 11 Feb 2006 11:21 PM - 5 messages

Hello, When using SS2K, you can create a query by right-mouse click on the table and then selecting "query" in the Enterprise Manager. How do you do this in SS2005 when using the Management Studio? When I right-mouse click on the ...

sql server 2005 "Change Type" is grayed out

Steven K0 - 11 Feb 2006 11:15 PM - 2 messages

Hello, I am trying to create an update query using the following steps: Right mouse click on table Select "open table" Once I click on the table, I can select most items from the "Query Designer" toolbar. I can select the Diagram, Criteria, SQL and Results pane. ...

System-wide 'min memory per query' error

matt139 - 11 Feb 2006 4:01 PM - 2 messages

Hi everyone, I'm posting a server-wide issue I'm getting on a Windows SQL 7 server and a Windows SQL 2000 server. Each server has several databases (the SQL 2000 box has alot more than the older 7.0 server), ...

Dts problem with dual installation of sql 2000 and 2005 on same box

Colin Robinson - 11 Feb 2006 3:36 PM - 9 messages

I have Sql 2000 installed first, and a second install of Sql2005 installed as an instance on the same win 2003 server. Dts 2000 designer is raising errors on initialisation. When you attempt to create a new package there are no icons in the connections toolbox. ...

Any way to kill zombie locks by commandline?

Marc Bauer - 11 Feb 2006 11:09 AM - 6 messages

hi we have some troubles with a object that kills our SQL2000SP4. CPU spikes to 100% and stay there. We are searching for a solution, but currently don't have one! So it comes to situation where a object named ...

Slow SQL Server

Islamegy® - 11 Feb 2006 9:57 AM - 7 messages

We have upgraded From Win2000 Server to Win2003 Standard with sql server2000 SP4.. after upgrade all our program which connect to the server is too slow.. doing update or save operation on a table with 100,000 record talk 5 sec or more if few people work on the same table, with the old ...

Drop-down in DTS Package cut off

JKKUS - 11 Feb 2006 12:43 AM - 4 messages

When working in DTS, specifically in the Transform Data Properties window, when I click on the drop-down in the Table/View field the path will only extend for the width of the field, even if the path name is too long to fit ...

Converting SQL Server 2000 database to 2005 format

imarchenko - 10 Feb 2006 11:51 PM - 3 messages

Hello! We have attached our 500GB SQL Server 2000 databases on 2005 server. The process took literally took 10 seconds. I was wondering if databases should undergo low level conversion when moved to 2005 environment in order to take ...

Data and log files and Raid

DWalker - 10 Feb 2006 11:44 PM - 3 messages

I have a development SQL 2000 server system running on Windows 2000 Pro. I keep this system updated with all production data so I can test everything. This question might not be answerable without knowing what kind of data ...

Overwrite data file

KMP - 10 Feb 2006 10:05 PM - 2 messages

Is there any way I can overwrite only one data file of the database with a newer one? Both the files (old and new) belong to the same database but the newer one has some additional data. Additional data was added in-house and ...

SQL Server 2005 developer - product key

The ants are driving me crazy - 10 Feb 2006 9:57 PM - 3 messages

I bought a copy of the SQL Server 2005 developer edition, but it is asking for a product key. No product key is provided. From the box and packaging I appear to have a legitimate version. MS refuses to ...

Re: Analysis Services Migration

Adam Plocher - 10 Feb 2006 9:19 PM - 3 messages

Yeah the AS stuff is on the same machine as the database is. I'm trying to get that data to get moved to our new SQL2005 server, with no luck. Thanks -Adam ...

Managing Indexes on large tables

Sinister China Penguin - 10 Feb 2006 7:03 PM - 8 messages

Hi I wonder if anyone could give some advice around managing a non clustered Index on a large table: rows reserved data ...

Bypassing recovery for database 'mydb' because it is makred IN LOAD

Matt - 10 Feb 2006 6:13 PM - 4 messages

Hi, Im having a problem with a SQL server that gets an error after trying to restore a Database. The restore says completed but it doesn't actually complete. I have tred the Knowlege base artical 822852 with no luck still ...

internal server error

Dan Holmes - 10 Feb 2006 5:11 PM - 3 messages

Ideas on this one? SQL Server 2000 Msg 8624, Level 16, State 8, Line 1 Internal SQL Server error. this is the offending SQL select distinct orlc.orderid, orlc.releaseid, 'BBI', 'AUTO', (select count(distinct orderid) from InventoryDetail id1 inner join orderreleaselinechild orlc1 on (orlc1.containerid = ...

Sql 2000 Query Question

Izzy - 10 Feb 2006 4:48 PM - 3 messages

I'm wondering why these two queries yeild different results. This query returns no records, there is one record in the Company table SELECT C.CMP_ID, IH.IVH_INVOICENUMBER FROM COMPANY C ...

The MSSQLSERVER service terminated unexpectedly

John - 10 Feb 2006 4:44 PM - 3 messages

We are getting the following error on our database server, and it is wreaking havoc on pooled connections from our intranet server. The service restarts immediately, and there is nothing in any of the other logs to indicate what might have caused the problem. ...

sql 2000 scripts

farshad - 10 Feb 2006 3:47 PM - 2 messages

How can i set something up so that a new sql script is generated on a regular basis for the tables, stored procedures ? This is because the tables, stored procedures change once a day. So that we can just run the generated scripts on the required sql servers. ...

automatically set database to simple recovery upon creation

mp3nomad - 10 Feb 2006 3:37 PM - 3 messages

Is there a way to set the recovery model of any new databases created on SQL Server 2005 to Simple instead of Full? I would like the recovery model to default to Simple for any new databases created on the server. ...

No security fixes in SP4?

ChrisR - 10 Feb 2006 2:21 PM - 2 messages

I was just glancing over the list of fixes included in SP4: [link] and surprisingly I don't see any security fixes. Are these on a seperate link somewhere? TIA, ChrisR ...

SQL 2005 Client Tools

Chris Marsh - 10 Feb 2006 2:01 PM - 3 messages

In the old days of SQL2000 we could install the SQL Client Tools onto one box but not all of SQL Server. I have installed SQL 2005 a few times now and haven't noticed that option of just installing client tools - is that ...

SQL2000, need to move a database to a different disk

cqmman - 10 Feb 2006 1:05 PM - 4 messages

Hello, I have a database that is in production. The database is a SQL2000 database (SP4), but stored on c:\. I would like to move the DB to F:\. What is the best way to do this? Backup the DB, delete it, recreate a ...

Format File Problem - sorry did the first post wrong

Chris - 10 Feb 2006 11:43 AM - 5 messages

I have generated a format file with bcp (SQL Server 2000) which generates a file which would work if there was a column to column relationship between the csv file and the table. My csv, however is in a different order. ...

Format Files

Chris - 10 Feb 2006 11:37 AM - 2 messages

I have generated a format file with bcp (SQL Server 2000) which generates a file which would work if there was a column to column relationship between the csv file and the table. My csv, however is in a different order. ...

Union Query

accyboy1981 - 10 Feb 2006 11:34 AM - 5 messages

Hi, I've got two table of sales data that contain a days sales activity. Currenty I run two separate queries: select top 25 [timestamp], sales from salesTableOne where timestamp between '02/02/06 00:00:00' and '02/02/06 23:59:59' ...

SQLServer 2005 - Problem with 'Text In Row' + Not Like 'some text%

Simon Kaye - 10 Feb 2006 11:13 AM - 3 messages

Is there any reason why thie 'Text in row' optimisation would cause problems with using like clauses? The code below illustrates a problem we discovered when using this optimisation on SQLServer 2005 - a Null value in a row would previously not ...

Copy a big Diagram in SQL Server

Erwin Moller - 10 Feb 2006 10:53 AM - 2 messages

Hi group, Does anybody know a way to copy a rather big diagram in SQLServer to the clipboard? I need the diagram in my documentation (HTML) and would like to grab it as 1 picture and use it in the documentation. ...

any reason why a query takes longer to run on 2005 ?

luna - 10 Feb 2006 10:23 AM - 4 messages

any reason why a query takes longer to run on 2005 ? sql 2000 query takes 7 seconds same query pasted into sql 2005 takes 56 seconds sql 2005 server is pretty much 10x higher specification query :- SELECT Personal.ID, Personal.Surname1, Lead.DateLeadReceived, ...

Executing Store Proc BCP Statement

Jaydip Das - 10 Feb 2006 9:51 AM - 2 messages

I have a store procedure and I want that result of that procedure queryout to a excel sheet. like bcp "DatabaseName.Owner.Procedure_name" queryout "C:\Folder\testproc.xls" -c -q -S"ServerName" -T Is it possible?? *** Sent via Developersdex [link] *** ...

OPENXML : missing msxmlsql.dll

Fahim - 10 Feb 2006 5:19 AM - 5 messages

Hi, I am facing a problem with OPENXML. When I try to use OPENXML function I get this error : Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 18 Failed to load msxmlsql.dll. I'm running SQL Server 2000 with SP4 and I have SysAdmin privileges on the ...

Table locks from view

bsg075 - 10 Feb 2006 5:08 AM - 3 messages

I am working with a system that is encountering a significant number of blocked processes, and occassional deadlocks. I believe I have a solution, but I first need to confirm something about locking in SQL Server 2000. Given an view with 5 table joins, and a SELECT statement that only ...

Remaining connection

FJC - 10 Feb 2006 3:49 AM - 3 messages

We are running SQL2k and one of the users is accessesing one of the databases through the front-end applications, the problem is that the connection is never closed after the user closes the front-end application and the other ...

High Number of lock requests

FJC - 10 Feb 2006 3:37 AM - 3 messages

We're running SQL2K over 2K server, there server just has one main database besides the system' ones for our administration system Recently we got a tool for monitoring the server and it's registered up to 5.500.000 lock requests/min, my point is, is that normal? ...

duplicate in text file

Johnfli - 10 Feb 2006 12:08 AM - 3 messages

I have my SQL server reads a text file into a temp table, then it copies that data over to a main table, but it looks to see if a particular filed has a certain value, if it does, it updates that record instead of creating ...

dual-core server

Andre - 9 Feb 2006 11:47 PM - 3 messages

I'm looking at purchasing a new SQL Server - a Proliant of course. My research tells me that the new Intel dual-core Xeon is the way to go. I'm also hearing that the new SAS drives are the new standard, and also slightly ...

Unexpected Backup

michael - 9 Feb 2006 11:33 PM - 4 messages

Every morning at 8AM, my SQL Server 2005 produces some database backup that is not a part of any "Job" or "Maintenance Plan". If you look in the Windows NT Application browser, there is an Event: 1073760088, Source: MSSQLSERVER, User: NT AUTHORITY\SYSTEM, Category: Backup, which occurs. ...

Fatal Exception in SQL Server

Huy (Andrew) V Nguyen - 9 Feb 2006 11:22 PM - 4 messages

Hello, We got a SQL Server (no SP) running on Win 2k SP4. Recently been getting this error message in event viewer and at the same time the program that access SQL Server crashes. Error: 0, Severity: 19, State: 0 ...

How to connect to SQL Server Express db in SSMS??

egraham - 9 Feb 2006 10:33 PM - 2 messages

I am using SQL Server 2005 with SQL Server Mgmt Studio. I would like to be able to connect to a SQL Server Express database within the SSMS. I read on MS's website that this was possible, but can't figure out how to do it. Is ...

SQL Express issue with McAfee VirusScan

Russ - 9 Feb 2006 9:53 PM - 4 messages

We've encountered episodes of SQL Server 2005 Express intermittently "pausing" for up to 30 seconds on a PC (WinXP Pro, DELL 380) that was also running McAfee VirusScan version 8. This occurred even after excluding all SQL Server folders and file types from VirusScan. ...

maint plans xp_sqlmaint db bkups and using the backup commands

Victoria Morrison - 9 Feb 2006 8:25 PM - 2 messages

Is there a difference between performing a database back up using the maint plan(xp_sqlmaint) or using the BACKUP command? Does the xp_sqlmaint perform a FULL backup including the trans logs? And is it performing a BACKUP LOG? (I would assume no it's not doing a backup log). ...

SQL2000 meltdown on its way?

gstar - 9 Feb 2006 7:56 PM - 2 messages

Hi, We have SQL 2000 running with several databases live to the public. In the next few days our web developers are rolling out substantial updates to the system and history tells me this could go badly wrong! Presently I have a maintenece plan which does a complete db backup each ...

BCP newbie question

Chris - 9 Feb 2006 7:37 PM - 2 messages

I am trying to run the bcp utility. When I run it from the command prompt it works. When I try it from a bat it goes into this crazy endless loop repeating the command again and again. Any ideas what I am doing wrong? ...

SqlServer 2005: need help creating a new user

Steve - 9 Feb 2006 7:10 PM - 3 messages

I'm working with Sql Server 2005 express and the Management Studio Express. I changed my server to use mixed mode, it had originally been installed with just Windows Authentication, but I realize now to connect outside of our domain I need to have mixed mode. ...

"SQL: The Complete Reference" source?

SteveH - 9 Feb 2006 5:50 PM - 3 messages

I purchased a used copy of the SQL book listed in the subject but the CD is missing. I have access to SQL Server 2000 and so don't need the trial software but would like to get the source for the database used ...

Reversing a soundex result

almurph - 9 Feb 2006 5:45 PM - 2 messages

Hi everyone, Hope you can help me with this one. Given a soundex value like: "M500" how can you tell what the original value was as a charcter string? In other words, how can you go back? (inside query analyzer??) ...

Updates with max sequence

Matt - 9 Feb 2006 5:41 PM - 4 messages

Here is my table structure: ID Sequence FName LastName Team -- ---------- -------- ----------- ------ ...

Unable to read local eventlog (reason: The parameter is incorrect)

Brooster - 9 Feb 2006 4:57 PM - 6 messages

Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date: 2/9/2006 Time: 9:34:06 AM ...

60 GB tempdb not shrink after sql restarted

Steve777 - 9 Feb 2006 4:47 PM - 2 messages

SQL 2000 Enterprise Edition running in active/passive cluster. Restarting SQL server couldn't shrink the huge tempdb. Tried DBCC SHRINKFILE with no luck. Anyone knows if Method 1 in KB 307487 applies to cluster environment? I am sure the steps listed in Method 1 works for a stand alone built. What shoudl ...

Problem sheduling Maintenance Plan (Backup)

MGW24 - 9 Feb 2006 4:45 PM - 7 messages

I'm trying to create a SQL Maintenance Plan to backup the databases and schedule it to run at 10:00pm every night. I can create the backup job just fine, but when I try to shedule it, I get an error saying: ...

DIFFERENCE function

Bil Click - 9 Feb 2006 4:41 PM - 5 messages

I am trying to increase the performance of a SOUNDEX search on lastname column in a table with about 28 million rows. I thought about adding a column preloaded with the SOUNDEX value for lastname, such as 'lastname_soundex'. But I cannot see how to force the DIFFERENCE function to use that soundex ...

How can i create a serer role

blurk - 9 Feb 2006 4:26 PM - 8 messages

hello, I want to create a new server role. How can i do it ? kind regards blurk ...

Showing column values

mainspring - 9 Feb 2006 4:11 PM - 2 messages

I am using SQL Server 2000 with Windows XP PRO. When I run Enterprise Manager and select a table then request to have all rows returned I get my view and I have all the info for all the columns except any columns that seem to be of ...

SQL Server 2005 Hanging

Amos Soma - 9 Feb 2006 3:13 PM - 4 messages

We run a .NET (C#) application every night around 3:00 AM that creates a new empty database and then executes roughly 3000-4000 SQL statements to create the schema for this database (tables, stored procs, views etc.). Sometimes this process works without error. Other times SQL Server 2005 hangs midway ...

LSASS.EXE high CPU usage

The Vogon - 9 Feb 2006 2:36 PM - 3 messages

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious problem. Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The ...

restoring 2000 backup to 2005

luna - 9 Feb 2006 11:53 AM - 8 messages

trying to import 2000 bak file into 2005, and im getting this error, any ideas ? - seems a pain getting my old data into the 200 server! Restore failed for Server '********'. (Microsoft.SqlServer.Smo) ------------------------------ For help, click: [link] ...

Replication

beachboy - 9 Feb 2006 10:40 AM - 9 messages

Hello all, I am setup a replication from DB_A(publisher) to DB_C(subscriber), but I got a problem after replication created Example: Table1 in DB_A, i tried to add a new data field. but DB_C can't see new data ...

In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local

Daniel - 9 Feb 2006 9:40 AM - 2 messages

In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables. ...

Yukon xp_cmdshell setting

Vaibhav - 9 Feb 2006 6:11 AM - 8 messages

Hello, How does Yukon keep the information about the security context of xp_cmdshell (user or agent) ? How can we retrieve it ? I could not find a registery setting for that. Please help. Thanks a lot in Advance Regards, Vaibhav ...

Multiple Job Steps SQL 2000

Gramps - 9 Feb 2006 5:09 AM - 2 messages

Hi, I have 3 DTS packages I want to run after each other, in no particular order. I have x3 jobs, each running one of the DTS using CmdExec. I don't want to run these jobs on individual schedules. I also don't want a ...

Alter Table - Add Colum - Ordinal Position??

SwingVoter - 9 Feb 2006 3:43 AM - 17 messages

I am using SQL Server 2000. As part of a new development project I find that I frequently need to add new columns/fields to existing tables using SQL Scripts in Query Analyzer. I would like to add the new column at a specific ...

How to see the complete error message SQL job fails.

Tejas Parikh - 9 Feb 2006 3:21 AM - 3 messages

Hey guys. I've a question regarding jobs. I've a job which defrags about 100 indexes. It fails somewhere in between and I can't figure out why because the error messgae in the 'view job history' gets truncated and is not completed. ...

different kind of Indexes for different tables

maxzsim via SQLMonster.com - 9 Feb 2006 3:09 AM - 3 messages

Hi , I read in Oracle that each table's can have it's own kind of indexes e.g IOT , BitMap , B-Tree for different purposes used by Application. Is there such function(s)/options in SQL Server ? appreciate ur advise ...

Hardware Question

Kim Barnes - 9 Feb 2006 12:50 AM - 3 messages

This is a business rather than a technical question. We have a legacy application that uses a jBase database ([link]) and now want to install a SQL Server application on the same hardware. Both applications need to serve web pages. The box is a dual pentium with 2GB of ...

Problem with Enterprise Manager

walter1234 - 9 Feb 2006 12:45 AM - 3 messages

When in em, I try to open a table and return all rows, I get a weird error: "The query cannot be executed because some o fthe files are missing or not registered." Also, I cannot connect to the database with a dataadapter in vs (2003) ...

Restore sql 2000 database .bak file to sql 2005

CW - 8 Feb 2006 11:46 PM - 3 messages

I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get is " Restore failed for Server" - The backup set holds a backup of a database other than the existing 'db name here ' database. ...

What goes in Source Safe?

Jerry Spivey - 8 Feb 2006 10:02 PM - 2 messages

Hi, I'm going to be using VSS2005 for my SQL/.NET developers. All CREATE statements will be stored in VSS2005. When changes are made to the objects, revision history information (comment) will be updated within the DDL ...

Trusted SQL-server connection..?

Kent Johnson - 8 Feb 2006 9:35 PM - 8 messages

Hi all, I have an MS-Access application that connects to a database via a DNS-Less script. I have installed SQL-server on my local PC running Win2003Server which has the same setup as my production server. This works fine and I suppose this is because the server is "trusted". ...

Database Maintenance Plan Issue with non-default instances

JohnnyMagz - 8 Feb 2006 9:17 PM - 2 messages

I have a SQL Server (2000 sp3) with one default instance and many named instances. I have configured, tested, and monitored a database maintenance plan for the default instance - works fine. I can't seem to get any of the ...

Last Time Object Used

ALaRiva - 8 Feb 2006 9:05 PM - 4 messages

I have not been able to find anything remotely close to doing what I need. I've been told that nothing like this exists in SQL Server, but I'm sure there has to be something, somewhere, somehow to do this. ...

best practice for copying between 2000 and 2005

luna - 8 Feb 2006 7:59 PM - 3 messages

currently built a new server with sql server 2005, whats the best practise for copying the databases from a sql 2000 machine ? backup / restore ? - i tried the copy wizard and it kept falling over ...

Urgent.. Restore data from .mdf file

Chris - 8 Feb 2006 7:51 PM - 2 messages

Its urgent !! Any help will be appreciated.. I have the .mdf file and would like to restore backup from that to my current database. Read the article: [link],289483,sid14_gci824569,00.html It says: ...

SQLH2

David J. Cartwright - 8 Feb 2006 7:25 PM - 2 messages

Anyone know how to clean (groom) the SQLH2Repository database ? ...

Disk fragmentation after backup

KTN - 8 Feb 2006 6:39 PM - 3 messages

I got heavily disk fragmented after a full database backup. The disks configured in RAID 10 and used to store just 1 full backup file daily. I used the option "with init" on the backup statement. If you have experience ...

Advanced find and replace

Steve1445 - 8 Feb 2006 6:20 PM - 2 messages

I have two tables. One table contains ID numbers for individuals (Ind_ID), and ID numbers for their family unit (Fam_ID), there isn't any words in this table just numbers. The information in the Fam_ID field would be like this: ID001, ID002, ID003, ...

decrease the size of Sql backup files

mecn - 8 Feb 2006 5:35 PM - 3 messages

Hi, I am looking for sql tool that it could shrink the sql data backup and log files size. I know one software called litespeed. There is any more good software that could do the same function as litespeed does? ...

Failed uninstall of named instance

steve - 8 Feb 2006 5:25 PM - 3 messages

Hi I attempted to remove a named instance on a test server (SQL 2000 sp4). The uninstall failed and after trying to follow Microsofts recommendations (Article id 290991 - How to manuall remove sql server 2000 ... instance) I have got myself with a partially deleted instance ...

Which SQL license package to Choose

Andy - 8 Feb 2006 4:47 PM - 2 messages

We are a small - medium size company who are looking to purchase SQL for running AutoDesk Vault/Inventor. We are getting conflicting information on the best license to choose. We have a Dual Xeon server and require access for 12 engineers and aprox 25 other users to have access to SQL software. ...

SqlServer management studio woes...

sklett - 8 Feb 2006 4:44 PM - 3 messages

It's pretty and all, but it's acting strange and confusing me. Here is what I'm doing to edit my sproc: 1) Right click on sproc in the tree to the left and choose 'modify' - this opens the sproc for editing ...

Can't connect to SS2005

sck10 - 8 Feb 2006 4:05 PM - 4 messages

Hello, I had SS2K running on my local machine (everything worked). Then I installed SS2005 and was able to connect the server running locally. Once I uninstalled SQL Server 2000, I was unable to connect. Even if I try to ...

SQL Install Question - Best Practice

AndyG - 8 Feb 2006 3:58 PM - 2 messages

What is the best practice for installing SQL onto a SCSI Array? I have the OS on a RAID 0-1 Array and I have a RAID 5 Array for Data. Is it Best to Install SQL on the RAID 0-1 with the OS and put the DBASE on ...

Questions about SP_recompile...

Tinchos - 8 Feb 2006 3:51 PM - 2 messages

Hi friends... i am writing you for another doubt... I have a developer which requires the execution of sp_recompile for all the SP in his database every day or four times per week. He saids that running this recompilation all the performance problems was solved. I am sure this is ...

How do I drop a Foreigh Key

DevalilaJohn - 8 Feb 2006 3:41 PM - 2 messages

I have a column that includes th constraint References Table(Column) in its definition. How do I get rid of this constraint? Thanks for you assistance. John ...

SQL 2000 and SQL 2005

ItzMeMarcio - 8 Feb 2006 1:36 PM - 3 messages

Can SQL 2000 and SQL 2005 be installed in the same computer? I am a developer, which I currently develop on SQL 2000. However, I would like to start learning SQL 2005. ...

Implicit conversion

Nuno Mendes - 8 Feb 2006 11:59 AM - 5 messages

Hello I'm need to create a store procedure to insert record into a table from a select to another table. When i try com save the procedure always appears the error "Disallowed implicit conversion from data type datetime to data type ...

stored procedure ?

sklett - 8 Feb 2006 7:55 AM - 3 messages

pretty new to stored procedures. I want to run two select statements, the first will get the userID, username and password from table_A The second will get the roles for the above user from the 'users_roles' table, but i need the UserID value to execute the second SELECT. I thought ...

negative spid number

Hassan - 8 Feb 2006 4:49 AM - 3 messages

I could have sworn I saw a spid with a negative number . Am I hallucinating or has anyone seen that before ? ...

MCP Tests Off MCDBA CD Have Script Errors!

dthulin - 8 Feb 2006 4:47 AM - 3 messages

I decided to become MCDBA certified and bought a book (70-228) that will help me study for the first test. I pop in one of the CD's it came with and install the test questions. When I launch the program I ...

repair_allow_data_loss Repair statement not processed. Database needs to be in single user mode.

savvas - 8 Feb 2006 1:52 AM - 2 messages

I have to repair a database with repair_allow_data_loss level, so I start SQL Server on single-user mode with the following command sqlservr.exe -c -m and run the repair command: dbcc checkdb ('blade', repair_allow_data_loss) I get the following error that doesn't make sense, since I am already in ...

"PRIMARY" filegroup is full

Dean J Garrett - 8 Feb 2006 1:04 AM - 15 messages

Hello, We have an SQL Server app written in ASP that suddenly has an error after 2 years of operation, and we're having trouble locating the problem. Here is the error message below. The reference in the Knowledgebase for this error ...

Shrinking Database

Dan - 8 Feb 2006 12:49 AM - 3 messages

I have a database that was 7GB. I wanted to shrink the database. In the Shrink Database screen it showed the free space at 69%. I specified Maximum free space after shrinking to be 25%. After shrinking it says there is 51% ...

Cannot attach files from different databases?

KMP - 7 Feb 2006 10:49 PM - 8 messages

Is there any way that SQL Server can be forced to recognise files from 2 different databases? I am thinking that there is some setting in the Master database that can be changed, like an ID, or a GUID (which matches the file ...

Query Analyzer

Rich - 7 Feb 2006 9:23 PM - 7 messages

Hello Group, is there any way to load only the Query Analyzer on a developer's PC. I have a developer that likes the look and feel of QA but I do not want to load the Enterprise Manager onto the users PC. ...

deleting duplicate record

Johnfli - 7 Feb 2006 9:14 PM - 2 messages

in my table, I have several rows that are complete duplicates. Needless to say, I can't open the table and just delete 1 row. How do I delete the copies and not all? ...

Configuring memory for SQL 2000

Leon Shargorodsky - 7 Feb 2006 9:07 PM - 2 messages

I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server 2003 Standard Edition machine with 8Gb of memory. How do I force SQL server to use at least 6Gb out of 8Gb? Thank you in advance! Leon ...

Want to create a database snapshot of one filegroup only

Nayan Raval - 7 Feb 2006 9:00 PM - 3 messages

Using SQL 2005, my principal database contains many filegroups but I'm only interested in creating a database snapshot of one of these filegroups. Specifying only one of the file names in the CREATE DATABASE databasex_snapshot ... AS SNAPSHOT OF databasex ...

reclaim "unused space" from a table?

cmay - 7 Feb 2006 8:19 PM - 6 messages

We have a table that is showing a large amount of "reserved" space: Rows: 4095513 Reserved 11255328 KB Data: 1176296 KB Index_size: 531240 KB unused: 9547792 KB ...

DROP and CREATE INDEXES

Scott - 7 Feb 2006 8:06 PM - 4 messages

I'm trying to reduce fragmentation of indexes on tables. When I run DBCC SHOWCONTIG on the table both befor and after dropping and recreating the indexes, including PK constraints, the results are the same? Any insight? I ...

DBA - Service Request Form

Jerry Spivey - 7 Feb 2006 8:01 PM - 3 messages

Hi, I'm looking to implement a paper-based service request form for all DBA related activities i.e., adding logins, users, tables etc... granting permissions, dropping objects, etc... Does anyone have a link to an online form that I can start with or have an in-house form (.doc) that I can use to ...

DTS will not send attachment using sp_send_cdosysmail

ChrisP - 7 Feb 2006 7:47 PM - 3 messages

I have created a DTS that exports the results of a query to an excel sheet and the delivers the xls to a group of users. The DTS will send the the email but not the attachment; however, if I ...

what datatyp for filesize?

Outlook 2003 does not work with SQL Mail !!

Doubts about SQL-DMO

SQL2005 64bit shrink file - Log file is 12GB

QUOTED_IDENTIFIER and ARITHABORT for Maintenance plans

Seeing SQLDMO in Profiler

send copy of backup file to other server

log in MSSQL\Data\MSSQL\Data

tempdb data and log file location

need to write query...

Moving data from SQL Server to Access

Detach/Attach to SQL Server 2005

Memory Usage per DB-Instance

Removing case sensitivity

Person.Coontact - AdventureWorks

Backup Device

Installing SQL Server 2005

Connection error

corruption of database maintenance wizard

sql server 2005 partition query

Index Fill Ratio

Viewing Stored Procedure

alter user defined data type length

How to create Logs?

Change the server date and time

My MDF Files currupted

"ImpersonateClient" property in Yukon

SQL 2005 Architecture Question - Active Secondary Database?

How to simplify XML Query? (SQL2000)

SQL Server Failover/Reporting Server

Stored procedures do not logout

What is SQL2005 final build number?

Execution plan says statistics are missing but they do exist

find duplicates

copying data from sql server 2000 in one domain to sql server 2005 in another

Database Naming Convention - Sanity Check

SQL 2005

Importing data from Excel file w/ multiple Excel sheets

Allow users to run jobs

Regarding the SQL Server 2005 Express Edition

SQL Server Backup w/ both Tape(Complete) & Disk(Differential) Scenario

ole db, odbc, mdac what does enterprise manager register server use?

Question about backups.

sql server performance issues

SQL Express case-sensitive

Viewing Particular Databases

Installing SQL Server 2000

Replication Security

Cast DateTime To Date?

Capacity Planning

Moving master database in cluster

Possible SQL 2000 Performance Issue

SELECT right after INSERT returns empty

Recover Data

Restore backup file

linked server to Oracle

Network Monitor

SQL Server 2000 - Conection could be not be established

Attaching database

restore master database: no restart

Converting Paradox database to SQL Server

Dual Core CPUs and SQL Server 2000

dbcc inputbuffer does not list parameters

General network error

Error Message 17883 (Scheduler 5 appears to be hung)

SQL 2005 - Backup restore Q

Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri

Can't access an instance installed on same server

Insert a picture in an MS SQL Server table

  is displayed when returned from database call

Performance of SQL2k5 with snapshot isolation level turned on

Is this an ok design?

Rename MDF file

linked server, oledb for odbc, slow performance on join to cache