Home All Groups Group Topic Search About

Score rebuilding index not doing anything
Chris - 29 Nov 2007 6:13 PM - 4 messages
There are 25 indexes in my database which continue to report they are severely fragmented even after I rebuild them. The operation completes without error, so I don't understand why it is still fragmented. It does not matter if I use REBUILD or REORGANIZE, the result is the same. Anyone know ...
Score How to add sp to SQL 2005 cluster?
Clayton Sutton - 28 Nov 2007 3:59 PM - 5 messages
Hey everyone, We are running Windows 2003 and SQL 2005 in a cluster.  We now need to install a service pack for SQL 2005. Anyone know of a step-by-step white paper on how to do it in a cluster? ...
Score Copy Database Wizard on Vista x64 machine
CJM - 29 Nov 2007 5:02 PM - 2 messages
I've got a new Vista x64 build with SQL2005 (+SP2) freshly installed. I'm now trying to copy existing databased from other services but I can't get it to work. I get the following error logged in the Event Viewer Application ...
Score Lock escalation not working
James - 29 Nov 2007 2:52 PM - 8 messages
I occassionally see one of the spid holding around 10-20 million locks in the server. The spid is supposed to update around 1 to 2 records out of 90 million rows table and its well indexed. The spid is generated by ...
Score Easiest way to move database from 1 machine to another ?
fniles - 30 Nov 2007 7:56 PM - 3 messages
I am not a DBA, so pardon me if my question is basic. What is the easiest way to move SQL Server 2005 database from 1 machine to another ? If I backup the database, I can not restore it in another database or in ...
Score DB Mirroring in a mixed 64bit/32bit Environment
NickN - 29 Nov 2007 7:17 PM - 3 messages
I have several satellite 32bit installations of SQL2005. I am in the process of upgrading my main SQL server from SQL2000 to SQL2005. I what to make good use of 32GB of RAM in this box, so I am considering the 64bit version. ...
Score SQL 2005: Shrinking DB files
Conan Kelly - 29 Nov 2007 6:26 PM - 5 messages
Hello all, SSMS>Object Explorer>right-click a DB>Tasks>Shrink>Files     File Type:.....Data     Click "Reorganize pages before...." optioni     Shrink file to:........1 MB As soon as I tab out of the "Shrink file to:" text box, it automattically ...
Score Migrating Data from SQL Express to SQL Server 2005
Saqib Ali - 28 Nov 2007 6:41 PM - 4 messages
Is it possible migrate a database from SQL Express to existing SQL Server 2005? It is a encrypted DB. We are reaching the 4GB limit on Express, and would like to move the Data to a existing SQL Server 2005. ...
Score transaction log backups are failing
Sas - 29 Nov 2007 4:35 PM - 4 messages
All, I have a SQL Server 2005 STD with SP2 and when i configure the TRA NSACTION backups through the GUI, I've selected the option to have the transaction log backed up for "ALL DATABASES" (radio button). Even though there is a note ...
Score String manipulation syntax
db - 28 Nov 2007 2:46 PM - 8 messages
Hi Can someone redirect me to a site/document where i can find good string manipulation information with syntax and example for doing the follwing: 1. In a column, I have values like (123456789.0000). I want to remove "."  ...
Score Disconnected app with sql server compact
John - 29 Nov 2007 3:29 PM - 3 messages
Hi I am developing an app in vb.net 2008 with sql server 2000 backend. I also need disconnected version of the app for laptop users who would connect off and on with LAN and thereby with the company sql server 2000. I am wondering ...
Score Backup error
Ed White - 26 Nov 2007 11:15 PM - 12 messages
When I run the following SQL, either from VB 2005 or directly in SSMS, I get the subsequent error: BACKUP DATABASE [Companies DB] TO DISK='C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\Companies DB.bak' Msg 3271, Level 16, State 1, Line 1 ...
Score Can I use SQL 2005 script to create SQL 2000 database?
John Steen - 29 Nov 2007 4:37 PM - 3 messages
Can I use a script generated in SQL 2005 to create a database on a SQL 2000 server? We're migrating from SQL 2000 to SQL 2005, and at the same time doing a major upgrade to an existing SQL 2000 database.  Another group created the ...
Score SQL Error
Adam Sankey - 29 Nov 2007 3:07 PM - 3 messages
I'm trying to write a script for adding database but keep getting the error below: Server: Msg 170, Level 15, State 1, Line 4 Line 4: Incorrect syntax near '@loglogicalName'. This doesn't make any sense to me as I can't see the problem (maybe I can't ...
Score long time process - what's the progress?
Piotr Lipski - 29 Nov 2007 2:33 PM - 4 messages
Hi. SQL 2005 Std. Linked server to iSeries. I have run INSERT INTO <sql table> SELECT * FROM [I].[SERIES].[TA].[BLE] There are about 23mln records to copy. I's been running for the last half an hour and I would like to check what the progress is. Is there ...
Score SQL Server 200 Login failed for user SQLSTATE 28000 SQL Server Err
Baris Ratanjee - 28 Nov 2007 7:29 PM - 6 messages
I have SQL2000 installed on Windows 2003 DC box. I have setup a Database and am trying to establish an ODBC definition for one of the users in the company and am getting Connection Failed SQL State 28000 SQL Server Error: 18456 ...
Score Moving SQL Server 2000 to SQL Server 2005 - Need suggestions on syncronization of data between the
Learner - 28 Nov 2007 5:34 PM - 8 messages
Hi,   Our current production database server is SQL Server 2000 and it is running on Windows 2000 server. Now as part of the upgrade we bouht a new machine and installed Windows 2003 Server and SQL Server 2005 on it. ...
Score SQL 2005 Express to SQL Server 2000
musosdev - 26 Nov 2007 10:13 AM - 8 messages
Hi everyone, I have an SQL Server 2005 Express database as part of a Visual Studio project. I also have an SQL Server 2005 server. I'm trying to backup and restore my database to my web server (hosted with ...
Score Error 12291 in Event Log
Tom Juergens - 29 Nov 2007 7:29 AM - 5 messages
We have a maintainance plan for full/diff/log backups of selected databases running at regular intervals through SQLAgent. The backups are working; I can restore the databases. But starting a few weeks ago we've been getting error messages in the system event log. ...
Score designing inheriting entities
Emre DÝNÇER - 29 Nov 2007 9:50 AM - 2 messages
Dear All, our customer has 3 kinds of entites the first one is the ApplicationCenter where students can register to exams... and there are types of app centers like University offices, high schools etc.. these types goes to another table.. ...
Score Severity 20 error messages in Error log
vijay - 29 Nov 2007 11:43 AM - 3 messages
Hi    We have been recieving the below given message before enabling AWE on the sql server 2007-11-07 15:39:29.44 Logon Error: 17806, Severity: 20, State: 2. 2007-11-07 15:39:29.44 Logon SSPI handshake failed with error code ...
Score Cannot connect to SQL Server from localhost (no problem from any xp client)
Markus - 28 Nov 2007 7:29 PM - 5 messages
Hi ng! The facts: SQL Server 2005 is installed on a Windows 2003 server within a domain. Every XP-Clients can connect to SQL Server via ODBC without any problems. The problem From the localhost I cannot connect to SQL-Server, AND from any (2) other ...
Score Computed Column Formulas
John Kraus - 27 Nov 2007 11:20 AM - 9 messages
I am working on migrating an existing Access DB to SQL Server Express. The DB is for rental tracking. I am creating it as an ADP project and have created all the tables, forms etc. from scratch. I am using Access 2007 as a front end for the DB. ...
Score SQL Server 2000 download?
Anil Gupte - 28 Nov 2007 9:20 AM - 7 messages
Where can I get an evaluation copy of SQL Server 2000?  I have followed all the links and they all point me to SQL Server 2005.  We are having lots of problems (connection issues) with SQL Server 2005 Express and from what I ...
Score Equal disk space needed to delete .bak file?
rockemhard - 28 Nov 2007 2:58 PM - 6 messages
Kind of an obscure question, but here goes. SQL2000 SP4 I have a E: drive on my SQL server that is ~400gb.  On it you'll find a ~100gb live DB file and last night's 100gb .bak file (maintenance ...
Score High Pagelatch and threadpool
Hassan - 26 Nov 2007 4:01 PM - 18 messages
I see high pagelatch and threadpool wait types in SQL 2005. What does that mean ? How can I resolve it ? Also when i see a waitresource of 7:1:145620? I understand the first is the dbid , whats the 3rd value ? ...
Score Upgrade to SQL Server 2005
Lukasz Glaz - 29 Nov 2007 7:27 AM - 3 messages
I need to upgrade SQL Server 2000 to SQL Server 2005 on 10 development workstations. How it should be done to aviod problems: 1. Upgrade SQL Server 2000 instance to SQL Server 2005. 2. Uninstall SQL Server 2000 and then install SQL Server 2005. ...
Score Creating a VIEW based on other VIEW.
stevong - 29 Nov 2007 4:01 AM - 2 messages
Hi everyone, Let's say I have a VIEW that is created by some complex joins - This VIEW is used by many of the application's function. Let's call this "VIEW_1". "VIEW_1" select queries are already created using "with (nolock)". ...
Score Delete & create a partition
r.no - 28 Nov 2007 12:03 PM - 4 messages
Hello All, I am working on a hugeee table partionned in 20. Working on one partition at one time, I need to drop and re-create a partition before inserting treated data. Anyone know if I can drop then re-create a partion ? if yes, How. if no, any ...
Score SQL Server 2005 Maintenance Plan Error
NigelA - 28 Nov 2007 5:16 PM - 12 messages
I have tried to run a maintenance plan which is just a Check Database Integrity task set to: Target server connection, All user databases, Include Indexes. It claims to run OK but then viewing the history shows it has failed with the error "Alter failed for Server 'XYZDB02'" ...
Score Performance monitoring specific database
olig - 27 Nov 2007 1:59 AM - 7 messages
I have a server with over a hundred databases, let's say I want to identify which databases are the most active and which ones use the more resources (CPU, IO and memory). What counters or at what data should I look at? ...
Score Trigger instead of declarative referential integrity
Ferdinand Zaubzer - 26 Nov 2007 2:59 PM - 2 messages
Hello, In a Database I have a A table "Orders" with 2 columns ("country_invoiceaddress", and "country_shippingaddress") that are foreign keys pointing to the primary Key of table Countries. Now it should be possible, that if the key of a country is changed the ...
Score sp_adduser problem
Adam Sankey - 28 Nov 2007 5:57 PM - 2 messages
Hello, I have a problem with adding users to a database using sp_adduser.  The user I'm using is a member of db_owner but I receive the following error: sp_adduser adam, adam, DEFAULT_USERS Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35 ...
Score Impact of transaction log backups in synchronous DB Mirroring syst
HeatherK - 28 Nov 2007 3:05 PM - 4 messages
Hello, We have a site on SQL Server 2005 SP2 EE.  They are using synchronous database mirroring.  Both the principal and mirror are on a fast LAN. When they perform transaction log backups on the principal database, our ...
Score Sql better than Oracle?
Paulo - 28 Nov 2007 12:37 PM - 8 messages
Any articles? Comparisons? ...
Score Installing Sp2 on clustered Instances
Stefano Colombo - 28 Nov 2007 10:39 AM - 3 messages
Hi , quite a basic question here, but I like to have a confirmation . I need to install SP2 on a Clustered Sql2005 . The cluster has 3 instances . Question is , can I install SP2 over just one of them without affecting the ...
Score www.prs-123.com will give you the best service
prs-123 - 28 Nov 2007 1:39 PM - 1 message
Hello, madam / sir   Christmas day is coming! if you want to find a gifts for your family or your friends, Our Web address:[link]'m sure you will find the item you like ...
Score full and diff backup - sql2005
oto.pakozdy - 27 Nov 2007 3:06 PM - 6 messages
hello... I've got problem with backups on sql2005 script make backup at saturday with full backup  and at monday script runs diff backup. On one of few sqlservers2005 diff backups doesn't run because because error: "a current database backup does not ...
Score Local Admin
AHartman - 28 Nov 2007 1:35 AM - 4 messages
If you start your SQL services with local admin and you have a process that uses xp_cmdshell to get files based upon date on a remote server. Can you do that? What permission will I need to apply on the remote server folders or from ...
Score Export Wizard Error
Roger Denison - 27 Nov 2007 1:14 AM - 6 messages
I am trying to use the Export Wizard to copy data from a SQL2k server database to a SQL2005 database.  My source and destination is SQL Native Client and I am only interested in one table.  Everything appears to be ready ...
Score hotfix/service pack directory
horseradish - 27 Nov 2007 9:34 PM - 5 messages
I remember seeing a post in this newsgroup for a website maintaining a (fairly) comprehensive list of hotfixes, service packs and cumulative update packs for SQL Server. Anyone care to re-post? ...
Score Do I need to Reindex after truncate table?
dengcharles - 28 Nov 2007 6:08 AM - 3 messages
Hi All, A quick question: Do I have to Reindex a table (using "DBCC DBREINDEX" statement) AFTER I truncate a table? In SQL 2005 BOL it seems after truncate table although the index(es) is still there but the data page ...
Score question on proxy with sql 2005
Paul - 27 Nov 2007 8:34 PM - 4 messages
I am a recent user of sql2005 but have worked with sql2000 for a few years.  I noticed under the sql server agent there is a listing for proxy.  I have used the sql server agent to set up jobs to run packages developed with ...
Score non-admin user and SSIS (integration services)
horseradish - 27 Nov 2007 5:42 PM - 4 messages
I wish to grant access to SSIS (e.g., register server in mssms) for a user _without_ making that user an administrator of the host. How can this be done--if at all? ...
Score What is (+) ?
Paulo - 27 Nov 2007 8:20 PM - 2 messages
Hi, can you explain me what is the "(+)" on some lines below? How can it be converted to SQL SERVER 2000/2005? Thanks! SELECT H.COD_UNIDADE_NEGOCIO, ST_APROVADO_SUPERVISOR, DATA_HORAS, QDE_HORAS, DESCR_PROJETO, DESCR_ATIVIDADE, NOME_FUNCIONARIO, N.DESCR_UNIDADE_NEGOCIO, TC.NUMERO_CAPEX, TC.DESCR_CAPEX FROM TS_HORAS H, TS_PROJETO P , ...
Score Test connections with NT User groups
SM - 27 Nov 2007 5:56 PM - 3 messages
Hi I've created multiple NT User groups with different SQL Server permissions, each group contain some NT users. I want to test if my permission policy is correct, is there a way to do this without asking one people from each group to test ? ...
Score Updates
BigSam - 26 Nov 2007 8:48 PM - 4 messages
I'm experiencing some known issues (memory leaks) that have hot fixes. Is there a service pack release or update scheduled for the near future? ...
Score Update Timeout and indexes
Jim - 21 Nov 2007 7:38 PM - 12 messages
Hi, I have two questions about Updating a large table.  It has about 40 million rows.  When I try to do an update on one of the fields, it goes on forever until I kill it.  The last time this happened, after I ...
Score Migration SQL server 2000 to 2005, with heavy use of DTS
baruffa66 - 27 Nov 2007 6:32 PM - 3 messages
We have a big migration from SQL server 2000 to 2005 It is a big procedure aith millions of records and it uses DTSs heavily, so I am asking some hints on s your experience on 1. "basic" migration of DB ib itself ...
Score database and tlog backups - MSSQL 2000 & MSSQL 2005
morebeer - 23 Nov 2007 3:25 PM - 9 messages
hi all, as we have big problems with sql timeouts and deadlocks during the backup of the databases and transaction log, i am searching for a possibiliy to give the backup procedure a lower priority, so that the sql requests falling into that period don't fail anymore. is there a ...
Score transaction log growing very quickly
Chris - 27 Nov 2007 4:56 AM - 5 messages
About 4 days ago (ish) our db's transaction log was about 3 GB and growing fairly slowly. Right now it's 23 GB and growing extremely quickly. There hasn't been an increase in the amount of DB traffic on our server and I'm ...
Score Overwriting Backup Set
Shelley - 23 Nov 2007 3:57 PM - 9 messages
Hi, I did a full backup of my database, but everyday when it is backing up I would like it to overwrite the previous day's backup. I'm doing it thru Transact-SQL script(T-SQL) so i am entering the following ...
Score Missing index query help
Hassan - 27 Nov 2007 6:57 AM - 4 messages
When I was going through Kalens Query Tuning and Optimization book , she provided the query below to find missing indices. Results are below. select object_name(t1.object_id) TblName,t2.user_seeks,t1.equality_columns,t1.inequality_columns,t1.included_columns from sys.dm_db_missing_index_details t1,sys.dm_db_missing_index_group_stats t2, ...
Score Capture Error In DTS Package
Creative - 26 Nov 2007 9:54 PM - 4 messages
I have a SQL Server Package that is dumping a text file into an Access Database.  However, due to update timing every now and then it errors out due to a primary key violation.  How do I capture that error ...
Score identity insert issue
sharman - 26 Nov 2007 10:37 PM - 3 messages
I am trying to update an identity column with a new value. I am doing the following: set identity_insert tbgfmla4.dbo.[tblname] on go update [tblname] set identitycolumn= 124926 where [fieldname] = 'ABCD' and it gives me an error Server: Msg 8102, Level 16, State 1, Line 1 ...
Score SQL Server 2000 production problem: can't drop/index table
WombatDeath - 26 Nov 2007 9:55 PM - 5 messages
Hi, I have a problem with a SQL Server 2000 Standard database.  One specific table in the database demonstrates the following behaviour: 1) it cannot be dropped (the operation 'hangs' - nothing happens) 2) I cannot add an index (again, the operation fails to complete ...
Score removing SQL Server 2005 (multiple Visual Studio versions)
gandecoe - 26 Nov 2007 10:43 PM - 2 messages
I know that my entry which follows is rather long and complicated, but I am hoping someone can offer helpful recommendations to my two questions at the bottom.  I have tried to research this and figure it out on my own, but I am ...
Score Restoring a column in a table
tnt - 26 Nov 2007 5:18 AM - 8 messages
Guys, One of our collegues deleted a colum in the table of the database.  Is there anyway I can just restore that column only without restoring the whole database. I remember doing something like this in the past but it has been a long time ...
Score Problems with my Scheduled Backup Jobs on Windows Server 2003 SP2
Mohd Al Junaibi - 27 Nov 2007 6:07 AM - 3 messages
Hello all, I'll get to the problem, which I have a tough time finding out the root cause. 1) I have SQL Server 2000 Installed, with the following patch/SP version:     Version: 8.00.760 2) My database is running on a server with Windows Server 2003 SP2. ...
Score Index size.
Shiju Samuel - 26 Nov 2007 7:18 AM - 3 messages
Where can I get the size of the index to add to the below query. select     t.name [Table],     i.Name [Index],     c.name [Column],     ic.key_ordinal [Key Ordinal], ...
Score BOL - Katmai
Alan T - 21 Nov 2007 12:08 AM - 10 messages
What is the differences between the downloaded Katmai BOL and the installed SQL Server BOL? ...
Score Altering column in a large table
manu - 26 Nov 2007 8:28 PM - 5 messages
Hi, I need to alter one column which is a part of a table with billions of rows in it. What would be the finest and fastest approach to do it? Thanks in advance Manu ...
Score -- error al crear plan de mantenimiento --
Edmundo J. Davila - 26 Nov 2007 4:21 PM - 8 messages
Hola, Estoy creando un plan de mantenimiento para una base de datos SQL Server 2005. Tengo una instalacion en 64 bits. El plan de mantenimiento incluye lo basico, reconstruir indices, chequear integridad, actualizar estadisticas, etc. Lo estoy tratando de hacer con el wizard, pero al llegar al final y dar ...
Score Memory Configuration Question - SQL 2000 sp4
BH337 - 7 Nov 2007 8:01 PM - 8 messages
Hello all.  I am currently running the following setup. -Windows Server 2003 Enterprise Edition (32-bit) -4 x 2.5 ghz Xeon Processors -12 gigs of Ram (with /PAE switch enabled) -Static 4092mb page file -SQL Server 2000 sp4 Enterprise (8.00.2040) ...
Score SQL Server Access
Brett_A - 14 Nov 2007 6:01 PM - 8 messages
Is it possible to access an SQL server db from a web site when the actual db sits on another server at another host? Thanks Brett ...
Score connection failed
Marius Kaizerman - 26 Nov 2007 2:17 PM - 3 messages
Hi, I have a program using ms sql. It worked fine for some time, but now each time the program access the databases it outputs "Connection Failed SQLState 28000, SQL Server Error 18456, Login failed for user 'sa'". After pressing OK it gives an option to input a new password manually, and after ...
Score SQL SERVER 2000
Ramanpreet - 24 Nov 2007 11:18 AM - 2 messages
Hi All, Good Morning. I Have installed SMS 2003 on one of my Servers with SQL Server 2000 as its database with SP4.Some days back my server started misbehaving for which i did a fast repair for the Operationg System which is windows 2003.After which ...
Score SQL Express - Identity specification
Mike - 23 Nov 2007 7:54 AM - 5 messages
Hi, I use SQL Server Enterprise Manager for MS SQL Express and i want to change the column properites for [int] type of column, but I cann't change it. More in details... I'd like to set autoincremntal option and in order to change that I am ...
Score Where to learn how to read the query execution plan?
pedestrian via SQLMonster.com - 26 Nov 2007 4:24 AM - 8 messages
I'm wondering why (book, website etc...) could I learn how to read the query execution plans and subsequently modify to enhance the performance of the queries. Thanks for you reply. ...
Score sql 2005 std increase server memory limit >2GB?
Piotr Lipski - 26 Nov 2007 9:03 AM - 4 messages
Hi. Is there any way of increasing memory available for SQL Server 2005? The maximum I can set from SSMS is 2GB. There is 4GB server designed exclusively for SQL databases so I would like to set the memory limit to ...
Score Newbie-shrink transaction log files
Coop - 26 Nov 2007 3:41 AM - 3 messages
Hi.  I know this is an often-discussed topic, but I hope you can clear up some confusion for me.  I set up a SQL Server 2005 maintenance plan to back up my databases to disk (we also backup to tape using Backup Exec).  My goals ...
Score Database compromise - need help
tnt - 24 Nov 2007 6:28 AM - 4 messages
Hello, Our db has been compromised.  A column in the table has been changed to something unwarranted for.  I need suggestions on how to track this or at least give me some clues on how these bastard made into our database. ...
Score Receive "Acquiring a connection requires a valid Task name" when execute a DTS
Dobby Cai - 26 Nov 2007 3:44 AM - 2 messages
Hi All, I'm creating "DTSExecuteSQLTask" Task in DDQ ActiveX script code. Then I'm trying to execute it from within this code with command: oCustomerTask.execute oPkg, Nothing, Nothing, DTSTaskExecResult_Success but I receive error message: "Acquiring a connection requires a valid Task name". ...
Score Trigger to fire only after a commit.
Avi - 22 Nov 2007 8:30 AM - 7 messages
Hi Experts, I would like to know if there is a way to have triggers that fire only after a commit.  If not, is there a workaround that will give me the same affect? Avi ...
Score Why does MS SQL 2005 Management Studio runs/loads @ a snail pace?
stevong - 23 Nov 2007 3:32 AM - 5 messages
Hi everyone. Im not sure whether Im the only one facing this issue. Despite that MS SQL 2005 management studio is the only active application running on the foreground, it can load pretty (very) slow. Eg: you right click a table, to go into DESIGN mode - the mouse cursor ...
Score Odd query result in SQL server 2000
Eiriken - 24 Nov 2007 11:02 AM - 6 messages
Hi, I am running SQL Server 2000, SP4. I have stored procedure with a query like this: SELECT COUNT(*), -1 FROM     PERSON_MEMBERSHIP PM LEFT OUTER JOIN PERSON_UNIVERSITY PU ON PM.PER_ID=PU.PER_ID     LEFT OUTER JOIN PERSON_EDUCATIONTYPE PE ON PM.PER_ID=PE.PER_ID ...
Score xpweb90.exe
gurbao - 1 Mar 2007 11:24 AM - 5 messages
Hi, we have sql server 2005 EE SP1 in a cluster with 3 instances. 50% CPU and when profiling I found a couple of EXECUTE [web_20070301031622647568]   -- seems to have a timestamppattern in the number using  more than 4 000 000 CPU ms and more than 185 000 000 reads !! ...
Score Error Connecting SQL Server 2005
carmen413 via SQLMonster.com - 23 Nov 2007 3:12 PM - 3 messages
Hi There, Any one can help me suggest what to do with below problem? while install SQL Server 2005, there is no Authentication Mode Option prompted out for users to select The Mixed Mode. This is installed using the correct Copyright from Ms SQL Server 2005 CD with Standard Version, where it ...
Score Optimizing and shrinking large highly-transactional database
Curtis - 21 Nov 2007 9:00 PM - 6 messages
Hi, I have a 50GB database on SQL Server 2000 Enterprise that is highly transactional in a 24x7 environment. There's approximately 8 GB of free space, so I want to shrink it. It has been online for over five ...
Score cannot drop mdf file
Roger - 21 Nov 2007 8:07 PM - 4 messages
Hi All, I cannot drop a mdf file that don't have a database but is in data directory,. Can you help-me ? I'am using sql server 2005. TIA ...
Score Logging from SP
Mohit K. Gupta - 21 Nov 2007 8:56 PM - 4 messages
Hi,    Is there a way I can log to a output file from a SP when executed from with in an application? ...
Score Error when limiting memory usage with OSQL.EXE
Tom Del Rosso - 23 Nov 2007 8:34 PM - 5 messages
When trying to limit the memory usage of the SQL components of Small Business Server, I get an error message I don't know what to do with. I searched for an osql internal command reference, but all the references I ...
Score Live server running out of space - Can't reduce Transaction Log!
Mike Owen - 23 Nov 2007 6:04 PM - 10 messages
Hi, I have just come across a bit of a problem of my Windows 200 server running SQL Server 2000.....I am running out of space! I have aout 2GB left.  I have know this for some time, and for technical ...
Score SQL 2000 Std on Win 2003 Std R2 x64 bit?
Leythos - 23 Nov 2007 1:10 PM - 4 messages
I have a IBM 3800 server with 8GB RAM (currently setup in Fail Over mode for memory - 4GB acts as a backup for the other 4GB RAM). The server has Dual Quad Core CPU's in it also. We run SQL 2000 Std with CPU licenses and I've limited SQL to 1.7GB RAM ...
Score SQL 2005 and Pervasive Linked Server
Steve Z - 23 Nov 2007 3:23 PM - 5 messages
We are migrating from SQL 2000 to SQL 2005. One of the requirements we have is to link to a Pervasive DB.  We did this successfully under SQL 2000 with a SYSTEM DSN using ODBC.  The LINKED SERVER ...
Score Copy views from one database server to another
db - 22 Nov 2007 5:50 PM - 10 messages
Hi I have few views on SQL server 2000, which I want to copy to sql server 2005 database. I want to schedule a job to do it every evening. What is the best method to do this? Thanks ontario ...
Score SQL Server better than DB2
Ian Boyd - 19 Nov 2007 9:56 PM - 8 messages
About two years ago we had to deal quite heavily with DB2. DB2 is a monsterous mess. Having used SQL Server so long i felt like i was being tortured with DB2 and it's tools. i had a few back and forth conversations ...
Score SQL server - cant see new backuped base
piwo - 22 Nov 2007 3:45 PM - 8 messages
Hi all! i got problem with one program which works on sql 2003 server. We backuped data from other base and created new base on other server. When we try to connect from client to that base - we cant see our new base in chose base ...
Score Setting up SQL Relationships?
Mark Moss - 23 Nov 2007 4:29 AM - 2 messages
Help         I have not worked with SQL Server For several years and I have the following question.         I want to set up a relationship between a Parent Table and a Child ...
Score Event 18454 connection non-trusted
pcnetnet - 22 Nov 2007 3:49 PM - 3 messages
Hi All,     i don't know which problem or setting error ? the event log many many event on this "18454 Login succeeded for user 'Login1'. Connection: Non-Trusted "  in 3 hours display 10000 record for this ?? how to disable ...

Developed using NextGeneration, the .NET Code Generator Try AdSense Reporter, the charting tool for AdSense publishers