Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
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 Backups to another server from SQL Server
Pat M - City of Reno - 29 Nov 2007 9:16 PM - 2 messages
I know we don't have the best server for this question but here it is. Why can't I backup to another server? It seems SQL Server will only allow me to backup to drives attached to the existing server. Am I missing something ...
Score Join between 2 tables, that exist on different sql server instances
Andy - 29 Nov 2007 8:26 PM - 2 messages
I know you can do a join between 2 tables that exist in seperate databases within the same SQL Server 2005 instance by prefixing the table with the database name, seperated by a period. Is it possible to still do the join if one of the databases is in ...
Score -- encrypt database --
Edmundo J. Davila - 29 Nov 2007 7:22 PM - 2 messages
Hi, Sorry for the message in spanish I confused the group. Is there a way to encrypt a database (tables, columns, etc.) ? I want that nobody can see the data model of my application Probably it's impossible to deny access to the database, but at least if ...
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 -- encriptar bd --
Edmundo J. Davila - 29 Nov 2007 7:08 PM - 1 message
Hola, ¿hay alguna forma de encriptar una base de datos (tablas, columnas, etc.) de tal forma que no se pueda ver el modelo de datos de una aplicacion al menos de forma clara? Se que posiblemente sea imposible impedir el acceso, sin embargo, si alguien ...
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 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 SQL log purge...
Daniel - 29 Nov 2007 5:35 PM - 3 messages
Is there any suggestions on what we can do to help prevent our logs from getting out of hand... Maybe a purge process or settings to keep only certain amount of data before it starts overwriting... Current settings: Initial Size: 21991MB ...
Score VB Script
Charles A. Lackman - 29 Nov 2007 5:22 PM - 1 message
Hello, I have a script that restarts a service, I have it running from the Task Scheduler under Administrator.  If I double click the script, it runs great, however, when the Task Scheduler runs it, the command prompt opens and ...
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 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 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 transfer large amt of records
mecn - 29 Nov 2007 4:22 PM - 2 messages
Hi, What is the best way to transfer large records 50 millions / week from one sql server to another. I need to autimate the weekly process. I can do it bypassing transaction log file... THnaks, ...
Score SQL 2000 How do I setup SQL Mail for Failure Notification
Baris Ratanjee - 29 Nov 2007 3:54 PM - 2 messages
I have SQL2000 installed on a Domain Controller. I have developed some DTS that need to run every night. However I would like to be notified when the job fails. How can I enable the SQL Mail. Currently I do not have any Mail ...
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 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 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 Best way to compare two XML fields
Avi - 29 Nov 2007 2:38 PM - 1 message
What is the best way to compare two XML fields in SQL Server 2005. Thanks, Avi ...
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 Svr Express Access ADP and Reports
John Kraus - 29 Nov 2007 12:41 PM - 1 message
I've been working through making an Access 2007 DB into an ADP application with SQL Server Express and all is OK with tables, relationships, forms etc. However I have encountered a snag with reports. In the native Access DB this ...
Score Severity 20 error messages in Error log
vijay - 29 Nov 2007 11:45 AM - 1 message
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 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 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 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 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 SUSER_SID always NULL ?!?
AAron.nAAs - 29 Nov 2007 4:57 AM - 1 message
Any ideas why my SUSER_SID(@login) is ALWAYS returning NULL ?!? Machine A:    Name: aa    Member: WORKGROUP    Sql Server 2005 Express    Sql Server Management Studio Express    Manage Computer / Local Users and Groups / Add user: fresh ...
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 exec stored procedure without qualifying dbo
Hassan - 29 Nov 2007 3:52 AM - 2 messages
I know it was best practise to call a stored procedure as "exec dbo.sproc" instead of "exec sproc" I guess it was in reference to compilations. But when i monitored compilations/sec and recompilations/sec, I did not see ...
Score Kerberos in Cross-Forest trust - Fails back to NTLM or Cannot generate SSPI Context
Neufusion - 29 Nov 2007 1:01 AM - 1 message
I established a Windows 2003 level cross-forest trust between domain.local and domain.com . I cannot get domain.com to allow kerberos authenication using a domain.local user. I am using SQL Server 2005 w/SQL Server Management Studio as the ...
Score Replication
David S. - 28 Nov 2007 7:55 PM - 1 message
If I am being provided access to a view over a connection that is too slow to actually run meaningful queries over, what is the best way for me to create a nearly up to date (within 5 mins or so) copy if the company ...
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 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 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 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 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 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 Database 'model' cannot be opened. It is in the middle of a restore
nobody - 28 Nov 2007 4:02 PM - 2 messages
[link] how do i run this if my database is msde? ...
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 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 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 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 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 Sql better than Oracle?
Paulo - 28 Nov 2007 12:37 PM - 8 messages
Any articles? Comparisons? ...
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 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 Check if master key was defined in master db
Avi - 28 Nov 2007 10:03 AM - 1 message
Hi all, How can I check if master key was defined in Master db.  I checked the sys.key_encryptions table but from the table it is hard to know which of the line(s) is for the master key. ...
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 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 Pivot Query....
Tremmorkeep - 28 Nov 2007 5:00 AM - 2 messages
Working on roles for projects (roles are granted and denied based on dates) and I need to display a summary (on the web) that lists the roles down the left column, with the dates along the top, and the numbers needed in the matrix that results from the rows and columns ...
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 dtproperties table
William (Bill) Corder - 28 Nov 2007 1:16 AM - 1 message
I'm using SQL 2005 and have one database where the dtproperties table is not under the system table folder. The dtsysdiagrams table shows up in the correct place for this same database. Does anyone have any idea why this would occur and how to get dtproperties back to this folder?   Can I delete the table and the server will recreate it? ...
Score samples not installed
sharman - 28 Nov 2007 1:13 AM - 3 messages
I recently installed sql server 2005 on win 2003 server. The Samples folder within the C:\Program Files\Microsoft SQL Server\90 was never created. Because of this I can't install the Sample Reports, etc. How do I install it? ...
Score Login failed for user '(Null)'
Jay - 27 Nov 2007 11:19 PM - 2 messages
Our QA guy just asked me for some help because he suddenly got the (dreaded) "Login failed for user '(Null)'" message when connecting to the QA database from his desktop. There have been no (known) changes since he last used it a week, or two ago ...
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 Obtain the sql server properties by code...
Chevy - 27 Nov 2007 9:24 PM - 3 messages
Hi, a need to make a report wich contains the most of properties o an instance o SQL Server 2000. The same information that appears on the SQL Server Properties in the Enterprise Manager. I have 25 servers and I wonder if I can get that information by a ...
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 java version for ssma (oracle migration)
jos - 27 Nov 2007 8:29 PM - 1 message
After installing the ssma application exits after the error message: you are running java version 1.4.2_05, required at least 1.4.2_06. The command line java -version returns to me that i am running 1.5.0_06 Any suggestions? ...
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 create table
db - 27 Nov 2007 7:33 PM - 3 messages
Hi How to create a table by selecting data from different tables. Can we create table with actual data while selecting data from different tables. If yes what is the syntex. ============= Syntex for createing a view is create view as ...
Score moveing data
db - 27 Nov 2007 7:06 PM - 2 messages
Hi I need to move data from few tables in sql server 2000 SP4  to sql server 2005 database. I can select the data using a select command from all the tables and  save it in a text file. ...
Score Moveing data
db - 27 Nov 2007 7:01 PM - 2 messages
Hi I need to move data from few tables in sql server 2000 SP4  to sql server 2005 database. I can select the data using a select command from all the tables and  save it in a text file. ...
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 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 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 Added SP2 now have linked server error
TLuebke - 27 Nov 2007 3:11 PM - 3 messages
I added SP2 to my 2005 server and now I can't connect to a previously working linked Oracle server.  I get this: TITLE: Microsoft SQL Server Management Studio ------------------------------ "The test connection to the linked server failed." Cannot initialize the data source object of OLE DB provider "MSDAORA" for ...
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 sql server secuirty configuration for single user
Scott - 27 Nov 2007 3:01 PM - 1 message
Hi, My aspx app connects to sql 2005 db via web.config conneciton string. I have a user name in the string but need to configure the users security prilevelges and dont know where to start. This user needs to run store procesdues with select, insert, update, delete ...
Score sql 2005 copying dbmail configuration between servers
Piotr Lipski - 27 Nov 2007 1:45 PM - 3 messages
Hi. Does anyone know how to copy Database Mail configuration from one SQL Server 2005 instance to another? There is only one (relatively simple) DB Mail profile to copy so I can just re-create it on the destination server from scratch but I'm just ...
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 INDEX USAGE
GeneroDudas - 27 Nov 2007 10:49 AM - 3 messages
Hi, Can anybody help me, i'd like to know if there is a way to get index usage in SQL SERVER 2000 through Transact sql, no through the Index Tuning Advisor. Just like does SQL 2005 with dm_db_index_usage_stats. Thanks in advance, or just for reading. ...
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 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 Fulldatabase backup query
Balaji - 27 Nov 2007 5:20 AM - 3 messages
SQL Server full backup displays the following message on successful completion of the full database backup. Processed 1136 pages for database 'MyDB', file 'MyDB' on file 1. Processed 3 pages for database 'MyDB', file 'MyDB_log' on file 1. BACKUP DATABASE successfully processed 1139 pages in 0.902 seconds (10.336 ...
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 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 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 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 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 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 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 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 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 SSIS vs. Replication
Jay - 26 Nov 2007 6:14 PM - 5 messages
Just curious, but I'm wondering which is better to move large amounts of data from a production server to a local server: SSIS, or replication. I know it is a rather broad question, but I'm kinda hoping someone has ...
Score -- error creating maintenance plan --
Edmundo J. Davila - 26 Nov 2007 4:47 PM - 2 messages
Hello, I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan includes rebuild indexes, check integrity, update statistics, etc. I'm using the wizard to create to plan, but at the when I press the finish ...
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 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 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 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 Database Engine Issues
Chris - 26 Nov 2007 2:06 PM - 1 message
I'm having problems installing the database engine onto my computer. Essentially I'd like to completely remove SQL Server from my PC and start again, however the services (Analysis etc.) seem to be left on the pc and 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 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 SQL 2008 Express
Mahmoud Amin - 26 Nov 2007 7:22 AM - 3 messages
Hi, I installed a new instance of SQL2008 on my machine, because i need my SQL2005 still runnig and make a look on SQL 2008. after finishing the installation i could not get any feature except the configuration manager, and from the installtion center i found "how to add ...
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 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 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 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 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 SQL 2005 Reporting output problems
cpchan - 25 Nov 2007 3:23 PM - 1 message
Hello, I have the following SQL 2005 Reporting Service output problem : A normal SQL 2005 Reporting Service output should have 6 choices for us to choose : XML file with report data, CSV (comma delimited), TIFF file, Acrobat (PDF) file, Web Archive, Excel. ...
Next »