Home All Groups Group Topic Search About



Score Policy management
Abba - 10 Jul 2009 6:08 AM - 4 messages
Hello, [SQL2008] Iam trying to evaluate Policy management feature. (1) There are number of policies that are shipped with Microsoft SQLServer. I tried "database auto close" policy and purposefully, put one database in auto close=true. Then scheduled the policy and specified the job to email ...
Score SQL cannot connect to database for OnePoint/MOM/ForeFront all of the sudden???
Andrew Weaver - 8 Jul 2009 3:47 PM - 15 messages
I just noticed today that my MOM/ForeFront server wasn't working anymore, so I've worked backwards and I notice now that SQL cannot open the OnePoint database via the SQL Management studio. I've checked the logs and it says: ...
Score report on indexes on foreign keys
tolcis - 8 Jul 2009 7:32 PM - 8 messages
Hi, I have a database with over 100  tables.  About 60 of them starts with tblssl_.  I need to look at every table, find out if it has foreign keys and figure out if that key has an index on it.  That foreign key ...
Score SPQ 2005 Server service pack 3 failed and now I cannot open Accoun
SiouxMax - 9 Jul 2009 6:01 PM - 5 messages
I have had real problems since a Mircosoft automatic download tried to install SQP 2005 Express Service pack 3. Since then I have not been able to open my Microsoft accounting 2009 and I have to close my books to send to taxman, so this is a CRTICAL issue for me.  ...
Score Newly created SQL login can't read any databases - can I give it permissions to read all databases
franklinhu - 9 Jul 2009 5:04 PM - 4 messages
I have observed that if you create a new SQL login user and only grant it the public role, that this user cannot do selects on any database on the server - which makes it pretty useless. To get around this, I ...
Score Locks and SQLAgent - Generic refresher, Alert Engine
db - 7 Jul 2009 1:22 PM - 11 messages
Sql server 2000 sp4 1. I have two programs running  on msdb database (SQLAgent - Generic refresher) abd (SQLAgent - Alert Engine). What are there processes? 2. I need to understand lock modes (s,X,IX,X, sch-M) AND LOCK TYPE (key,DB, ...
Score deleting DB
Dooma - 6 Jul 2009 2:34 PM - 12 messages
I have SQL 2000 server. I am running out space on my hard drive. I deleted unwanted database from my enterprise manager. The database is still in the folder. Can I delete it manually from there? Please advice. Additionally, any hints on how to increase space on my hard drive? ...
Score How to inser unique record into a table?
aspfun via SQLMonster.com - 9 Jul 2009 4:29 PM - 4 messages
How to inser unique record into a table? Table A has a primary key in MemberID. I used code below but got error said Violation of PRIMARY KEY constraint 'PK_ID'. Cannot insert duplicate key in object 'A' INSERT INTO A(MemberID) ...
Score installed SP3 but @@version shows sp2
Scott - 9 Jul 2009 2:01 PM - 4 messages
Hi, I install SQL 2005 standard edition SP3 which completed with no errors. When running select @@ version Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows ...
Score Log Shipping and extremely large .wrk file
Paul - 9 Jul 2009 10:54 AM - 4 messages
Hi, I have re-set up log shipping on a large database (124gig). Because of the size of the database I used Quest Litespeed to back up the database and move it to the remote server over a very slow link which took ...
Score Exception Access Violation in SQL
Pentair - 8 Jul 2009 7:04 PM - 4 messages
I'm having intermittent trouble with an OPENQUERY statement that pulls data through ODBC from a Progress database into SQL 2005. Most of the time it works, but every couple weeks, one of the many calls using this method bombs ...
Score using profiler to log master.sysprocesses entries ?
Scott - 8 Jul 2009 8:36 AM - 11 messages
Im running the following: select * from master..sysprocesses where spid in (select blocked from master..sysprocesses) or blocked != 0 EXEC sp_who 'active' To help me ID possible locking performance problem. I keep the profiler running 24/7 looking for queries over 5000ms which also ...
Score Growing log file issue
sacgar - 8 Jul 2009 9:55 PM - 6 messages
we have indexing jobs which keeps on increasing the log file for online index maintenance for our sql server 2005 instance , is there any way we can minimize the growth with out taking db in simple recovery mode , currently it ...
Score Shrinking transaction logs
HDI - 8 Jul 2009 9:00 PM - 3 messages
Hello, I am new to SQL server administration. I noticed that my backup system didn't backup the log files. Now it does but the log files have a lot of free space. I read a lot about this but what's the best thing I can do now to ...
Score ID large queries while they execute and kill
Scott - 3 Jul 2009 8:39 AM - 10 messages
Hi, Im having a problem with large read queries initiated by end users causing problems with my write times. i would like to understand how to ID the query while its running and kill it. I use profiler and i see the query after its executed but how do i ID a ...
Score sql server management studio to connect to database
db - 30 Jun 2009 1:28 PM - 6 messages
SQl server 2005 SP2 I have a sql server 2005 SP2 on which I have three databases dev,prod and test. I need to grant only select access to some users on all three databases so that they can query the tables/views. ...
Score Best Practices - using params passed to stored procedure
css - 7 Jul 2009 3:14 PM - 11 messages
Which method is preferred, I am asking this question in terms of best practices Question came to my mind because of parameter sniffing but a) use passed in stored procs parameters directly in your WHERE clause CREATE PROCEDURE uspGetDATA @param1      INT ...
Score SQl Server Reporting Services - migrating 2000 to 2008
JaffaB - 8 Jul 2009 11:19 AM - 4 messages
Hello All, We are completing the process of migrating a SQL Server 2000 server to SQL Server 2008.  the last thing to do is migrate (or recreate) the SQL Server reporting services reports. Can anybody point me to any URLs or provide a guide on how we can ...
Score SQL 2k and autonumbering
jmillerWV - 7 Jul 2009 7:01 PM - 5 messages
Hello all, I have an Access 2k3 Database I am moving to SQL 2k. In Access I used the autonumbering property to generate a "Record Number" for work to be preformed by us. This record number was placed on the work sheet as soon as it printed. ...
Score Null parameter to function doesn't seem to be processed
Rotwatcher - 8 Jul 2009 9:13 AM - 3 messages
I have a function that takes a bit parameter and returns a text substitute.  I use it in this kind of operation: SELECT dbo.fnReturnYesOrNo(MyTable.BitColumn) AS YesOrNo FROM MyTable However, if any values of MyTable.BitColumn are NULL then it returns ...
Score Connection server utilizing trusted connection to other SQL Server
Michael Kremser - 7 Jul 2009 9:37 AM - 10 messages
Hi NG! If I command "New connection server" in SQL Server Management Studio, enter the name of the server, choose "Use current security context of application" (the third option, unfortunately I have a German version here) in "Security", and say "OK", I get the following error message: ...
Score drop table not showing up in the transaction log
wpfeffer - 6 Jul 2009 7:29 PM - 9 messages
Is there a reason why a drop table command wouldn't show up in the transaction log? Sometime this morning, some one or some thing dropped a bunch of tables from one of my databases. I've been using ::fn_dblog (NULL, NULL) to poke around ...
Score RESTORING
Svein Ingebrigtsen - 7 Jul 2009 7:28 AM - 9 messages
Hello, our system: MS SQL Server 2005, SP3 I suddenly got the following error in my SQL log: The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run. 2009-07-07 08:26:08.33 spid9s      Error: 927, Severity: 14, State: 2. ...
Score Backups & Transaction Files
PsyberFox - 6 Jul 2009 2:18 PM - 5 messages
Hi, I am having some issues with my transaction files on SQL 2005. I am running a full backup every evening and I expect my transaction file to be cleared to the data file. However, this is not happening and my ...
Score strange BLOB beahaviour
grbihno - 6 Jul 2009 11:11 AM - 9 messages
Hi everyone. I'm a junior DBA at my firm, and have recently noticed a very strange behaviour with a certain view in my database. I have a few tables with BLOB's that are combined in one view using two select's and a UNION containing about 1.5 million rows. Everything worked fine since recently. ...
Score AWE on SQL Server2005
kunalap - 6 Jul 2009 10:47 AM - 14 messages
Hi, I have a server where their ASP menu page running recusive queries takes a long time to load. We have created indexes as per queries in the menu page and now are looking at setting SQL Server to use 3GB out of the 4GB memory available on the ...
Score share Template location for SSMS
Gal - 26 Jun 2009 11:29 AM - 5 messages
Is there a way to share templates for SSMS 2008 with all the development team? As far as I understand the templates are in "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Assembly" if I want to have a network path for every body to use the same, How do I do ...
Score How best to move large databases?
Stephen - 6 Jul 2009 1:39 PM - 5 messages
I need to move a 50GB SQL 2005 database to a new server that is about a thousand miles away, and I only have about 12 hours of down time in which to get it done.  I'm looking for the best way to do this.  Set ...
Score Problem with triggers an ntext
Jonathan Crawford - 2 Jul 2009 1:44 PM - 4 messages
Hi I have a bunch of triggers which back up data being deleted into another table. These work fine except for one table with ntext fields. I found that INSTEAD OF works with this however it does back up the table ...
Score 32 bit SQL Server on 64 bit OS
Jonny Bergdahl - 24 Jun 2009 7:51 AM - 12 messages
According to the specifications SQL Server 2005 Standard Edition can use "Operating system maximum" RAM. Does this mean that it can use all memory of a machine running 64-bit Windows Server 2003 with 16 Gb RAM? If so, are there any special settings ...
Score 'Generate scripts' functionality in SQL 2005 not being consistent
devprog@msbcomp.com - 3 Jul 2009 4:07 PM - 5 messages
I'm running SQL 2005 (version 9.0.4035) and I like to use the 'Generate scripts' functionality in SQL Server Management Studio to create one big file with the scripts for an entire db as a way to track changes to the various ...
Score Multiple databases performance
Jonny Bergdahl - 23 Jun 2009 8:16 AM - 33 messages
I have developed a system that potentially will be run by thousands of customers. In order to make it easy to partition the system on multiple servers, I have opted to use a separate database for each customer. That way, as the number of customers grow, I can easily add SQL servers to divide ...
Score problem with new login
Ben - 2 Jul 2009 5:23 PM - 5 messages
Hi, i defined a new login 'test' for Management Studio sql server express 2008. This account must be able to connect via Sql server Authentification and must be able to access database 'dbtest', but not the others. There are three databases: 'db1', 'db2' and 'dbtest'. ...
Score Cartesian with one table
adamscc - 3 Jul 2009 10:00 AM - 2 messages
Hi I have entered some extra fields "site_name and site_code" into some SQL but when i try to use it to search for one record i recieve a result against every site availible in the database. I have linked the site to the existing data and have referenced it in the ...
Score Problem with SUM - Help please
Edward - 3 Jul 2009 10:15 AM - 3 messages
See DDL Below Put simply, I need to get some numeric values in a SELECT statement and then SUM them (I realise in the example below that I don't need to SUM them, I can just + them).  The numeric values are stored in a ...
Score Install SQL Server 2008 Questions ....
Patrick - 1 Jul 2009 11:40 AM - 6 messages
We just start testing SQL Server 2008. During installation, we would like to ask a number of questions: 1) Which account should be used ? Network Service or System. 2) When we choose "Mixed Authentication", it seems that we are not able to ...
Score How to Enqueue Messages With Service Broker in a Timely Fashion
Charles - 28 Jun 2009 6:58 PM - 24 messages
I have an application that puts data into a table in a remote database instance. The problem is that when the database or network is down the application has nowhere to put the data. To overcome this, I have decided to ...
Score Autostatistic ON/OFF on separate tables?
GG - 1 Jul 2009 12:53 PM - 8 messages
Hi Is't possible to set Auto updatestatistic ON and OFF on separates tables or is't only on database level? Regards GG ...
Score Indentation of code in SQL server 2005
pacman - 28 Mar 2006 1:06 PM - 5 messages
I am new to SQL server 2005. If there are many nested if conditions, it becomes difficult to map the begin and corresponding end tags of each block. Is there any tool/tip by which I can trace which end corresponds to which ...
Score Column Limits
Derek Howard - 2 Jul 2009 4:40 PM - 3 messages
I have 100+ fields of data in a single record relating to an individual person. The data is unique to that person and has a one to one realtionship to him. I have been told that that is to many fields and that it should be ...
Score Activity Monitor not showing Database names
tshad - 26 Jun 2009 9:36 PM - 8 messages
In 2005, I can open the Activity Monitor and in Process Info, I can see the Process ID, User and Database. In 2008, in Activity Monitor and in Processes, I can see SessionID (which I assume is the Process ID from 2005) andLogin (which I assume is User from ...
Score database log file keeps growing
Pingx - 2 Jul 2009 5:27 PM - 5 messages
Hi sql server experts: I thought if I set the recovery mode to SIMPLE, the log will not grow. But it is not true. How do I set up the database so that the log file does not grow? Thanks, ...
Score sql replication
INPUTIO - 1 Jul 2009 9:03 AM - 6 messages
Hi guys, exist any replication  method in SQL that the target db server avaialble for reading ? I need to replicate my database on another server but after i would make a query on this database target. The questions is for 2000 and 2005 SQL products. ...
Score SQLhas encountered 2 occurrence(s) of IO requests taking longer th
Suchi - 2 Jul 2009 10:20 AM - 5 messages
HI All, Environment: WIN2003 Enterprise Edition SQL2000 with SP4(cluster with 2 nodes) I see below messages in SQL logs almost everyday for tempdb and for other few databases. They are more for tempdb. The Tempdb is on seperate drives. ...
Score Saving images
arganum - 1 Jul 2009 8:43 PM - 4 messages
I hope that I can explain what I am trying to do well enough to get help with it. I made an application where my user will browse for an image on their computer and when they submit the form, the image will be saved in my ...
Score Maintenance did not delete old files
m_amin33 - 29 Jun 2009 8:34 AM - 11 messages
HI All, [SQL 2005 Standard Edition with SP3] I have a problem with maintenance plan that created on SQL server 2005 to take a full backup then delete old files that older than 10 hours. it is running well on taking the backup file, but it does not delete old ...
Score SQL Server Programming Books
Scott - 30 Jun 2009 7:38 PM - 4 messages
Hi Folks, I'm looking for 2 books, or perhaps 1 that covers off both TSQL and stored procedures. I've got the Inside SQL Server series, and these are great for performance tuning, etc. I'd like a book(s) that teaches you from "just above ...
Score SQL-server Strange Behaviour ?
ben brugman - 30 Jun 2009 10:39 AM - 5 messages
-- Using SQLserver 2000, ...
Score Disk full from delete
tshad - 15 Jun 2009 11:00 PM - 15 messages
I am deleting over a 1.5 million records which is running my log out of space and it is set to Siimple Recovery. So now I need to break up my delete statement into 3 statements.  Just trying to find the best way.  I am deleting all the records and can't purge. ...
Score Raid levels
tshad - 30 Jun 2009 7:15 AM - 5 messages
I am trying to get ready for my 70-431 test and am really confused on Raid levels.  I know what they are but I am using different books and tests and they all say different things. Raid 0 - fast but no fault tolerance.(stripe) ...
Score Upgrading from SQL Express to SQL Enterprise
FD - 29 Jun 2009 6:55 PM - 5 messages
Hi all, I am fairly new to SQL and have run into a problem where I need some help. I have a  test MOSS 2007 installation that is running on SQL Express and I wanted to upgrade it to SQL Enterprise.  I used the SKUUPDATE=1 switch ...
Score Create Database on the server
Lubomir - 29 Jun 2009 7:14 PM - 6 messages
Hi, I would like to ask those of you, who are SQL Server admins. Our software product creates a database and all tables that are needed for this product to work properly. In the previous versions, our product installer just deployed database to ...
Score Rolling back bcp takes forever. Shouldn't.
Snake - 29 Jun 2009 9:14 PM - 5 messages
I had to kill a SS2008 bcp-in because of space issues with the log file device.  I believe the bcp had actually loaded the rows but had moved-on to creating the Clustered index. The flat-file had 147,000,000 rows @35 gig. It ...
Score collation for multiple language in a column
Boyan - 23 Jun 2009 9:43 AM - 4 messages
I need to store different languages of text in a single column as nvarchar. When selecting text from this column targeting a particular language, I wish I get the results sort by meaning dictionary order. One way is to append a ...
Score Unable to access the tape for database backup purpose
borase - 26 Jun 2009 12:35 PM - 5 messages
Hello everybody,    i have been suffer from problem that, I have installed the HP workstorage Ultrium 448 tape drive and able to take database backup using the NTBACKUP utility. When trying to take backup of  database from  SQL server 2005 ...
Score using profiler to capture errors
Hurme - 26 Jun 2009 8:11 PM - 3 messages
I'm testing an application that is returning a very generic "Duplicte key has already been added" message to the end-user. Is it possible to capture errors that are returned by the dbms to the end user using the profiler or some ohter tool? If so, what is t he best way to ...
Score Can I script out SQL Server jobs programmatically?
josephs - 22 Jun 2009 7:36 PM - 14 messages
Does anyone know how to script out a complete job definition (job creation script) from a T-SQL query? In SQL Server Managment Studio, you can right click a job and script out a complete definition. I just want to call this ...
Score Missing Index Details
Abba - 26 Jun 2009 5:58 AM - 4 messages
Hello, [sql2005] Do you know which feature of SQL gives an output like this: "Missing Index Details from ExecutionPlan1.sqlplan. The Query Processor estimates that implementing the following index could improve the query cost by 24.8260%. " TIA AbbA ...
Score how to fix error "Connection is busy with results for another hstmt"
vijay singh - 24 Jun 2009 10:55 AM - 6 messages
Platform: VS 2008, SQL Server 2005, OleDB Hi, I am using OleDB connection in vc++ code to insert data in sql server database. Single connection is being used by multiple threads to insert data. Sometime program is reporting error "Connection is busy with results ...
Score Server2000 Std Edition Timeouts
HMSSkeptical - 25 Jun 2009 1:03 PM - 8 messages
Hi All, Have apps on user XP PCs running Server2000 MSDE - sharing into db on MS Server 2003 x64 file server with SQL Server 2000 Std Edition Single CPU Unlimited users (with all latest hotfixes Build 8.00.2249, using the 32 bit ...
Score Access 2007 Import Wizard
Ken - 24 Jun 2009 2:43 PM - 4 messages
I am trying to import a Access2007 database using the import wizard. The open dialog only shows extensions of *.mdb and does not have *.accdb. I selected all files and received at error: "TITLE: SQL Server Import and Export Wizard ...
Score stats_ver_current?
Ola Hallengren - 24 Jun 2009 8:23 PM - 7 messages
I was looking at the code in sp_updatestats. I had an ideas about using some of the logic in a custom script. I thought that I would start by creating a copy of sp_updatestats. That was not so easy. I get this error message. ...
Score refer to db table
geebee - 24 Jun 2009 2:29 PM - 7 messages
hi I have a SQL server 2005 query and I am trying to refer to an ms access table to use in the query. I cannot create a table or view in SQL server because its note server. What would be the best solution to refer tonthe ms ...
Score setup a sql login which can only reset password
sarah - 23 Jun 2009 1:55 PM - 8 messages
Hi, I'm using sql2005. I want to setup a sql login for our helpdesk to reset sql login password only. Please advice, Thanks Sarah ...
Score Backup and restore sql server 2005
Fabrice - 19 Jun 2009 3:19 PM - 5 messages
Hello, A question about backup and restore. I'm not an export of sql server. I have installed sql server 2005 on windows 2003 R2. On my server i have two partitions. C: and D: Mon named instance is installed on D: ...
Score Securing MSSQL
Paulo - 24 Jun 2009 7:58 PM - 4 messages
Hi, if any one enters as administrator account on windows server will have access to the MS SQL DB... I changed the sa pwd account... I'd like just me (developer) having access to it... Is it possible? Can I create some user that just this account can access the ...
Score Modifying table issue
John - 24 Jun 2009 5:27 PM - 4 messages
Hi When I try to modify a Bit field's Allow Null to No, I get the message that change can not be made without dropping the table. The table contains data. How can I make this change while maintaining the data in the table? ...
Score dbcc checkdb fix
Andy Siegel - 24 Jun 2009 3:59 PM - 4 messages
I'm not a DBA and this is all very new to me.  I looked through some previous posts, but didn't find what I was looking for, so I'm sorry if I just missed it. I just upgraded my SQL 2000 server to 2005.  I immediately started getting ...
Score Import SQL Data to Word/Export Data from Word to SQL?
Andrew Staley - 24 Jun 2009 11:01 AM - 4 messages
Is it possible using Microsoft Word, SQL Server to create a document template that will import data into mail merge fields.  And then if the data in that field is changed, for that change to be written back to the SQL ...
Score SQL Timeout Error
Accesshelp - 23 Jun 2009 3:06 PM - 13 messages
Good morning all, I just created a View, and when I tried to run it, I received the following error message: error message: timeout expired.  the timeout elapsed prior to completion of the operation or the server is not responding. ...
Score Query is much slower in 2008 than in 2005
wpher56 - 19 Jun 2009 1:22 PM - 7 messages
Hello all we have a query involving several tables, subselect and scalar-valued functions. It ran in about 10 minutes in SQL Server 2005 on a old server with 4 GB of RAM. Now we upgraded to SQL Server 2008, on a server with 8 ...
Score Sql server 2000 client libraries and SQL Server 2008
Russell - 24 Jun 2009 7:53 AM - 6 messages
I am currently working on the upgrade of our Coda Financials system. the current version is running on SQL Server 2000. However I am keen for the new version to be on the latest version i.e. 2008. However the vendor has said that as two of the modules require the Sql ...
Score understanding metrics/performance
Jack - 23 Jun 2009 7:59 AM - 4 messages
I need to get a good understanding of SQL performance. I have software that shows things like waits, latency, buffer, cache etc etc but I'm not overly confident on understanding what I'm reading..... If the scale is up near the top is that good or bad? for example. ...
Score Identifying Memory Pressures
Heath - 22 Jun 2009 3:03 PM - 4 messages
I’m trying to develop a couple of scripts to identify your instance is under memory pressure.   I’ve identified the following two scripts. I’m wondering if these two scripts do in fact identify memory pressure?  ...
Score logshipping on 2000
tulip - 17 Jun 2009 2:23 PM - 12 messages
we used logshipping between primary servers and secondary server, the distance is more than 1000 miles, the copy job need to copy a 60G files each week, is there anyway to fast the process? thanks ...
Score kill the long run job automatically
sarah - 23 Jun 2009 1:51 PM - 7 messages
Hi, I have a job running every day which does insert and update one of the huge table. It will be fine (takes about 4 minutes each time to complete) for a couple of months and then all of sudden it runs for hours and blocking the ...
Score Sql transaction log size because of reindexing
db - 22 Jun 2009 3:33 PM - 13 messages
SQL server 2000 SP4 I have a database (size 13 GB) in full recovery mode. We take transaction log backups once everyday in late evening. Everynight I update the statistics and only on the weekend I do a complete reindexing. ...
Score User login date
Alan T - 22 Jun 2009 1:22 AM - 11 messages
Anyone has detail steps how to setup SQl 2005 to capture the users login date? ...
Score Database documentor
NeilShore - 12 Jun 2009 2:19 PM - 10 messages
Hi, I'm new to SQL Server.  I've been using Access for a number of years.  I'm having trouble figuring out how to document the database I've created in SQL Server.  Is there nothing, in SQL Server, like the "Database Documenter" in ...
Score Sql Server Shared Hosting
Sabotage - 17 Jun 2009 7:58 PM - 5 messages
Hello, I'm looking for a cheap Sql Server 2005/2008 shared hosting provider. My software requires hosted MSSQL database to access remote MySql database hosted on the other server. On my local machine I've done this by creating a ...
Score Jobs cannot running
m_amin33 - 21 Jun 2009 2:07 PM - 5 messages
Hi All, SQL 2005 SP3 I have an issue concerning the server security, I do not need any windows authentication (I know that is not recommended). Anyhow, SQL server agent does not run any jobs that defined on that server ...
Score c2 files/sysxmitqueue
guest5 - 19 Jun 2009 3:19 PM - 4 messages
Hi I have an issue at the moment where large no of c2 audit trace files are being generated for audit event 114. At the same time msdb is being rapidly filled by sysxmitqueue. I am unsure whats changed as this server has not had this issue presviously. ...
Score change date from Mon dd yyyy
DONNA - 19 Jun 2009 3:28 PM - 13 messages
How do I change a varchar field that is in the format Mon dd yyyy 12:00am to MM/DD/YYYY? Thanks for any help... ...
Score SQL Server 2005 database monitoring
jfalberg - 18 Jun 2009 8:51 PM - 5 messages
We have the need to monitor and determine the amount of data being writing to a SQL Server 2005 database on a daily basis. Maybe hourly … Can somebody help me determine the best method to track this? ...
Score Reseeding identity field
tshad - 17 Jun 2009 12:30 AM - 11 messages
I am trying to reseed the identity field in my program. My largest ID is 205001 and it is using 351223 I want it to go back to 205002 (use the Highest value in the Identity field which is what the docs say) but it still stays at 351223. ...
Score Run 32-bit and 64-bit instances on same machine
John - 17 Jun 2009 12:41 PM - 12 messages
Is it possible to run 32-bit and 64-bit instances of sql server 2008 on the same windows server 2008 instance? I searched and found this slide presentation that mentions that it is *not* possible under sql 2005: [link] ...
Score HELP, RAN OUT OF DISK SPACE
Rockitman - 18 Jun 2009 3:57 PM - 10 messages
SQL2000,   one of my databases is not currently under a maintenance plan and this morning,  I've come to find out my D: drive is out of disk space!!! Looking at D:\Miscrosoft SQL Server\MSSQL\Data directory I see the file ...
Score SQL Server 2008 / 2005 / 2000 / 7 / 6.5 largest possible database?
Rajoo Sharma - 16 Jun 2009 6:37 PM - 11 messages
Does someone know what is the largest possible database with the following relational database systems: Sql server 6.5 Sql server 7 Sql server 2000 Sql server 2005 Sql server 2008 [link] ...
Score SQL 2008 not starting
Robin9876 - 18 Jun 2009 4:13 PM - 3 messages
On a SQL 2008 (SP1) an instance is not starting up. Below is the relevant lines form the errorlog when the first error is mentioned. I have tried copying the model database files from another SQL server at the same build level but the error still occurs. ...
Score How to narrow down the failure message
JamesWilliams - 17 Jun 2009 6:05 PM - 8 messages
I have a nightly job which copies the entire contents from a Progress (kinda like Oracle) database to a SQL Server 2005 one. Specifically, I look under SQL Server agent in the tree on the left of SSMS, and open it up and expand ...

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