Home All Groups Group Topic Archive Search About



Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score FileStream and sql 2008 edition
Gal - 6 Dec 2008 9:13 PM - 2 messages
In what edition of sql2008 is the filestream option available? ...
Score Error during login to SQL Server 2005
Jennifer Tan - 6 Dec 2008 8:05 AM - 3 messages
Hi All, After I had successfully installed SQL Server 2005 Standard Edition on Vista Home Premium Edition on my laptop and when I tried to connect to the Server (Database Engine), it give me an error msg saying 'Login failed for user. ...
Score Backup and Restore Problem
Tony Starr - 6 Dec 2008 4:36 AM - 5 messages
I need some help. Today, every time I try and resore a database I get the following message. System.Data.SqlClient.SqlError: The tail of the log for the database "XelonReleases" has not been backed up. Use BACKUP LOG WITH NORECOVERY to ...
Score Maintenance plan using execute T_SQL statement task
Maria Bravo - 5 Dec 2008 9:31 PM - 2 messages
I am trying to create a maintenance plan which includes a SQL statement. I run the statement in a query, and it runs ok, no errors; but when I put the same SQL sentence in the maintenance plan it gave me an error: ...
Score System Ticks
tobiwan_kenobi - 5 Dec 2008 9:02 PM - 2 messages
We are experiencing problems with dates as our servers are time-synched. We would like to put a tick count in the record that corresponds to the number of ticks since the system started.  This would be similar to the .NET ...
Score Alter Index Default Parameters
Joe K. - 5 Dec 2008 6:47 PM - 2 messages
I have a SQL Server 2005 database that I created Index Rebuild Job from the SSMS Maintenace Plan. The job aborts on the first index rebuild.  I was able to rebuild several indexes manually with the statement listed below. ...
Score JOIN based on date
morphius - 5 Dec 2008 5:02 PM - 8 messages
How do you get rid of the time so that the JOIN statement below will work. Table1.date 1/1/2008 22:00:00 Table2.date 1/1/2008 00:00:00 SQL statement: SELECT tb1.name, tb2.salary, tb1.date ...
Score Using Alias with Failover
deconinckg - 5 Dec 2008 2:49 PM - 3 messages
In the following article Microsoft refers we can use a T-SQL script on a job after failover, to change the alias. [link] I didn't find out how to run a job after failover yet, but I'm more ...
Score There is insufficient system memory to run this query - server reboot
Scott - 5 Dec 2008 11:41 AM - 2 messages
Hi, I managed to crash the active node of an sql server cluster running a select/join query on a table with millions of records. The server app log reported: 05/12/2008   There is insufficient system memory to run this query. ...
Score Database sometimes not accesable in SQL Server 2005 Express
Ronald Hoek - 5 Dec 2008 10:05 AM - 2 messages
Hello, We're running a SQL Server 2005 Express edition on a 2-CPU server. From an other server, we are accessing a Database on the SQL-server using SQL-authentication. This normally works, but sometimes (10 - 20 times a day) ...
Score What can cause SQL 2000 to stop responding for a while
JN - 5 Dec 2008 3:05 AM - 4 messages
I have a SQL Server 2000 that has a couple of databases on it.  One is couple of gig with about 30 tables and another is about 60 gig with about a dozen tables but almost all of it is in 3 tables. ...
Score replicate image of DB at a remote site
fiaola - 5 Dec 2008 1:43 AM - 6 messages
Hello, I'm searching for information on replicating DB for disater recovery.  I read online that some people do not recommed the SQL Server replication procedure.  Can you recommend a software or a good way to replicate DB to ...
Score SQL Server 7 encryption
kskatherinesimpson - 5 Dec 2008 12:29 AM - 2 messages
Is it possible to encrypt a database table column in SQL Server 7? Thanks........ ...
Score Is it possible to associate sql login with network address?
George Wen - 4 Dec 2008 11:31 PM - 4 messages
I was looking into a way to associate sql login with network address, e.g. user 'sa' will only be able to login from localhost or a particular ip range, does anyone know whether it is possible? I know that mysql does this pretty well. ...
Score SQL Server 2005 Script Out User Permission Prod-> Dev
Tim Peterson - 4 Dec 2008 10:57 PM - 4 messages
I have a SQL Server 2005 production database that has approximately 75 users. I would like to restore the SQL Server 2005 production database into my development database. What the best way to script out the development users permissions to be ...
Score Website Link SQL Server Versions (Including HotFixes)
Joe K. - 4 Dec 2008 10:41 PM - 3 messages
I cannot remember the website link that has listed all of the compiled versions of SQL Server with a description. Please help me with this task. Thanks, ...
Score FT Index - Avoid Noise Words
dbenoit - 4 Dec 2008 5:42 PM - 3 messages
We have a Full Text index which works great but we have some data which doesn't play well with the Noise Words and I am wondering if there is a way that I can avoid the use of the Noise Words for a specific query without ...
Score strong password in SQL Server 2000
BillE - 4 Dec 2008 5:33 PM - 3 messages
Is there a way to require strong passwords for SQL Server (not Windows) accounts in SQL Server 2000? Other than writing a process to evaluate the password when it is changed, that is. Thanks Bill ...
Score how to ignore error....
ayrhead - 4 Dec 2008 5:17 PM - 3 messages
I have a database in which the foreign keys have been disabled (alter table x nocheck constraint y).  I know that some of the foreign keys will fail when trying to enable and I can address this later.  I create a cursor for all ...
Score Disaster Recovery Options
Bryan - 4 Dec 2008 4:50 PM - 5 messages
I am looking for general ideas to explore based on the following requirement: We want to be able to backup a database or database files (off site or to tape) that is currently the recipient of Log Shipping without disrupting the ...
Score Defrag SQL Server Files
Prem Mehrotra - 4 Dec 2008 4:34 PM - 3 messages
I am still on SQL Server 2000 on Windows 2000. I noted that there are several files database and transaction log, which are fragmented as per Disk Fragmenter utility provided by Microsoft. If I shutdown SQL Server and run disk fragmented to reduce fragmentation, ...
Score Problem in sysdatabases
Simon - 4 Dec 2008 3:45 PM - 4 messages
I get the following error message when I try and loop through all databases to perform a query using sp_MSforeachdb. 'Could not locate entry in sysdatabases for database 'OrtusSearch'. No entry found with that name. Make sure that the name is entered correctly.' ...
Score recovery mode help ?
David - 4 Dec 2008 9:05 AM - 4 messages
I have a 2005 Standard A/P cluster running a 100Gb db. I was connected via a query window running a select query and a transportation level error occured .... suggesting the connection had dropped. I examined the cluster and found ...
Score SQL Server 2005 64-bit Total Server Memory(KB)
Igor Marchenko - 4 Dec 2008 5:17 AM - 3 messages
Hello!   We have just configured SQL Server 2005 64-bit two node active/passive cluster with 32 GB of RAM. I have limited SQL Server memory usage to 26 GB. Total Server Memory (KB) shows value 16MB at the moment. Target Server Memory ...
Score SQL Server 2005 Rebuild Error: 8152
Joe K. - 4 Dec 2008 2:06 AM - 2 messages
I have a SQL Server 2005 database that I have created a maintenance job (SSMS) to rebuild the indexes.  When I run the job I received the error listed below. The job aborted on rebuilding the first index in the database.  I tried to ...
Score Cursor Help
anaylor01 - 4 Dec 2008 12:52 AM - 6 messages
I have a one column table. The data in that column has 1142 characters. It is fixed delimited data. To make it more dynamic for parsing the data I have created a table that has the fieldname, fieldlength and field size. I want to ...
Score Forgot to detach?
MikeR - 4 Dec 2008 12:17 AM - 3 messages
I wanted to copy a database from one SQL Server 2005 to another. I shutdown the application that used the database, and stopped the SQL services. Copied the .MDF and .LDF files to the new server and attached the database. ...
Score SQL server 2000 and Access project
jmillerWV - 3 Dec 2008 10:56 PM - 3 messages
I hope I am posting to the correct area if not please let me know.  I am preparing to upsize my Access DB to SQL server 2000 (Small Business Server 2k3). I have many Queries in Access that use data from forms as parameters. ...
Score Can a trigger be inadvertantly disabled?
JoelB - 3 Dec 2008 9:20 PM - 10 messages
A customer reported some odd behavior, and it turned out to be because a trigger was disabled.  Access to the SQL Server is quite limited, and it seems very unlikely that anyone intentionally disabled this trigger. Is there any way---like if the system has a problem with the trigger or ...
Score DBCC Checkdb's torn page / checksum validation
abair34 - 3 Dec 2008 8:14 PM - 3 messages
If you have a database who's page verify option is set to none does performing a DBCC CHECKDB actually do any page verification?  My intuition says that it cannot because the pages that were stored would have been stored ...
Score Convert SQL Express to SQL Server
rsnooks - 3 Dec 2008 3:15 PM - 3 messages
Hi, Is it possible to convert a SQL Express database to work with SQL Server? We are currently on a deadline to get ePO working, but are being held up by unavailable funds to secure an SQL Server... so we are thinking maybe if it ...
Score SQL SErver 64 bit use of memory
Joe - 3 Dec 2008 2:54 PM - 5 messages
Hello, Server 2003 EE sp 2 64 bit 8 gb of RAM SQL Server STD edition sp 2 64 bit  6144 max server memory.  AWE is set.  Lock pages in memory is set.  SQL has not been stopped/started  ...
Score The time stamp counter of CPU on scheduler id X is not synchronized with other CPUs
Paul Cahill - 3 Dec 2008 12:34 PM - 3 messages
We are shortly going to go live with our new (and 1st) 64 bit server. I have just noticed the above errors in the Application Log. The system is an HP DL580G5 with 4 x 6 core Xeon x7460 Cpus. It is running ...
Score Error logs enormous. Can I delete or save elsewhere?
Roger Withnell - 3 Dec 2008 11:10 AM - 10 messages
I am referring to the 6 error logs in: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. The total size is over 6gb and growing because of invalid logins from hackers.  This is filling up my small C drive. ...
Score MS Access, ODBC, SQL 2005, delays before data appears
Gijs - 3 Dec 2008 8:30 AM - 6 messages
Hi all, We are using MS Access as a front end, SQL Server 2005 as the backend. Tables are linked using ODBC (they are attached using code). the cursorlocation is adUseClient. We do not seem to have any problems but occaisionally we seem to 'miss' ...
Score Script to delete records from a table older than N number of days.
Fuel451 - 3 Dec 2008 4:51 AM - 9 messages
I have a table within a SQL 2005 database that fills up after about three months and I'd like to schedule a daily job to delete rows or records older than 60 or 90 days. Could someone provide the syntax for a DELETE script? ...
Score how to store decimals in tables
fiaola - 3 Dec 2008 4:20 AM - 8 messages
I have a table with a field called weight, which i have it as a decimal(18,2) data type.  When i tried to store a value like 9.97, the actual data stored in the table is rounded off to 10.  How do i fix this? ...
Score Hebrew + Arabic collation
Gal - 3 Dec 2008 12:38 AM - 3 messages
I have a field that is 95% hebrew and 5% arabic. The table is  10,000,000 recs, so for storage purpose I prefer not to use unicode. Is there a collation that contains both? ...
Score Security Question
Eric - 3 Dec 2008 12:29 AM - 8 messages
Hi All, If I want to enable a user to extract up to 200 rows per a request, how that can be done? Is it possible to control? Thanks, Eric ...
Score in full recovery mode but log keeps self-truncating
JRStern - 2 Dec 2008 10:21 PM - 10 messages
We have a dev database we keep in simple recovery mode.  We restored a fresh copy of the database from production, and it was set down to simple mode.  The log file was only 500kb.  We set it up to full recovery mode.  We're ...
Score Cumulative package 2 for SQL 2008
dwu - 2 Dec 2008 9:31 PM - 4 messages
Did anyone download Cumulative package 2 for SQL 2008? How many files you see after extracting the compressed file. Currently i only see two files--sqlncli.msi and hotfix.txt. It looks like MS missing the hotfix.exe in the package. Could someone confirm what i see? ...
Score How to do bulk update in SQL Server 2005.
Chen - 2 Dec 2008 8:07 PM - 2 messages
Hi all, Let’s say I have a series of updates, each one having a where clause that matches exactly one row. However, if you think about the updates as a group, they form a single logical operation. Is there some way to do a “bulk update” that makes this operation more ...
Score Server Disk Space
John Bigbooty - 2 Dec 2008 8:00 PM - 9 messages
Is there a reliable way to get the amount of disk space available on a computer running SQL Server? xp_fixeddrives was a start but since it is undocumented and doesn't appear to work with a remote 2005 server, it isn't a complete ...
Score Maintenence Cleanup Task does not delete backup files
mat - 2 Dec 2008 7:42 PM - 3 messages
I'm testing a new Mainentence Cleanup Task that runs inside the same subprocess as the backup task. I have it set up to delete .bak files in the backup dir that are older than 1 hour (for testing). When I run the ...
Score 32 vs 64 bit SQL Server hotfixes
jessehogan00 - 2 Dec 2008 6:30 PM - 4 messages
Hello,     We have a scenario where we have SQL Server 2005 Express 32 bit installed on a 64 bit Vista computer. When applying SQL Server hotfixes (such as this one: [link]) ...
Score Certificated, Keys etc
JB - 2 Dec 2008 3:16 PM - 2 messages
I know that certificates and keys are being used on my SQL Server. What is the minimum that I need to back up if I want to transfer a database to another server and still have the same encryption / decryption in place? ...
Score Log Shipping
JB - 2 Dec 2008 3:14 PM - 3 messages
Under what circumstances will a full database backup cause log shipping to fail? I know I have seen this occur, and suspect it is when the log backup and full backup overlap? Thanks. ...
Score Max server memory being ignored
Jason - 2 Dec 2008 2:16 PM - 10 messages
Our SQL Server 2005 database appears to be ignoring the max server memory setting. The server has 16 GB of memory, and we set the max server memory at 14 GB. Ops Manager keeps warning of low memory and task manager shows all memory being used. This is a deticated 64-bit ...
Score Reading Data from the Restoring Database In SQL Server 2005 Enterprise Edition
Microsoft Newsgroup - 2 Dec 2008 11:07 AM - 2 messages
Hi All, I am using SQL Server 2005 Enterprise Edition. I have restore my database with the NORECOVERY option. Hence my database is in the RESTORING mode. Is there any possibility of reading the data from this database (Restoring), without converting this database to FULL RECOVERY MODE using the below SQL ...
Score Consolidate datafiles to one drive
Abba - 2 Dec 2008 8:04 AM - 6 messages
Hello, My database has 10 datafiles spread across 10 drives. We designed it a year back anticipating heavy traffic but it didn't turn out that way. Now, I need to give all those extra SAN space back and so need to put 9 datafiles to a ...
Score Taking database offline taking long time
Ron - 1 Dec 2008 10:40 PM - 3 messages
I have a database with a very large transaction log (20 GB).  My plan is to move the log to a different drive with more space.  I issued Alter Database <dbname> SET OFFLINE and it has taken 7 hours so far and is still executing.  ...
Score SQL 2k5-32bit >SQL 2k5-64bit
John Holt - 1 Dec 2008 9:49 PM - 5 messages
Many times I have installed SQL to a new server, shutdown the service and copied over the entire MSSQL\Data folder, master,msdb and all, start the server and bam!, just sp_dropserver and sp_addserver and change the servername in the jobs table and everything is on the new server without a ...
Score Re-attaching database
topokin - 1 Dec 2008 7:57 PM - 13 messages
A database was generating some problems because of disk place, so I detached it and move the files to another location. However when trying to re-attached the database, I receive an error message: Error 3624 : 1450 Transactions rolled forward in Database <xxx> ...
Score Re: Odd Identity Behavior in Enterprise Manager
Joe - 1 Dec 2008 7:06 PM - 2 messages
It looks like the problem emanates from the Insert trigger.  I just created a new table, Test, CREATE TABLE [dbo].[TEST] (     [TestID] [int] IDENTITY (1, 1) NOT NULL ,     [Test] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ...
Score Query File Growth Properties
John Bigbooty - 1 Dec 2008 4:49 PM - 2 messages
Is the a stored procedure or SQL statements to query to the file growth properties for a database? Mark Atlanta GA ...
Score Bug or Bad Practice on my part?
MikeWalsh - 1 Dec 2008 4:20 PM - 2 messages
I have created a Database Role for database developers in order to not give DBO permissions per requirements for the project. I then added the developers to said role and granted the role database level permissions such as "EXECUTE WITH GRANT OPTION" (granted more ...
Score sql server profiler: what does this combination of completed batches mean
HDI - 1 Dec 2008 1:46 PM - 4 messages
Hi, On my sql server profiler trace I have multiple of following combinations:   Sql:BatchCompleted : set implicit_transactions on   Sql:BatchCompleted : if @@trancount > 0 commit tran   Sql:BatchCompleted : set implicit_transactions off It looks like it is wating for something. Does anyone know what this ...
Score SQL GROUP BY CLAUSE
keyur joshi - 1 Dec 2008 9:26 AM - 4 messages
hi i have made a view and its out put will be the following InvDt           ItmNm           Qty              Mrp ...
Score Alter Index On Database Rebuild (SQL Server 2005)
Joe K. - 30 Nov 2008 6:17 PM - 6 messages
I have a SQL Server 2005 database that I am trying to rebuild the indexes. I used the ALTER INDEX ON TABLE_NAME REBUILD on each table. After completing this task I ran the DBCC SHOWCONTIG on each table. I noticed the logical scan fragmentation is set between 25 - 80. ...
Score Concentrate on SQL 2008 or their Cloud services?
serge - 30 Nov 2008 6:37 AM - 2 messages
We have a senior developer pushing hard about this new Cloud services from Amazon and Microsoft. Are there any good articles explaining clearly the pros and cons? I plan on pushing for SQL 2008 but I'd like to find out what the ...
Score SQL Server 2005 Alter Index All On DB Rebuild
Joe K. - 30 Nov 2008 4:25 AM - 3 messages
I am trying to use the Alter Index statment listed below and received the error listed below. ALTER INDEX ALL ON AdventureWorks REBUILD Error: Cannot find the object "AdventureWorks", because it does not exist or you do not have permissions. ...
Next » 2 3 4 5 6 7 8 9 10