Home All Groups Group Topic Archive Search About



Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Simple question on SQL 2005
Adam Raff - 17 Nov 2007 9:29 PM - 3 messages
Good Day, We have SQL 2000 running on Windows 2003 SP1 Does SQL 2005 support Windows 2003 SP1 32bit or do you need Windows 2003 R2 64bit code? Thanks Adam Raff ...
Score SQL Server Express 2005 ad Classic ASP
Anil Gupte - 17 Nov 2007 6:33 PM - 3 messages
I am using the following to try to connect to the database, but it does not seem to be working. Dim sConnString sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MediaDB;Data Source=MEDIAMACHINE\SQLEXPRESS" ...
Score Witness servers
manu - 17 Nov 2007 12:16 PM - 3 messages
Hi, Can I have two witness servers for one mirroring session running between two databases(One on principal server and other on mirror server). Is there any restriction on number of witness servers in mirroring? Thanks in advance, Manu ...
Score Concurrency violation adding records Why?
Rob Dob - 16 Nov 2007 9:09 PM - 8 messages
Hi, I'm getting periodic concurrency violations while adding new records, can someone please tell me how to resolve this.   I have an application that is running multi-user, approx 60+ users and for some reason my application is ...
Score @@CPU_BUSY
Jay - 16 Nov 2007 8:42 PM - 5 messages
I'm looking at the various counter variables available in SQL Server 2000 & 2005 and trying to understand what they can be used for. The ones I'm intrested in are: @@cpu_busy @@io_busy @@idle @@pack_received @@pack_sent @@connections @@packet_errors @@total_read ...
Score Does SSIS understand perflog binary file
Hassan - 16 Nov 2007 8:38 PM - 4 messages
Once I have a set of binary files from Perfmon, does SSIS understand the file format ? Or do I have to save the perfmon in text format ? ...
Score How to list (Export to txt) the Built-In and User Store Procedures
gatox - 16 Nov 2007 7:41 PM - 2 messages
Good afternoon, How can I export a list of Built-In and User Made Stored Procedures on an SQL-2005 server ? Regards, Luis ...
Score Database maintenance plan backup
PT - 16 Nov 2007 7:31 PM - 4 messages
I've created a database maintenance plan with backup database task which is set to back up the transaction logs of several specified databases.  I open up the backup database task, then choose <select one or more> from the ...
Score altering unique index to primary key
James - 16 Nov 2007 5:52 PM - 4 messages
Is there a way to alter a unique clustered index in a table to a primary key with some magic alter statement? What I want to avoid (if possible) is to run drop/create statement, just to make already unique clustered index to a Primary key. ...
Score sms shows new job dialog when view properties
John - 16 Nov 2007 3:43 PM - 5 messages
When I try to view the properties of a Sql Server 2005 job from my work station it shows the New Job dialog. If I use RDP to connect to the server and then launch SMS from there it works correctly and shows the job ...
Score regarding troubleshooting blocking in sql server 2000
Iter - 16 Nov 2007 2:19 PM - 2 messages
Hi Guys, I wonder if there is a way that I can setup an alert when there are some tables are blocking for a long time in Sql server 2000? That mean I can get email or call when blocking is occurred. Thanks. ...
Score Role to create views only
Juan Manuel Porras Gálvez - 16 Nov 2007 1:44 PM - 3 messages
Hello all, are there any way to create a SQL Server role for CREATE permissions only at views (not tables and stored procedures) and SELECT to all?. Thanks for all. ...
Score Autoincrement ID as return value
Jovo Mirkovic - 16 Nov 2007 12:52 PM - 3 messages
Hi, what is the best way for insert some row to table and return ID of that row, which is autoincrement? Is it necessery lock table/row, or transaction is enough good solution, or..? Thanks, Jovo *** Sent via Developersdex [link] *** ...
Score Two related tables transpose table 2.
zb - 16 Nov 2007 6:36 AM - 2 messages
I am novice at this but have been assigned to do this. I have two tables Table1. id   col1   col2   col3   col4 1    abc    def     ghi     jkl ...
Score installing sql server 2005 express with advanced services sp2
Daniel Brower - 16 Nov 2007 6:09 AM - 5 messages
I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default installations options.  I found afterwards that there are no tools installed to help me view and manage the database files.  Could I just rerun the installation and add those in?  Which options do I need to ...
Score sys.dm_db_index_usage_stats
Hassan - 16 Nov 2007 5:10 AM - 3 messages
From BOL for sys.dm_db_index_usage_stats "You can also use the view to determine which indexes are incurring maintenance overhead. You may want to consider dropping indexes that incur maintenance overhead, but are not used for queries, or are only infrequently ...
Score SQL Server Read/Write Request Size from the Disk IO Subsystem
Cqlboy - 16 Nov 2007 5:09 AM - 4 messages
How does SQL Server determine what request size to make to the disk IO subsystem?  If you monitor in Perfmon the Avg Bytes Per Read/Write you'll see that this can very between ~8K (min page size in SQL Server) up to ~300 ...
Score sql server 2005 with sql server 2000 desktop consecutively
Daniel Brower - 16 Nov 2007 2:46 AM - 2 messages
Can I install SQL Server 2005 Standard Edition on a machine that is needs to also run SQL Server 2000 Desktop Engine? Daniel ...
Score unused indexes in SQL 2005
Hassan - 16 Nov 2007 2:41 AM - 2 messages
When i run the query to give me list of unsed indexes, is that result set populated since the last time SQL Server was restarted? In other words, does the list reset once SQL Server restarts ? Thanks ...
Score Install Visual Studio or SQL 2005 first ?
Hassan - 16 Nov 2007 2:40 AM - 2 messages
Want to install both Visual Studio and SQL 2005. Which one should I install first ? Thanks ...
Score fix DBCC CHECKCATALOG errors
Waldemar Grzywiñski - 16 Nov 2007 12:08 AM - 2 messages
How to fix system tables integrity errors? DBCC CHECKCATALOG  points that exists objects (in sys.columns) without depend views. In SQL 2000 I can edit direct sysobject table. How delete orphaned objects in SQL 2005? Only way is copy data to new database? ...
Score Stored procedure sp_sqlagent_get_perf_counters uses too much cpu t
Erick Korsten - 15 Nov 2007 11:49 PM - 3 messages
On our development server I noticed that there is a SQL Agent process running that executes the stored procedure sp_sqlagent_get_perf_counters every 20 seconds. This process is using a lot of cpu time. I found out that this process is related to the SQL Agent alerts and that ...
Score Temp table solve the performance issue?
Ed - 15 Nov 2007 10:18 PM - 3 messages
Hi,   I have the following SQL. (Select Max(OrderDate), CustomerID From TableA Where Category = 1 Group By CustomerID) (Select Min(OrderDate), CustomerID From TableA Where Category = 9 Group By CustomerID) If I run those SQLs individually, they take like 5 seconds. ...
Score Take a database out of Exclusive mode
Shelley - 15 Nov 2007 9:20 PM - 2 messages
HI, i was trying to back up a content database in sql server management studio so I put it to exclusive mode(read only and single user access).  Now i am trying to take it out of that mode but I keep getting the error msg: ...
Score Cannot register server (LOCAL)
rkbnair - 15 Nov 2007 8:48 PM - 11 messages
I'm trying to register the (LOCAL) database  using SQL Server authentication. However, I get the following message. I still can register other servers  using ip addresses though. ===================================================== Cannot connect to (LOCAL). ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server.  When ...
Score Query wizard
Aleks Kleyn - 15 Nov 2007 7:43 PM - 2 messages
in sql server 2000, table view, i can right click any table and invoke query select wizard. At any time I can select spetial icon on toolbar and change type of the query: select, insert from, insert into, update, delete. I  ...
Score service pack on windows server prior install sql server 2005 standard
Daniel Brower - 15 Nov 2007 7:32 PM - 6 messages
I am preparing to install SQL Server 2005 Standard Edition on a Windows Server 2003 that came with Small Business Server Premium Edition.  The server will be used for developmental purposes only.  The server only needs to provide data through SQL Server.  No security issues are to be ...
Score EXISTS Performance Problem
Clark Kent - 15 Nov 2007 5:28 PM - 4 messages
We recently migrated from 2000 to 2005 (I know...early adopters) and our first day in production we ran into a bunch of performance issues. We have some conditional checks in a stored procedure that return out different values based on the existence of data in specific tables or views. ...
Score join SmallDateTime column very slow
DAXU - 15 Nov 2007 4:47 PM - 2 messages
Hello, I posted this on programming group, but hasn't got any reply yet. I have a table and the definition is like: CarTable(         [RowNumber] [int] IDENTITY(0,1) NOT NULL,         ModelID, ...
Score 2005 Analysis Services problem!
Paul - 15 Nov 2007 4:23 PM - 3 messages
Hi I have a 2005 dbase running on my local machine but when I open Analysis services I get the following error (no connection could be made because the target machine actively refused it). Also just wondering if there are any tutorials on setting up a simple data ...
Score SQL2005 and scheduled backup
Tom Reis - 15 Nov 2007 4:11 PM - 2 messages
When backing up a database in SQL2000 it had a checkbox for which to schedule the backup. I noticed this is not the case with SQL2005. I am missing something or do you have to manually set up a job to run a scheduled ...
Score Database Refreshes
guest5 - 15 Nov 2007 3:05 PM - 3 messages
Has anyone come across any useful scripts to copy database backups from live and restore onto dev servers? ...
Score c2 auditing
guest5 - 15 Nov 2007 3:01 PM - 3 messages
Is there any way to granularise what c2 monitors? I have a system which is generating thousands of trades and this is in turn generating a 200Mb c2 trace every 1 minute. ...
Score database backup question
Mike - 15 Nov 2007 2:51 PM - 7 messages
For my database backup is there a way to only keep the last 5 backups? Currently my backup is creating a new .bak file with every backup. I only want a .BAK for the last 5 days. So I only want the last 5 .bak files at any given time. ...
Score DB Disk Hot Split question
Blue Fish - 15 Nov 2007 1:37 PM - 3 messages
Hello:     I am using SAN storage to store the DB files. The SAN disk is in mirror. Does any config that I can perform the hot split the SAN mirror disk and the DB files can be use as backup purpose? ...
Score Cannot edit maintenance plans post SP2
CharlesB1 - 15 Nov 2007 1:35 PM - 3 messages
I have some maintenance plans written for SQL Server 2005 SP1. After we upgraded to SP2 I can no longer edit them. If I select the Maintneance Plans node in Object Explorer and double click on any plan I get "Microsoft SQL ...
Score master location in sysdatabases incorrect after move
DaveS - 15 Nov 2007 12:19 PM - 7 messages
I recently moved the master.mdf and ldf files to another drive on the server by changing the locations within the Startup Parameters, shutting down SQL, physcially moving the master.mdf/ldf files, and starting up SQL.  It is ...
Score tool to import eventlog and perfmon data into SQL database.
Hassan - 15 Nov 2007 5:41 AM - 3 messages
Are there any tools out there to import say eventlog,Perfmon and IIS logs into a SQL database ? I dont know how to programatically do so but would love to know if there are any tools out there that I can point and click ? ...
Score index usage
Hassan - 15 Nov 2007 5:39 AM - 3 messages
if i have an index idx1 on col1,col2 and another index idx2 on col1,col2 with included columns col3 and col4 Do i need to have idx1 ? I think it may be of no use.Am i right ? ...
Score about set an alert that is about blocking
Iter - 15 Nov 2007 4:37 AM - 3 messages
Hi Guys, I wonder if there is a way that I can setup an alert when there are some tables are blocking for a long time? That mean I can get email or call when blocking is occurred. Thanks. ...
Score SQL Analyse Software
Pcnetnet - 15 Nov 2007 3:36 AM - 2 messages
Hi All, i have problem on SQL 2000, "insufficient memory availbele" , i want use software monitor the SQL , which software is best for SQL monitor , Thanks, Thanks, ...
Score SystemResource tables
Scott - 14 Nov 2007 11:09 PM - 5 messages
I've followed the steps outlined in the BOL for moving system tables: [link] The master databases were moved without a problem. However, when I get to the Resource database, i cannot get passed the ALTER DATABASE statement. If I ...
Score DDL Triggers
news.microsoft.com - 14 Nov 2007 11:04 PM - 2 messages
Hi, I am trying to write a DDL Trigger so that whenever someone creates or drops Database I store information somewhere. My Trigger is working, now I am trying to make it more useful by extracting: * "Name" of the database being dropped or created ...
Score Are there any good performance tuning tools that I can use to moni
Iter - 14 Nov 2007 10:27 PM - 8 messages
Are there any good performance tuning tools that I can use to monitor SQL Server database? Thanks. ...
Score Re: Newbie - Store jpg file in Image Data Type Field
Joe from WI - 14 Nov 2007 8:58 PM - 2 messages
I need to do the exact same thing but in SQL Server 2000. I have been tinkering with BULK INSERT and OPENROWSET but have not been able to get anything to load the image data. Actually in my case, the image data can be a Word document, Excel ...
Score -- rebuild master --
Edmundo J. Davila - 14 Nov 2007 8:56 PM - 10 messages
hi, is there a way to rebuild the master database in sql server 2005 without installing SQL Server again. I try from the command line, but it sends me to add/remove program, and from here there are is no option to do that. ...
Score Changing backup model before running reindex
Kevin - 14 Nov 2007 8:41 PM - 3 messages
Our txn log is ballooning after we re-index.  I've see a recommendataion to change to Bulk-logged before re-indexing and I'm wandering, will this break my backup chain?  Currently we are running full backups every Sun morning ...
Score Cannot get proxy account to work.
Chris Lumnah - 14 Nov 2007 7:17 PM - 5 messages
For some reason I cannot get a job to run under a different account other than the SQL Agent.  What I have done is the following. 1)Created a credential called operations that has the domain\user format with its password.  The user used is the SA of the sql server. ...
Score How Does Log Shipping / Database Mirroring Work with a SAN?
Charles Law - 14 Nov 2007 7:05 PM - 23 messages
We have two servers running Windows 2003 Server Standard Edition, SQL Server 2005 Standard Edition and a SAN. How do we set up this configuration to automatically failover from one server to the other in the event that the primary server goes down? I had ...
Score SQL Question
bpdee - 14 Nov 2007 6:24 PM - 9 messages
Hi, Here is my sample table. create table test (journal_ctrl_num  nvarchar(16) not null, sequence_id       int          not null, document_2        nvarchar(16) not null) ...
Score SQL Server Access
Brett_A - 14 Nov 2007 6:01 PM - 8 messages
Is it possible to access an SQL server db from a web site when the actual db sits on another server at another host? Thanks Brett ...
Score Poor SQL Server Performance on High End System
Jimmy - 14 Nov 2007 5:50 PM - 9 messages
I have a dual core xeon 3.0 ghz system with a dell DAS disk array that contains the following disk layout: Status  Name  State  Read Cache  Write Cache  Cache Policy  Layout  Size ...
Score dts package failure when setup as job
Paul - 14 Nov 2007 4:54 PM - 5 messages
HI I have a dts package (SQL 2000) that I can execute from Enterprise manager opened on a client machine connected to a server.  When I schedule it as a job though Enterprise manager on the client machine connected to the server ...
Score How to open DTS
Ratan - 14 Nov 2007 1:22 PM - 11 messages
Hi everybody, I am very new to MS-SQL Server 2005. I need to know how to open DTS. Your kind help is awaited. Thanks in advance. ...
Score Importing Comma Delimited Data.
ben brugman - 14 Nov 2007 12:52 PM - 5 messages
Hello, I am trying to import files (hundreds) with Comma Delimited Data, because some columns within the data contain comma's themselves those fields have been double qouted. Small example. 1234, hello John, mega 2345, " Hello Andrew, Marie", tall I have tried to use Bulk insert with a Formatfile in xml and suggested by ...
Score SQL2005 - How to remove database file and filegroup
ThorR - 14 Nov 2007 6:47 AM - 11 messages
I have a problem with removing files and filegroups from a database. I have 3 filegroups, two of them with multipile files.Things I've done: 1. For each file group I made them one phisical file using DBCC SHRINKFILE (name, WITHMOVE). ...
Score AWE got 0, said DBCC MEMORYSTATUS...
light_wt - 14 Nov 2007 4:23 AM - 3 messages
I have done these steps to config and enable AWE.  But, DBCC MEMORYSTATUS still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc. sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE ...
Score BCP truncation error on few tables?
Jeje - 14 Nov 2007 3:06 AM - 9 messages
Hi, I'm using BCP to copy some data between 2 servers. I'm using the -N option to export the tables into the Native Unicode format this works fine except for few tables where I receive the truncation error: ...
Score The text data field
rojelio - 13 Nov 2007 9:12 PM - 3 messages
There is a limit to the text data type field.  And I really need it to be increased.  Try as I may I haven't been able to find anything searching the web.  Anyone know how to increase the capacity of the ...
Score Database path contains an Extra Backslash.
Jon Osborn - 13 Nov 2007 8:40 PM - 4 messages
I am very new to Sequel Server but we have a SQL 2000 server.  One of the paths inthe database has an extra slash i.e (C:\Progame files\\websense) Vertias Backup can not back it up if it has an extra slhash.  How can I ...
Score Percentage?
Paulo - 13 Nov 2007 6:56 PM - 2 messages
Hi, example: if: Price           = 50 Percentage  = 50 SQL column Liquid will return 25 Select Price - ((Price*Percentage)/100) as Liquid From Product is the best way of doing that? ...
Score Convert DB Collation Sort Type in SQL 2005 for MS Dynamics GP
HAfandi - 13 Nov 2007 11:44 AM - 9 messages
Hi, we have ms dynamics gp with SQL 2005, our database collation type is Arabic_Bin we want to change the collation to Accent-sensitive sort type is there any way to convert the database collation sort type without damaging the data (specially the arabic language fields) ...
Score Timeouts after periods of inactivity in server
Squig - 12 Nov 2007 9:34 AM - 7 messages
Hello All, I have 3 servers with sql server 2005 sp2 running each on win 2003 server. Each sql server instance has a copy of the same database. Load balancing spreads the load in these servers in such a way that the ...
Next » 2 3 4 5 6 7 8 9 10