Home All Groups Group Topic Archive Search About



Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Database queries via Synonyms
Nully Girl - 13 Jun 2009 2:19 PM - 2 messages
Database queries vis Synonyms, is there any pitfalls to be aware of? Performance issues? relational integrities issues? any other things regarding this? By the way I am using sql server 2008 [link] ...
Score Earliest SQL Version for a given feature...
James Hunter Ross - 12 Jun 2009 9:33 PM - 6 messages
Friends, I'm (almost) embarrassed to admit that I have never solved this.  My general question: do you folks have a nice to find out which is the "earliest" SQL Server version to support a feature? I'm a developer, and currently use SQL Server 2008.  I was planning to ...
Score SQL SERVER 2K8 and 2K5 and 2K Differences with respect to CHAR typ
Stephen - 12 Jun 2009 7:36 PM - 3 messages
In the environments that we have (2000, 2005 and 2008) ANSI_PADDING appears is ON.  Though there is a difference of functionality with respect to the replace string command. (Which may be due to changes ANSI_PADDING logic).  SQL Server 2000 & SQL Server 2005 appear to work the same.  SQL Server 2008 ...
Score query/join issue
Krzysztof via SQLMonster.com - 12 Jun 2009 6:36 PM - 5 messages
Good Afternoon!! I must really be brain dead today.  i am trying to do a query with a left join because i need to record some null values. only two tables are used for this query, and it is basically this:  my first ...
Score Upgrade is stuck
David C - 12 Jun 2009 3:08 PM - 3 messages
I am upgrading my XP Pro machine from 2005 Developer to 2008 Developer and it is stuck on the last section at "Installing native images".  It has not moved for a long time and is stuck. is there anything I can do?  Thanks. ...
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 Converting Access 2007 to sql server 2008
MaxCar - 12 Jun 2009 12:03 PM - 5 messages
When doing this from sql server2008 my unique identifiers in access loses the uniqe part when converted to sql. They are only INT. Also when I try to change the uniquq identifier to yes and saving i get a message that this isnt ...
Score newsletter regarding service packs/update rollups/hotfixes availab
Fritz Theiss - 12 Jun 2009 10:44 AM - 2 messages
hi, is there any newsletter regarding latest service packs/update rollups/hotfixes available in order to be informed regurlarly by microsoft? if yes, where can one subscribe? ...
Score SQL response query
Joe - 11 Jun 2009 9:58 PM - 2 messages
Hello, Have the opportunity to query all datbase servers via an agent to determine if database server is responsive.  Looking for suggestions on the query to run.  Must cross 2000, 2005, and 2008, although minor changes between version ...
Score memory distribution
Heath - 11 Jun 2009 6:52 PM - 2 messages
When I run these two commands:  -- Summorized select      sum(pages_allocated_count) Page_Count     ,SUM (pages_allocated_count *      CAST(page_size_in_bytes AS FLOAT)) / 1024.0 / 1024.0 /1024.0 GBytes_Used from sys.dm_os_memory_objects -- Counters ...
Score SQL 2008 not starting due to msdb cannot be opened
Robin9876 - 11 Jun 2009 3:54 PM - 6 messages
On a SQL 2008 server when trying to connect to the database it shows the following error message and no databases are listed. There was a disk failure on the drive were the database is located before this issue occurred. ...
Score Inserting Updating and Deleting large numbers of records
Tim Marsden - 11 Jun 2009 2:47 PM - 4 messages
Hi, Imagine I have a grid 1000 rows x 30 columns. The rows represent Products, the columns Dates.  Order amounts are placed in the corresponding cells of the grid. I want to update a SQL Table with all combinations of Product / ...
Score Collation change of Master- model- msdb database
JamesATaber - 11 Jun 2009 2:15 PM - 4 messages
Someone know how I can do this, without getting in to a lot of unnecessary trouble? All help is greatly appreciated :) ...
Score Get the Count function to return zero instead of nothing at all?
gocat2005 - 11 Jun 2009 11:58 AM - 7 messages
If no rows match the criteria, I want the Count function to return a zero instead of nothing at all. How do I do that? Eg: this query returns nothing at all because nobody has a lastname of 'xxx'. I want it to return a count of ...
Score Where is the Reliability and Performance Tool ?
wpher56 - 11 Jun 2009 11:33 AM - 3 messages
Hello all I installed SQL Server 2008 on a clustered environment. I selected all available options. Now I'm looking for the Reliability and Performance Tool , but in the Performance Tools menu, I only find Database Engine Tuning Advisor and SQL Server Profiler. ...
Score How to Set Read-Only Permissions on All Objects in a Schema
Charles - 11 Jun 2009 11:19 AM - 10 messages
I'm creating a login and user, and I want to be able to grant read-only (e.g. SELECT) access to the dbo schema objects only. I think I can do this from the Securables window and selecting each one in turn, but I really hope ...
Score Table design for optimal performance ?
mark4asp - 11 Jun 2009 11:14 AM - 4 messages
Is this bad design? I have this table which is associating a LoginID with an AssetID. There are upto 4000 entries in Member_Login table and 40 in the AssetClass table, giving upto 160000 rows in LoginAsset. These are the important schema details: ...
Score TLog management in DB Mirroring
Abba - 11 Jun 2009 8:38 AM - 5 messages
Hello, Iam doing an analysis of DB Mirroring for our new SQL2008 servers. My understanding is that there would not be any transfer of Tlogs from Principal to Mirrored server. The individual T-Log records are transferred using TCP endpoints. That way I do not have to worry about purging/deleting ...
Score High availability architecure
JamesATaber - 11 Jun 2009 7:25 AM - 5 messages
Hi we a developing av solution for a customer where high availability is very important for our customer. Does someone here have any good resources of pointers to share? ...
Score security in SQL 2008 after moving to a domain?
Zoran - 11 Jun 2009 3:11 AM - 8 messages
Hello All! I moved an windows server 2008 SP2 with SQL 2008 sp1 installed from workgroup to a domain, and afterwards I couldn't start SSMS being logged on using a domain admin account. I logged on as local admin and added domain admins as a login, and now I can ...
Score sp_MSget_repl_commands (Distribution agent constantly running and locking)
Query Builder - 10 Jun 2009 8:26 PM - 5 messages
I have a SQL2000 SP4 Enterprise Edition SQL Server running Transactional Replication. I haven't had any issues till today where all of those replication Distributions are doing a select from the Distribution database. When I ran DBCC INPUTBUFFER (<SPID>) I get the ...
Score SQL agent starts/stops when using domain admin rights
David Butterfield - 10 Jun 2009 5:58 PM - 3 messages
When attempting to start the sqlserveragent using a domain admin account the service will start/stop instantly and then we get the message: SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start). when I used the local admin account the service started without any problems. ...
Score Populating an IDentity and and timestamp field?
Thomas Malia - 10 Jun 2009 5:23 PM - 4 messages
I'm looking to archieve some old data in some tables that contain identity and timestamp fields.  Ideally, I'd like the archived records to be "exactly" the same as the records from the live table at the time they are ...
Score "Setting database option COMPATIBILITY_LEVEL to 100 for database R
Kelly - 10 Jun 2009 5:13 PM - 2 messages
On a Windows Server 2008 SP1 with SQL Server 2008 server about every 5 seconds I get the following 2 messages in the Application Event log: "Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer." and "Setting database option COMPATIBILITY_LEVEL to 100 for database ...
Score Migrating bound defaults to column defaults?
John Hardin - 10 Jun 2009 5:07 PM - 2 messages
All: MSFT has deprecated bound defaults (CREATE DEFAULT and sp_bindefault) for several releases now (and a good thing, too, as they are a pain to work with). Unfortunately, they do still exist in production databases. Does anyone know of a tool (either pure T-SQL or DMO) that will enumerate ...
Score Transfer Data in Code
Paco - 10 Jun 2009 5:01 PM - 4 messages
I am writing a routine to transfer data from an SQL database to an Access MDB database. The code loops through the tables in the SQL database and inserts the data in corresponding tables in the Access database. That's simple ...
Score Can we implement resource limitation for specific SQL2005 database
eric - 10 Jun 2009 4:11 PM - 5 messages
Hi All,    Is there a way to limit how much disk, memory, and/or CPU resource a specific database can use in a SQL2005 server?  I have about 10 database on this one SQL2005 server.  They are all about 1 to 5 GB each.  However, one of ...
Score SQl database list quetion
frank - 10 Jun 2009 3:57 PM - 5 messages
When you launch the sql management tool it gives you a list of databses  is there any way to export that list onto excel sheet (alos if posible any oother properties like size and if online or offline) FYI: we use multi sql 2005 servers and databses ...
Score Creating a table on a particular filegroup?
Thomas Malia - 10 Jun 2009 2:34 PM - 12 messages
I'm trying to create table on specific file groups, but it doesn't seem to be working.  I'll paste the test scripts I'm running below.  When I run these, it still reports my tables as being on the PRIMARY file group even ...
Score FlatFile Encryption using FILESTREAM
thejamie - 10 Jun 2009 12:32 PM - 6 messages
I have a legacy database composed of distributed flat files that require an encryption algorithm (GUI) to be read.  The data is sensitive and available publically via the application which, when requrested by the user, is parsed using the algorithm.  When the files are updated, they are rehashed using an ...
Score How best to identify application usage pattern
nzrdb6 - 10 Jun 2009 11:43 AM - 2 messages
I need to produce a report which details the pattern of application use throughout the day so we know when the peaks and troughs are. Which Performance counters best show this? ...
Score To UDF or not to UDF
teddysnips - 10 Jun 2009 8:55 AM - 10 messages
Our new clients have a mature database but a new requirement to obtain some summary data.  Frankly, I don't think it's terribly well designed, but we're stuck with it. They want us to script a collection of views, and we've done the first ...
Score Updation of data in Active/Active cluster
Abba - 10 Jun 2009 6:56 AM - 14 messages
Hello, Iam familiar with Active/Passive failover where you have only one instance of database and one active node at a time. So no confusion about fail-over. However, now I am facing a situation with a A/A cluster. This is my ...
Score Get permission error after mdb move.
Brian Smither - 10 Jun 2009 4:40 AM - 3 messages
Using this MSDN page: [link](SQL.90).aspx I went through moving two databases, AdventureWorks and another one, both located on drive C: and attached to an instance of SQL Server 2005 ...
Score RE: SERVERPROPERTY via ODBC
Linchi Shea - 10 Jun 2009 1:29 AM - 2 messages
This should not have anything to do with the database access driver. It just passes back whatever the server sends back. But then the return data type of serverproperty() is sql_variant. Maybe, the driver barfed on that. Did you give @@servername a try? ...
Score Syntax Error near select.
Mike Coleman - 10 Jun 2009 1:14 AM - 4 messages
For the life of me I can't figure out why I have this error. here is my Stored Procedure. USE [KraftInStoreAgenda] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: mc -- Create date: 09 Jun 2009 -- Description: Allows a user to push an Agenda, AgendaActivities, and ...
Score Q: 64 bit Server Upgrade
JIM.H. - 10 Jun 2009 12:02 AM - 3 messages
64 bit Server Upgrade We are using a windows application that has SQL Server 2005 backend. Application is accessing database over ODBC and/or Native SQL Server connection. We are planning to upgrade database server from Windows Server 2003 standard / SQL Server 2005 standard to Windows Enterprise 64 bit / SQL ...
Score Costs savings for an existing SQL Server installation
Ian Allchin - 9 Jun 2009 5:18 PM - 4 messages
My boss has asked me come up with cost saving ideas for our existing SQL Server installation (2000, 2005, 2008). I am already considering: •    Licensing •    Server Consolidation •    Standardisation ...
Score Moving SQL 2000 Database to SQL 2005
Smurfman - 9 Jun 2009 4:16 PM - 6 messages
I have a 51gb database on an older server that is being replaced.  The database is SQL 2000. I want to move the data to a new SQL 2005 Server. Originally, I was thinnking if I created a backup on the 2000 box, and then ...
Score SQL Server and Memory in the server
JIM.H. - 9 Jun 2009 3:42 PM - 2 messages
SQL Server and Memory in the server Can I install SQL Server 2008 Standard on Windows Server 2008 Enterprise or Data Center and reserve around 32GB memory for SQL Server? ...
Score Newbie question Im afraid
silentbob - 9 Jun 2009 2:59 PM - 12 messages
Hi Im brand new to SQL (sorry guys for what is probably a newbie question) I have a list of data and one of the colums is titled date.  I want to be able to amend my current sql query so I can search between a ...
Score Compare Schema Between Two Databases
Lijun Zhang - 9 Jun 2009 2:39 PM - 4 messages
Does Microsoft has similar tools like Red Gate SQL Compare to compare schemas between two databases? Thanks, Lijun ...
Score SQL 2005 Index fragmentation
Tom Reis - 9 Jun 2009 2:12 PM - 6 messages
After running a index rebuild on a a database on a SQL 2005 64 bit server I noticed the indexes are still fragmented. Is there something else to be run with the index rebuilds? ...
Score AWE enabling in sql
Mecn - 9 Jun 2009 2:01 PM - 8 messages
Hi, I enabled the AWE option in newly upgrade sql2005 with total 8GB sql server. How do I configure the memory, 1.  Min server memory(in mb) 2. Max server memory (4gb) = 4,000,000,000? 3 Index creation Memory (in KB) ...
Score xp_cmdshell failed to execute because current security context is
db - 9 Jun 2009 1:41 PM - 12 messages
Microsoft SQL server standard edition Microsoft windows NT 5.2 (3790) Platform: NT INTEL X86 Version: 8.00.2039 SQL server 2000 SP4 Application error log has following message: xp_cmdshell failed to execute because current security context is not sysadmin and proxy acount is not setup correctly. For more information, refer ...
Score Language
Muhammad Bilal - 9 Jun 2009 12:48 PM - 2 messages
Hi I have problem of insert Arabic text to sql server 2000. I always get ???? instead of the Arabic letters but if i manually copy the value directly into the column through enterprise manager if works fine. Datatype of colmun in ...
Score Insertion Prob...
Muhammad Bilal - 9 Jun 2009 12:22 PM - 8 messages
Hi. I am using SQL Server 2000 EE (SP4) on Windows Server 2003 EE (SP2). Data is populated into the tables in bulk from text files through a third party application made in VB 6. The problem is that the data is not populating into the tables as I have ...
Score Index Won't De-frag when Re-Building
sh0t2bts - 9 Jun 2009 11:54 AM - 4 messages
Hi All, I'm using SQL 2005 Standard Edition and I have some Indexes that are fragmented but won't de-frag to 0% when re-build, I have tried rebuilding the index using SQL commands and also using the SQL Server ...
Score Database backup
Simon Z - 9 Jun 2009 9:12 AM - 4 messages
I have backup database task and I set that backup set will expire after 14 days. Than I have History cleanup task to remove historical data older than 14 days. But when I look content in my backup file, I have backups older than 14 ...
Score SQL 2008 EXPRESS + SP1
Martin Racette - 8 Jun 2009 9:23 PM - 5 messages
Hi, Sometimes ago, when the SP1 for SQL2008 came out on Windows Updates, I nstalled it, but since then SQLEXPRESS database does not start anymore, so I tried to uninstalled it, that worked, I tried to re-installed it that did ...
Score Difference in Network Bandwidth and I.O. - In-line SQL Query v. RP
Jelle - 8 Jun 2009 7:08 PM - 4 messages
Hi Everyone, How much of a difference is there, if any, in Network Bandwidth and I.O. between an in-line SQL Query verses a Stored Procedure RPC call?  Both are run from a web application server connected to a SQL 2005 Server instance.  ...
Score Cannot drop the table '#tmp_sp_db_vardecimal_storage_format'
BobW - 8 Jun 2009 5:15 PM - 15 messages
I am getting this error on a SCE DB on SQL Express 2005.  It is running EBS. The SQL manager shows the DB as "suspect". Any thoughts would be appreciated, Thanks Bob ...
Score Hardware configuration
Carl Hilton - 8 Jun 2009 5:03 PM - 8 messages
Good Day, MANY years ago it was almost mandated by the MSSQL gurus that an MSSQL instance/data should NOT be on the same PHYSICAL hard drive as the OS... Has this changed? If not.. is this documented in MS documentation? ...
Score Which row inserted first
Muhammad Bilal - 8 Jun 2009 2:00 PM - 27 messages
Hi. Can we get that which row is inserted in the table first or in which order all rows are inserted. Regards, Muhammad Bilal. ...
Score sql 2000 maintenance plan schedule best practices
Saucer Man - 8 Jun 2009 1:01 PM - 7 messages
I am curious about the scheduling of the maintenance plans.  Do the Optimizations, Integrity, Complete Backup, & Transaction Log Backup need to be scheduled at different times so they don't conflict with each other? ...
Score SQL 2000 Instance on a SQL 2005 installation??
Paullyie - 8 Jun 2009 11:35 AM - 3 messages
Hi Guys n' Gals, As the title says, How do I go about installing a SQL 2000 Instance on an a server where SQL 2005 Server already installed. I have read through a few threads here already, posts say yes it can be ...
Score SQL Server 2000: Identity columns guaranteed sequential?
JimLad - 8 Jun 2009 10:24 AM - 16 messages
Hi, SQL Server 2000 question. Can I please have confirmation that INSERT statements to Identity Columns are guaranteed to be sequential? i.e. that I can safely use SCOPE_IDENTITY() and @@rowcount to work out what ids were inserted and then update the FK in a linking table (with order by clauses of ...
Score Socket info
Abba - 8 Jun 2009 6:52 AM - 5 messages
Hello, Iam in the process of deciding the hardware for our new SQL2008 box. For the same, I need to include the socket information in the existing box as that would aid in hardware decisioning based on the SQL Server license needs. ...
Score SQL Server 2005 Creating own shortcuts, Macro or macro like
gDeveloper - 7 Jun 2009 8:39 PM - 5 messages
I might be missing it or there is another tool but I would like to create my own shortcuts in SQL Server 2005.  What I was trying to accomplish is selecting a table I have in the object browser and pushing some shortcut key and have it generate the Select script. ...
Score How do I remove SQL2008?
Richard Lawson - 7 Jun 2009 4:51 AM - 4 messages
I installed SQL2008 for testing and now I want to remove it but I see nothing in "Add/Remove Programs" for removing it. Also, nothing in the program menus. I tried a second install from the MSDN CD to see if I could ...
Next » 2 3 4 5 6 7 8 9 10