Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Where is Bookmark Lookup?!
Leila - 8 Apr 2006 8:44 PM - 3 messages
Hi, In the graphical view of execution plan (in QA), a bookmark lookup was quite easy to find. But in SSMS, it is displayed as a inner join. Although the logic is the same, but in exec plan of complicated queries, it is much ...
Score newbie having trouble with SQL connection, insert/update
pmetz - 8 Apr 2006 11:55 AM - 2 messages
Thanks to anyone who helps!       I'm building a data entry windows form that requires the data to be sent to a SQL Server table (the table's name is "Local") when the form's "SAVE" button is clicked.  I've built the form using the windows ...
Score The media set has 2 media families
thejamie - 8 Apr 2006 11:07 AM - 8 messages
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. This is an error received when I try to restore a database from backup.  Anyone know what it means? ...
Score 6.5 Servercrash
Alexander Koch - 8 Apr 2006 9:46 AM - 7 messages
Hello, we have a NT4-Server with SQL 6.5 SP5 running. The xx.DAT Database is already here. Who can I read the Data in the DAT-File? Who can I convert the DAT-File to a SQL2000 Here is the origin text in german: ...
Score Memory > 4GB on Cluster
R Stovall - 8 Apr 2006 3:14 AM - 4 messages
Hello.  This topic has been beaten to death, so I apologize for asking the question again.  I just can't seem to get a handle on what I should do. A client of mine has a 2 node SQL 2000 A/P failover cluster with Server 2003 ...
Score SQL Server 2000 and .doc
Jason Huang - 8 Apr 2006 3:08 AM - 2 messages
Hi, In SQL Server 2000, how do we save a MS Word document .doc file into database? Thanks for help. Jason ...
Score Database Design Assistance
jasonl22 - 8 Apr 2006 2:28 AM - 5 messages
I have 2 tables that will be created from flat files and recreated on a daily basis with 300,000+ records and growing daily (tables will be truncated and re-loaded via a batch process because we do not "own" the ...
Score BULK INSERT and the ERRORFILE parameter
Nick - 7 Apr 2006 10:59 PM - 2 messages
Can someone tell me if the ERRORFILE parameter is a valid (and functioning) parameter for the BULK INSERT command when using SQL Server 2000? Finding documentation on this has been difficult, but it appears to be a new parameter under the BULK INSERT command for 2005. If I look at ...
Score MSSQL 2005 Can't Query Linked Oracle Server
mike21 - 7 Apr 2006 10:11 PM - 5 messages
Hello All: I am trying to create a server link between MSSQL 2005 and Oracle 9.2.0.7. I can successfully execute the sp_addlinkedserver and sp_addlinkedsrvlogins function but when I attempt to execute a query against the Oracle server such as: ...
Score Backup of SQL DB with Veritas Agents
Citigate Cunningham Helpdesk - 7 Apr 2006 9:47 PM - 4 messages
Help! We just upgraded to version 10d of the Veritas/Symantec software - part of upgrade was to update the remote backup exec agent that is used to backup SQL db's. This is the event log entries for the job that fails. ...
Score Help with disaster recovery plan.
Carly - 7 Apr 2006 9:46 PM - 3 messages
Hi, I would like to know how we can save the logins and passwords and the security context of each log in for a working server. I know all the info resides in master database but I never attempted a ...
Score newbie having trouble w/ insert/update statments
pmetz - 7 Apr 2006 9:41 PM - 2 messages
Thanks to anyone who helps!       I'm building a data entry windows form that requires the data to be sent to a SQL Server table (the table's name is "Local") when the form's "SAVE" button is clicked.  I've built the form using the windows ...
Score sp_spaceused on 2005
Mark - 7 Apr 2006 9:19 PM - 4 messages
I executed sp_spaceused against every table in my database.  There were two tables out of 30 over 1 MB -- both were under 10 MB.  However, when I right click on the database in Management Studio, choose properties, and then view ...
Score SSL to SQL
Roland Hall - 7 Apr 2006 9:07 PM - 9 messages
I'm looking to make a connection from a host to a SQL server across the Internet via SSL.  Is this possible?  A link to information would be greatly appreciated. Roland Hall ...
Score Prevent Local Admin Account From Deletions
Terrance - 7 Apr 2006 9:04 PM - 3 messages
I have a question I'm hoping someone can help me with. I'm running SQL Server 2000 and I'm logging into QA with Windows Authentication; in Enterprise Manager I marked the EXEC PERMISSION for deny on a Stored Procedure for the ...
Score Buffer Cache Hit Ration on a Reporting DB
ajohnson - 7 Apr 2006 8:48 PM - 2 messages
Hi all. First off, I'm a sys admin, not a DBA. I'm trying to improve buffer cache hit ratio on a reporting database. Database is approximately 130GB. Current server is a Proliant ML530 G2, 2-way 3.6Ghz, 8GB RAM. Multiple datafiles spread out across 4 separate ...
Score SQL 2005 Express Manager and Managment Studio
Cgal - 7 Apr 2006 8:34 PM - 2 messages
I recently downloaded the latest SQL Server 2005 Express Manager that is part of the latest CTP.  When I try to install the Express Manager on a machine that already has the RTM Edition of SQL Server 2005 the install ...
Score Primary key allows null?
Mark - 7 Apr 2006 7:17 PM - 3 messages
XP Pro / Access 2003 Project / SQL Server 2000 Backend I have a table that I have assigned multiple fields as the primary key(s).  There are about 6 fields that make up the primary key for this table.  When ...
Score SQL Licencing
Paul - 7 Apr 2006 6:09 PM - 2 messages
If I were to purchase the Device/User CAL option for SQL 2005 instead of the Processor Licence - do I still need to worry about how many processors I have on the SQl server ? Or is the Device/User CAL per processor as well ? ...
Score Turning services on/off in SS2005
sck10 - 7 Apr 2006 5:47 PM - 2 messages
Hello, Is there a way to turn on/off all the services as a group without having to select each gingival service in Server Configuration Manager? ...
Score Problem with parenthesis in the default value of a column
artur - 7 Apr 2006 5:43 PM - 2 messages
I am having a problem with the format of default values in SQL Server 2005. I am using a legacy application that is not expecting the double parenthesis around the default value that SQL Server adds. For instance, if I set 0 (zero) as the default value for a column of type int  as follows ...
Score Upgraded to SQL 2005 - 64bit Itanium server
SBAUER - 7 Apr 2006 5:30 PM - 2 messages
We moved a 2000 db over to 2005 via the detach/attach method. Ran the usual dbcc for stats and checkdb with no errors. However, when we run loadrunner against the system (5 users doing the same amount of reads and writes), the CPU max's out and performance is terrible. ...
Score Is it possible to set MAXDOP on index create
TJT - 7 Apr 2006 3:33 PM - 5 messages
In SQL2000, I have a CREATE INDEX statement that I would like to run with (MAXDOP 1).  When I try putting OPTION (MAXDOP 1) at the end of the sreate statement - it throws an error. Is there any other way to do this? ...
Score Stop a replication
Thierry D. - 7 Apr 2006 3:16 PM - 5 messages
An a SQL server 2005, how can I stop a merge replication ? On the old version, we could do a right clic on the subscription, and then stop. Thank you Thierry ...
Score Merge replication
Thierry D. - 7 Apr 2006 2:59 PM - 3 messages
We migrated to SQL server 2005. On a database, we have a merge publication with 15 subscribers ( CE ) in test. A want to deploy more users. Now the replication don't work : it takes more than 2 hours and seems to replicate thousand and thousand of lines. ...
Score large VarChar vs Text
Wingman - 7 Apr 2006 2:50 PM - 2 messages
Hi, We are using SQL 2K with SP4.  We have a char field which can potentially have up to 6,400 characters, should we use Text instead.   Is there a guideline to when we should use Text ...
Score Move data from 7.0 to 2005
mumbaichef - 7 Apr 2006 2:01 PM - 8 messages
Hi, I wanted to know if there is a fast and easier way to move data from SQL 7.0 to SQL 2005. The database structures are TOTALLY different. The tables, fields, datatype nothing is same. One table in the new db will ...
Score URGENT HELP !! How to move transaction log to new drive?
Tim Greenwood - 7 Apr 2006 1:55 PM - 3 messages
We installed a new mirrored set of drives in our primary server this morning and planned to move the transaction logs for all databases.  We cannot find how you move them.  It won't let us change the primary tlog. ...
Score Advanced T-SQL Question: Producing Backup Window Timeline Chart
Kael_Sidhe - 7 Apr 2006 1:51 PM - 2 messages
I'm an Oracle DBA who inherited 100 or so SQL Databases.  I know how I would accomplish this task in Oracle but I have no clue how to do it in T-SQL.  In short, I want to produce a comma delimited gantt type ...
Score Get every Sunday's date?
angi - 7 Apr 2006 11:43 AM - 6 messages
Hi, Is any way to get every Sunday's date? Any function, reference or something else? Thanks for help! Angi ...
Score Would love to use SQL Server 2005 but I am a developer
Alex - 7 Apr 2006 8:30 AM - 24 messages
When we install our system we attach our database to SQL Servers that our customers have. It has to be this way as there are lots of pre-configured data in DB etc. Besides it is easier than using scripts. ...
Score Any IDE for developing Soterd Procedures and User Defined Functions
Jo - 7 Apr 2006 8:24 AM - 2 messages
hi there: I wonder is there any IDEs for developing Stored procedures and probably user defined functions. I heard about a few, but not for MS SQL server 2k so far, I would really aprecaite the help Regards Andrea ...
Score Error 605 on SQL Server 6.5
vadimm - 7 Apr 2006 8:16 AM - 4 messages
Hello! I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server  6.50 - 6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every night I make full backup of the database on “main server” (using job) and ...
Score howto compare and sychronize dbs located at customers...
Jan - 7 Apr 2006 8:10 AM - 2 messages
Hi, We develop software with a sql server 2000 db as a datasource. The applications are installed at customers network. So we can not create an ODBC connection to it. We can login using rdp for most customers... We have (locally) a master db with the latest changes made to the model. ...
Score error 17883
vadimm - 7 Apr 2006 7:52 AM - 2 messages
Hi, ALL We are getting error 17883 Backup for DB "GBK" was not creating.   19:22 first error. ~ 07:00 users begin to work. Server does not response. ~ 07:13 administrator log in to console.   07:31 server restart. there are no error in error log. ...
Score Install sql server 2000 and sql server 2005 in the same pc?
bluesky - 7 Apr 2006 3:11 AM - 5 messages
Can I install sql server 2000 and sql server 2005 in the same pc? Both SQL SERVER are running well?  Are there any article or documents about it? Any help,  I do really appreciate it. ...
Score 2005 Endpoints question.........
CoreyB - 7 Apr 2006 12:43 AM - 3 messages
We have a in house web app that will need to consume a web service via javascript, so using 2005's new feature, I created an endpoint & exposed a stored procedure to use the Native XML web service functionality.  The procedure works fine, and I've tested behind our ...
Score Re: triggers or code?
Hugo Kornelis - 6 Apr 2006 11:08 PM - 9 messages
On 5 Apr 2006 03:28:13 -0700, Monfu wrote: Hi Monfu, Yes, they are useful. If you use a stored proc to code the auditing, someone might find a way to update the table directly, bypassing the stored proc, and the change ...
Score Error 7391 when distributed transaction started
FRF - 6 Apr 2006 10:06 PM - 2 messages
Node 1: Windows 2003 Server Standar Edition SP1 SQL Server 2005 Standar Edition Node 2: Windows 2000 Server SP4 SQL Server 2000 Standar Edition SP3a Node 1 have node 2 like "linked server", node 2 have node 1 like "linked ...
Score SQl2000 sp?
mecn - 6 Apr 2006 8:40 PM - 3 messages
Hi, Anyone know what SP of sql2k. SP3a? SP4? Microsoft SQL Server  2000 - 8.00.818 (Intel X86)   May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) ...
Score Starting/Stopping Services
Conan Kelly - 6 Apr 2006 8:22 PM - 7 messages
Hello all, Can Services be stopped and started on the server using SQL statements in Query Analyzer on a client (ie. SQL Server Agent Service)? Thanks for any help anyone can provide, Conan Kelly ...
Score Login and corresponding user rights
David - 6 Apr 2006 8:11 PM - 2 messages
Hello, I want to retrieve information for a SQL or NT login that has different types of privileges in all the DB's. Lets say NT login Domain\Test has access to pubs, Northwind, HR, Finance. This login has db_datareader to pubs, ...
Score Locking
Jan Van der Eecken - 6 Apr 2006 8:06 PM - 7 messages
Hi all! Can anyone point me to a doc that describes what the default locking levels were across different versions of SQL, i.e. row vs. page vs. table, going all the way back to version 4.2, and what the circumstances would have been ...
Score Security of our SQL server
Spin - 6 Apr 2006 8:03 PM - 2 messages
Experts, I need to write up a short document about the security of our SQL server. Has anyone written up anything that I may use or know of a link I can look at (other than a generic Microsoft link)? ...
Score The role of Data Warehousing/ Analysis Services for DBA's?
ChrisR - 6 Apr 2006 7:50 PM - 2 messages
When I search job ad's for SQL DBA's, a lot of them these days are asking for DW/ AS experience. Does anyone know what specifically they mean by this for a SQL DBA (not for a DW developer)? Is the common expectation these days that ...
Score 2005 Upgrade Lightweight Pooling Error
kwins - 6 Apr 2006 7:44 PM - 2 messages
I am trying to upgrade from SQL Server 2000 Enterprise to SQL Server 2005 Enterprise on Windows 2000 Server.  It gets to the part where it stops and starts MSSQLSERVER and completes that successfully.  Next, when it says it is updating the database, I get the following error ...
Score XP_CMDSHELL
Jim Heavey - 6 Apr 2006 6:31 PM - 4 messages
I am trying to figure out how to properly execute dos commands from XP_CMDSHELL. If I go down to the dos prompt and enter "Erase d:\tmp\*.*" it erases all of the files. If I enter exec XP-CMDSHELL 'Erase d:\tmp\*.*', I get a message back asking ...
Score Performance of EM
Leila - 6 Apr 2006 5:38 PM - 10 messages
Hi, I have no large database on my notebook. The only databases that I use for my tests are Northwind and Pubs. Each time I install Windows and SQL Server, I notice that EM considerably becomes slow after 1 or 2 months. This is what ...
Score How do I find out what caused a deadlock?
Bob - 6 Apr 2006 5:35 PM - 3 messages
I got an error message from my customer saying that once, during the night, when executing a report it got an error message that stopped the application the extended error was Transaction (Process ID 57) was deadlocked on lock resources with another ...
Score Please help with simple proc-- slow CASE statement
Dan English - 6 Apr 2006 5:33 PM - 8 messages
Hi, I am having trouble with this query... the CASE statement makes it terribly slow, it is very fast without it.  What is the best solution for queries like this where it is predicated on different columns?  Query has ...
Score SQL 2000 high virtual memory
Dion Davis - 6 Apr 2006 4:11 PM - 2 messages
Hi, We've got a Win 2003 SE server running with 2GB RAM and SQL 2000 SE installed. The virtual memory usage for sqlservr.exe seems to be rather high though - the Mem Usage in task manager for this process is around 450MB ...
Score Yet another index question
DXC - 6 Apr 2006 3:51 PM - 7 messages
We have a table with the following indexes from a client. They tell me that the next 2 indexes are created because of an online reporting that selects the data in that order (COL1, COL2) and (COL2, COL1). CREATE  INDEX [MYINDEX1] ON [dbo].[MYTABLE1]([COL1], [COL2) ON [PRIMARY] ...
Score Indexes on separate Filegroups
cbrichards via SQLMonster.com - 6 Apr 2006 3:45 PM - 2 messages
Two questions. Let's suppose I have two file groups, Primary and Datagroup. The Primary group is mirrored and has my system tables and transaction log (Drive letter "D"). My tables and indexes are in the Datagroup on a separate ...
Score Query text column.
Chen - 6 Apr 2006 3:41 PM - 4 messages
Hi, When I using the Query Analyze do the select statement from table, the column set up with data type text always truncate at right side. Any method gets complete data from that text data type column? Regards! Chen ...
Score Why can I never kill blocks?
Maury Markowitz - 6 Apr 2006 3:17 PM - 2 messages
Periodically we get blocks in our DB. I don't really care, it happens rarely enough that manual intervention is fine. However, the manual intervention doesn't work. I do what seems obvious: go into Enterprise Manager, find the blocking ...
Score Stored Procedure and DTS
Jim Heavey - 6 Apr 2006 3:08 PM - 2 messages
Can I invoke a DTS package from within a stored procedure? Can you point me to an example? Can a DTS package invoke a stored procedure?  Can you point me to an example? Thanks in advance for your assistance... ...
Score PLEASE HELP ME TO REMOVE SQL 2005
J. Adeli - 6 Apr 2006 2:48 PM - 2 messages
Hi, I need to uninstall it and there is no SQL 2005 is listed in add/remove program. I know it is strange but true. J ...
Score NEED HELP! SQL Server 2000-Agent Jobs Scheduling error
StephenRay - 6 Apr 2006 2:39 PM - 2 messages
I've got a SQL Server 2000 SP-4 install that is giving me an error on a job scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM.  It logs this error in the error log: [192] Date calculation spin detected for Schedule 18 and ...
Score How to save images to SQL Server?
elena - 6 Apr 2006 2:36 PM - 5 messages
Hi, All I have a question? I have scanned images (file format .tif) i need to store them in SQL Server. And after all how fast is the  search for those images (search on 200 thousands images and up) ...
Score Dos commands within a stored procedure
Jim Heavey - 6 Apr 2006 2:32 PM - 4 messages
Can I issue a dos command like Cd\fred Delete *.* Thanks in advace for your assistance... ...
Score SQL Server 2005 HTTP End Point
c_shah - 6 Apr 2006 2:29 PM - 4 messages
Can you create HTTP End Point on SQL Server Developer edition running on windows XP (sp2)? ...
Score How to import a table with primary and triggers
kai - 6 Apr 2006 2:11 PM - 3 messages
Hi, When I import a table, it only imports the data without  the primary key and triggers. How to import a table with primary key and triggers? Thanks kai ...
Score Max [date] from DIFFERENT columns?
Alec MacLean - 6 Apr 2006 2:08 PM - 2 messages
Hi, I have a table in which there are several date columns recording different event points occuring to a record (e.g., date opened, date action-1, etc). I need to find the most recent date (MAX(date-n)) from across all these ...
Score Local Database Issue with SQL 2000 Install
Colette - 6 Apr 2006 12:21 PM - 2 messages
I've got a user with a new HP desktop requesting SQL 2000 Developer Server and Client Tools to be installed.  When I install the software along with SQL SP4, the local database shows up in Enterprise Manager.  When the user logs ...
Score Multiple Listeners
Jen - 6 Apr 2006 10:55 AM - 8 messages
We have four NIC cards on Windows 2003 server running one default SQL server instance and we want the SQL server to listen all the four cards? How can one setup multiple listener for TCP-IP connection over same port 1433. ...
Score Image of a sql server diagram...
Ollie Riches - 6 Apr 2006 10:47 AM - 4 messages
I have a database diagram in sql server 2000 is there anyway to get a pictorial version of this? Cheers Ollie ...
Score timeout expired
andy everett - 6 Apr 2006 10:23 AM - 4 messages
hi guys, ive a slight niggle, under sql server 2000 i was running a single p4 3.0gig ht with 4gb ram im now on sql server 2005 enterprise, with a dual opteron 265 dp (4 procs) with 6gb mem ...
Score Need to boot connections to my database
matt roberts - 6 Apr 2006 8:59 AM - 4 messages
Hi, We have a batch file that runs every night that drops a database, and restores it to "baseline" version. But sometimes this fails because users have gone home and left SQL Suery Analyser connected to the database, which makes the ...
Score help!I have some question about sql server2005 database mirroring!
lansehai-chen@hotmail.com - 6 Apr 2006 8:37 AM - 16 messages
What's means error code 1416 when i setup database mirroring in sql server2005 exec T-SQL "ALTER DATABASE Mirrortest SET PARTNER= 'TCP://192.168.4.91:5024' " on  server?I refer to sql server2005 online book!! Pelease help me everyone!!Thanks!! ...
Score Stored procedures not running
vsiat - 6 Apr 2006 8:19 AM - 5 messages
Since some time now, quite a few stored procedures take ages to run or dont run at all. The procedures are the ones that involve INSERT or UPDATE operations against a database of about 40GB, all in one filegroup, hosted by ...
Score Unfinished dialog conversations in Service Broker
AlexS - 6 Apr 2006 7:15 AM - 3 messages
Hello! Could someone help me with the subject? Our company is developing an application with quite a high load on database. Our DBMS is SQL Server 2005. We're using QuieryNotification (via SQLDependency object) for caching data to speed up Web-interface. ...
Score Shrinking data files of a read only database
Anoop - 6 Apr 2006 7:02 AM - 2 messages
I have a read-only database. I need to shrink one of the data files of the database. Is there a way of doing this without changing the database option of read-only. ...
Score Replication and Rebuild index
jcvoon - 6 Apr 2006 6:30 AM - 3 messages
Hi: If replication and rebuild index happen at the same time, which one will fail ? Please advice JCVoon ...
Score multiply by 1/4
gracie - 6 Apr 2006 6:29 AM - 5 messages
Hi, What's wrong with this: DECLARE @a as float DECLARE @b as float SET @a = (0.25) * 100 SET @b = (1/4) * 100 print @a print @b Returns: 25 0 Why is the following returning 0 and not 25? ...
Score Truncating backup system tables from MSDB
Muhammad Shariq Muzaffar - 6 Apr 2006 6:22 AM - 8 messages
consider me as a lazy DBA, i have more than 500 databases on my sql server with 1 full backup each day and transaction log backup after every 10 minutes for every user database. The size of msdb was 11 GB a month ago, i tried to run a customized stored ...
Score Turn off SQL 2005 Password Policy
Jonas Larsen - 6 Apr 2006 5:36 AM - 2 messages
Guys Problem: Im trying to install 3rd party sw on SQL 2005, this 3rd party sw needs to create users with predefined passwords. Unfortunately these password does not meet the password policy of SQL 2005. Question: How do I temporarily turn off this password policy checking so I can install ...
Score moving tables from one server to another
TL - 6 Apr 2006 3:21 AM - 3 messages
Hi all, I'm new to MSSql server and need some advice on this. I need to move a few tables from a database in server A to another database in server B. How should I do this? Thanks, TL ...
Score triggering a task to run based on a time contained in a record
ruslan00 - 6 Apr 2006 2:59 AM - 2 messages
Hi, I'm making a web page that sends SMSs using ASP.NET(C#) and MS SQL Server 2000. The way it sends SMS is that it submits a form (POST or GET) to a third-party server which includes the phone number, message ...
Score how much size SQL SERVER each connection memory ?
lovexueer - 6 Apr 2006 2:45 AM - 4 messages
recently ,I got about15M size to  each db connection memory with windows performance monitor, I want to know is this normal? I heard that each normal connection is about 2M size,is this right? best regards! ...
Score SQL Server 2000 and SQL Server 2005 Co-exist ?
Seagull Ng - 6 Apr 2006 1:42 AM - 4 messages
Can both SQL Server 2000 (developer edition) and SQL Server 2005 (developer edition) co-exist in the same environment (Windows XP Professional)? I need to have both so that I can do some testing in development environment. Thanks. ...
Score Lock on SELECT?
ja - 5 Apr 2006 10:44 PM - 3 messages
My app utilizes a Windows Service written in .Net to poll an SQL 2000/2005 database and update rows based on the value of a field in each row.  I'd like this service to run on more than one computer, ...
Score problem w/ sp_change_users_login on 64bit SQL Server 2005?
M Noreen - 5 Apr 2006 10:04 PM - 5 messages
Here's the situation:  I  just restored a full backup of a SQL Server 2K database to a brand new server running 64 bit Windows 2003 Server running 64 bit SQL Server 2005 Standard Edition. I also restored this same database to ...
Score Re: Need help understanding a memory issue
Shadow - 5 Apr 2006 9:40 PM - 2 messages
You are right that there is pressure on MemToLeave, but firstly if its requesting 15MB, in normal circumstances.. this request is way too much.. i would say even 50KB is not normal. I think you got some third party dll's loaded into your SQL process. ...
Score modified date on table after alter command
bluebirds - 5 Apr 2006 9:29 PM - 2 messages
Using SQL Server 2000 - Trying to find a modified date for table after issuing an alter table command.  Sysobjects has crdate I can not find modifed date.  Need ithe nfo for SOX  to prove that no tables have been modified unless ...
Score Testing SQL before executing
cbrichards via SQLMonster.com - 5 Apr 2006 9:14 PM - 4 messages
I have a statement (due to a known bug) that often errors. That statement is the following: INSERT TableName SELECT * FROM ::fn_trace_gettable('Path\Filename, default) The error as you have probably seen before is: Msg 567, Level 16, State 5, Line 1 ...
Score Update Lock (Preventing deadlock)
Leila - 5 Apr 2006 9:08 PM - 7 messages
Hi, How does the update lock (before obtaining exclusive lock) can prevent deadlocks? In what situations? This is what BOL says about this type of lock: ------------------------ If two transactions acquire shared-mode locks on a resource and then attempt to update data concurrently, one transaction attempts the lock conversion to ...
Score Backup & Restore Question
Shawn - 5 Apr 2006 7:45 PM - 3 messages
Is it possible to restore a SQL 2005 backup to a SQL 2000 server? -Shawn ...
Score Does Query plans change on static tables
subbu - 5 Apr 2006 6:18 PM - 4 messages
I have attached two query plans , which are generated by Production server at different times (1 day apart). ( i could not send mail with attached plans I had to remove them) Same query I have executed every day over two weeks time to see how the ...
Score Disk Configuration
cbrichards via SQLMonster.com - 5 Apr 2006 4:46 PM - 2 messages
Are there any scripts or commands, or GUI interfaces that let you know if your disk drives are configured for RAID 1, RAID 5, etc.? How is one to walk into a shop and find this knowledge if the network admin is unavailable? ...
Score Re: Collation
amish - 5 Apr 2006 4:34 PM - 3 messages
use Rebuildm.exe and specify collation , SQL Server will build master database with new collation. Regards Amish Shah ...
Score using the LIKE statement
Johnfli - 5 Apr 2006 4:08 PM - 5 messages
I  have a table in my SQL7.0  (yes, it is on an old NT4.0 box)   where I can run the query SELECT     * FROM   TABLENAME WHERE     RecDate LIKE '11/2%' ...
Score SQL Server 2000 Transactions Logs
Naidu.Kanakala - 5 Apr 2006 4:01 PM - 3 messages
I am running on SQL Server 2000 and my database size is becoming very huge. My Database_Data size is 25Gb and Database_Log is 32GB. Here my worry. I used to get them to small size whenever I perform dbcc shrinkfile ...
Score monitoring deadlock
Vikram - 5 Apr 2006 3:19 PM - 2 messages
On production we r having lot of deadlock errors. How can i monitor this and identified sps creating this havoc... ? ...
Score Collation
Seelan Raja - 5 Apr 2006 3:03 PM - 3 messages
Hey guys, How do I 1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_iso charset_num=1 sort_order_num=52 on the master database and rebuild it 2. Dictionary Order, Case Insensitive. ...
Score SQL Logs
Bad Beagle - 5 Apr 2006 3:02 PM - 8 messages
What rights does a user need to view sql logs?  I do not want to put Outlook on the server to mail logs. ...
Score error 1053 when try to start mssqlserver service
shahab - 5 Apr 2006 2:19 PM - 2 messages
I have a two node cluster. When I try to failover from active node which is node2 to node1 I get the following errors in the event viewer/ system logs The MSSQLSERVER service failed to start due to the following error: ...
Score URGENT! SQL 2005 Query Analyzer
Ed - 5 Apr 2006 2:06 PM - 6 messages
How do i start the query analyzer? Where is it? How do get to the Database Admin? This is urgent if any one can help please. ...
Score Execution Plan
Praveen - 5 Apr 2006 1:11 PM - 2 messages
I saw the word ORDERED FORWARD In Execution Plan. What it means?. Regards ...
Score SQL 2005
Ed - 5 Apr 2006 1:11 PM - 2 messages
How do i get to and start the Query analyzer in SQL 2005 ??? How do i get to the web interface if there is one ? What is the Default site? Basically a tep by step do this would be great. ...
Score Number of Processor
Praveen - 5 Apr 2006 1:09 PM - 2 messages
How do i find out number of processers are attached to the SQL Server Box from Query Analyzer?. ...
object_id function returns null
Global search on a databse
storing data in deffrenet domain db server
Backup db files
Do we have the BCP's functionality embed within Integration Service?
Can DISTINCT or similar, be used on an indiviual field?
SQL 2005 Job running too long
is it possible to..
TLog size and performance.
Restore to different version of 2003 OS
SQL HOTFIX 2187 URGENT!
sp_defaultdb
High Volume of Net Traffic coming from MSSQL
Update table with DTS
Index question
RE: Parallel execution of DTS steps.
EXEC WITH RECOMPILE
Indexing
Urgent -- Questions on different SQL versions.
database and log backup
SQL Server Upgrade to 2005 + Hardware
cross database insert
Indexes and Statistics
Sql connections?
Object variable or With block variable not set
Moving sysdbs in sql2005
Can SQL 2005 Backup to a different file name each night?
high CPU time and sql 2000 getting slow performance
++++ Cannot install SP3 for SQL 7 ++++
Time complexity of index creation on pre-sorted data
Distributed queries
Restore Db
Replication Model
can't retrieve data using app
Restore SQL database
Question on SQL
Good idea or not to enable write caching ..
Checkpoint
Why alt_optname is shown when certain dboptions are set?
What is the fastest way to transfer records from Oracle to SQL Server?
Problems getting 200 SPs to work in 2005...
Job order
Maintenance Plan - Delete Old files...
Stored procedure question
sleeping threads?
Does NEWID() affect my insert performance?
8.0 compatibility question
Reporting Server - 2nd SQL Server
<<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>
EM frozen when viewing tables
Looking for a suggestion
Copy Database Wizard
How to disable trace
Job History Logs
Randomizing an existing number
xp_unc_to_drive
Transactional Replication
SQL 2005 temp tables in tempdb won't delete?
nvarchar and varchar
Help - Simple Question
OPTION (FAST n)
Negative run time results from running SQL Transaction log backup
Tables Last Accessed
MS SQL2000 - synchronizing tables across two sql servers - wasting my time?
q: export DTS
Seek Operator in Execution Plan
Problem Using INITCAP function
Experiences with SQLIOStress
IF funcionality in SQL server views
deadlock problem
urgent: time log
Install SQL 2000 Enterprise on a member server
How do I know if a column is updated?
Can not start server after setting open objects to 2147483647
Consistency error in sql2000
fn_virtualfilestats results
Creating New Empty Database
What is wrong with this query?
firewall ports open for tcp/ip connection on server
import through DTS
Dynamic SQL in Cursor
SSMSE on sql server 2005 express
Next »