Home All Groups Group Topic Archive Search About



Microsoft SQL Server Administration

microsoft.public.sqlserver.server
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 Restore Database
gbkhor - 10 Jul 2009 1:47 AM - 3 messages
Hi I running SQL2K SP4 at Win2003 OS I have one database backup file backup.bak having database file abc.mdf 60GB and Transaction log abc.log 1GB file Question: I wish to restore the backup into other serverB, but serverB doesn't have ...
Score syntax question
Gerhard - 9 Jul 2009 7:48 PM - 2 messages
I don't know if what I want to do is possible (other than building a whole sql string and then executing that), but thought I would at least ask as it would be very useful. What I am trying to do is something like this: ...
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 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 Principal 64-bit and Mirror 32-bit?
kunalap - 9 Jul 2009 5:17 AM - 3 messages
If I set a database to mirror from 64bit SQL server 2005 machine (principal) to a 32-bit SQL server 2005 machine (mirror), will it work? Whether the original application running on 64-bit machine will be able to connect to the 32-bit standby server when needed is a different story. But I ...
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 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 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 "Empty" rows
fred - 8 Jul 2009 6:33 PM - 2 messages
We have a table that appears to contain a large amount of empty rows. The structure of the table is there (column names, etc) but no data. Is there anyway we can confirm that these rows are empty - I have tried ...
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 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 2008 OEM
Stefano - 8 Jul 2009 9:43 AM - 2 messages
Hi, i've a question , HP and DELL sell a version on SQL 2008 as OEM. The question is: If i buy a server with this version and install hyper-v , I can install the SQL oem to the virtual machine and not to the HOST? I'ts legal? ...
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 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 3rd Party Tool
Peter - 8 Jul 2009 1:30 AM - 6 messages
Hi, I need to examin three databases and each database has over 200 tables on SQL Server 2000, I need to see all the primary key, index, contraints, FK and relationship to other tables. Most importantly making sure tables are ...
Score knowing which columns have NULL
soni2926 - 7 Jul 2009 8:21 PM - 2 messages
Hi, I have the following an Apps table which has the following columns: AppsID (int, not null) --> primary key Acronym (varchar(100), null) Description (text, null) UsersCnt (int, null) UserDescription (varchar(250), null) what I need to do is locate all the rows that have NULL value in any ...
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 What Scope Do Instance Names have? Forgot to mention they'reamong clusters
Robert Hindla - 7 Jul 2009 4:12 PM - 2 messages
What I meant to say was: I'm kind of planning to transfer databases from server1\instance1  (on cluster-a) to server2\intance1 (on cluster-b) by detaching them from server1\instance1 and copying to server2\instance2?  Or maybe backing them ...
Score What scope do Instance names have? How unique do I need to makethem?
Robert Hindla - 7 Jul 2009 4:08 PM - 2 messages
I'm kind of planning to transfer databases from server1\instance1 to server2\intance1 by detaching them from server1\instance1 and copying to server2\instance2?  Or maybe backing them up to server2\instance from server1\instance1. Will the fact the instance name (which I would very much like to leave ...
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 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 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 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 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 Web site migration - determining which sites "communicate" with SQL
Spin - 6 Jul 2009 5:28 PM - 3 messages
Gurus, Running Windows 2000 with IIS 5.0 and Windows 2003 with IIS 6.0 and on another server as a back-end, SQL Server 2005 SP2.   On the two IIS servers, they are serving up about 100 web sites between them.  How would I know, ...
Score SQL Dump
Ganesh - 6 Jul 2009 4:42 PM - 2 messages
Message SQL Server Assertion: File: <tmpilb.cpp>, line=1306 Failed Assertion = 'NULL == m_pTaskMain || SOS_Task::GetCurrent() == m_pTaskMain'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server ...
Score SQL logins in 2005
Emmanual via SQLMonster.com - 6 Jul 2009 3:35 PM - 3 messages
When creating a new SQL Login with CHECK POLICY ON - I am unable to use the sql login to connect to database. I am getting an error : Property ISlocked is not avaliable for login [sqltest]. This property may not exist for this object, or may not be retrievable due to insufficient access ...
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 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 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 Last cumulative update for sql 2005 service pack 3
INPUTIO - 6 Jul 2009 1:15 PM - 3 messages
Which is? Thansk 1K. ...
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 Multiple insert into base - sql side
imarkic84 - 5 Jul 2009 8:16 PM - 2 messages
I have checkboxes having values. Depending upon the selection of checkboxes, i need to insert multiple rows in the database. rows can be 10, 1000, 2000 any number. Selectiong on the checkbox and click submit will insert row in the ...
Next » 2 3 4 5 6 7 8 9 10