|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
how to resolve deadlock issues
pardhi via SQLMonster.com -
28 May 2005 2:34 PM - 6 messages
Hi Can anyone help by telling how to resolve deadlocks step-by-step. I guess atleast some one is good in deadlocks. Thanks P ...
Performance dropped after upgraded to MS SQL 2000
John -
28 May 2005 1:18 PM - 3 messages
Dear all, Last Saturday, I upgraded my SQL 7.0 database to SQL 2000 Standard Edition succesfully. I also executed "sp_updatestats" and reindexed all the databases, but I found the server's overall performance is worse than before. That means SQL 2000 is slower than SQL 7.0, why ? ...
Linked Server "NOLOCK" problem on SQL 2000
John -
28 May 2005 1:07 PM - 4 messages
Dear all, My current configuration : Windows 2000 Server + MS SQL Server 2000 Standard Edition + Service Pack 3 I got an error when I used "NOLOCK" in selecting some records through Linked Server : SELECT * FROM TKOA_LINK.sales_data.dbo.sales_tran (NOLOCK) Error : ...
List all the logins that have a certain privileges
Frank -
28 May 2005 8:21 AM - 3 messages
Hi, I would like to know how to get all the login names in a server that have a certain privilege. Such as I want to get all the logins that have an update privileges to a table. Thanks in advance ...
Log shipping question
Bill Wang -
28 May 2005 5:25 AM - 2 messages
My company is embarking on a DRP project where we will move our production servers to a less geographically insecure area. We'll need to perform log shipping back to our DRP site. I know that SQL Server logs index rebuilds or index defragmentation and that ...
Windows cannot open this program since it has been disabled.
John Smith -
28 May 2005 3:49 AM - 5 messages
is this really true? that you can not install a sql 2000 on windows 2003 web edition? ...
Differential and Transaction backup restore.
Steve Martin -
28 May 2005 1:24 AM - 7 messages
Differential and Transaction backup restore. I have scheduled differential backup to run at 3PM and the transactional backup to run at 3pm. In the event of data restore work, should I restore the data from differential as well as transactional backups. ...
SQL brain twister
Rod via SQLMonster.com -
27 May 2005 10:00 PM - 7 messages
Intersting problem here. SQL Ver 8.00.760, XP Pro Ver 5.1.2600, Virus protection disabled, Norton GONE, Windows data management shut off for involved files. No big brother anywhere I can see. I am still getting data ...
Maintanence Plans for Backups
Jerry Spivey -
27 May 2005 9:06 PM - 4 messages
Hi, I'm about to setup several backup stategies for several different SQL Servers. I'm planning on using Full and T-log backups for the databases using Maintanence Plans. I've been advised not to use Differential backups ...
Error 21776 [SQL DMO]
Newbie -
27 May 2005 9:00 PM - 4 messages
HELLO, I have a bunch of users I need to change their defult db's and grant access to that db, so I run the following script: EXEC sp_defaultdb 'CGallego' , 'CRCS' exec sp_grantdbaccess 'CGallego', 'CGallego' When I go into EM to view their properties, I get the following error message: ...
SQL Server EM/Query Analyzer Access
dm4714 -
27 May 2005 8:59 PM - 4 messages
Hello -- we have SQL Servers running in a Service Bureau environment. How clients frequently use applications at their sites to access our SQL Server. Unfortunately, some of our clients are more sophisticated than others and know about Enterprise Manager and Query Analyzer, which they can try and use ...
Process ID 51 attempting to unlock unowned resource PAG: 7:1:46563
Alpha -
27 May 2005 8:56 PM - 2 messages
I got this error message in my TSQL code. Can someone tell me what is this about? update tblSource_info set LocalUse = cast(tblPCS.why_med_necessary as varchar(100)) from tblSource_info inner join tblPCS on tblSource_info.extTID = tblPCS.extTID Process ID 51 attempting to unlock unowned resource PAG: 7:1:46563. ...
Re: Strange problems accessing SQL server with windows 2000 window
Mike Allen -
27 May 2005 8:55 PM - 3 messages
I'm having same issue. My XP client can connect to SQL using TCP/IP while 2000 can only connect with Named Pipes. Both client computers are in same domain as the SQL server. Any ideas? ...
RE: Converting Pervasive SQL2000 SP3 To MS SQL2000
japson -
27 May 2005 8:50 PM - 2 messages
Can some one please answer this question? Does anyone know of way to convert a Pervasive SQL2000 SP3 database to a Microsoft SQL2000 database? ...
blocking alerts
ChrisR -
27 May 2005 6:54 PM - 5 messages
Is there a way to create an alert when a query is blocked for however long I choose? I know I can query the SysProcesses table but that will just tell me who is blocked right now, not who has been blocked for say 60 seconds. ...
Error 15401
Scott Peron -
27 May 2005 5:32 PM - 2 messages
Hi folks, When using the "Enterprise Manager" to add logins to a SQL Server instance, I'm running into an error 15401. Before I get too far, let me describe the environment I'm doing this in: We have two domains: ...
Sql server slow down
Ayaz -
27 May 2005 5:28 PM - 3 messages
Hi All, I have a Windows 2000 machine running sql server 2000 at office. Recently, my sql server has become painfully slow. To give an idea, entering Query Analyzer takes 1 min just to establish a connection with the database. ...
Veritas Backup Exec. 9.1 SQL Agent - Use of...
Jerry Spivey -
27 May 2005 5:19 PM - 7 messages
Hi, Anyone currently using the Veritas Backup Exec. 9.1 SQL Agent for doing SQL Server 2000 backups? The environment I just inherited is using the Veritas software for daily t-log backups and weekly full db backups. However the SQL Server is also ...
SQL SCAN TOOL
docsql -
27 May 2005 4:14 PM - 4 messages
Is there a tool to scan for SQL (any version) and that will also return the service pack information. ...
Minimum level of rights for a SQL Server DBA.
MZeeshan -
27 May 2005 4:05 PM - 4 messages
Previously, DBAs in our company used to have local machine administrator access on the SQL Server boxes. As part of tightening server security, those rights have been taken away from DBAs (in some cases they have been added to 'Power Users' group). ...
Torn page detected but can't find problem
Steve -
27 May 2005 2:32 PM - 2 messages
We received an alert this morning "I/O error (torn page) detected during read at offset 0x0000000203c000 in file 'd:\data\data\CFS_Data.MDF" then about 20 minutes later, "I/O error (bad page ID) detected during read at offset 0x0000000203e000 in file 'd:\data\data\CFS_Data.MDF'.." ...
SuperSocket Info: Bind failed on TCP port 1433
Michael Primeaux -
27 May 2005 2:24 PM - 2 messages
Hi everyone, I just started seeing this problem several days: Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17055 Date: 5/26/2005 Time: 5:14:34 PM User: N/A Computer: NPCOMPLETE Description: ...
BackLinkLogBlockReadAheadAsync?????
J Jetson -
27 May 2005 1:13 PM - 3 messages
Looks like we have a disk error but I am not sure? Has anyone dealt with this before? ServerA0134: 17053 : LogWriter: Operating system error 1117(The request could not be performed because of an I/O device error.) encountered. ----------------- ServerA0134: 5159 : ...
store procedure error
anoni -
27 May 2005 12:04 PM - 4 messages
I have someone created a store procedure in our database (on server A). When the procedur runs, it transmit info from server A to server B (on a differer database). It ran for a while, now it stop running. I get this error when I ...
Urgent Help -- Locked Table
G Q -
27 May 2005 11:28 AM - 4 messages
Urgent: SQl Server 2000 I have a table that got locked. I tried to kill the SPID that is still running to insert into this table, But the table is still locked and I could not kill the Process. Any Idea? The lock is being there for over 5 hours. The last transaction was ...
SP4 problem
Shriram -
27 May 2005 10:25 AM - 3 messages
hi i have install SP4 and it's get install successfully but after installtion i am not able to connect to SQL through any asp code with DSN support following error which i got Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
Job Failure
Jason -
27 May 2005 10:17 AM - 8 messages
From the job history, we find that a scheduled job has failed after we have updated the structure of some tables. We would like to know what is the best way to find out what causes the failure ? Is there any built-in error log ? ...
dbcc inputbuffer: looking for the actual statement
Strider -
27 May 2005 8:08 AM - 3 messages
Hello all, Is there a way to display (using TSQL) the actual statement that a SPID is executing? When I use dbcc inputbuffer(SPID) all I ever get is "sp_executesql;1" :-( Thanks PS: I cannot use the profiler ...
Query with sub-query still returns unexpected results
Rossco -
27 May 2005 5:43 AM - 2 messages
Hello All! Thanks in Advance. Have the following query which continues to return duplicate results. Any help would be appreciated I have also tried a not exists version (below also). SELECT distinct RTRIM(CAST(STRM AS char(4)) + CAST(CLASS_NBR AS char(6))) AS ...
Page Checksums?
DavidMA -
27 May 2005 4:16 AM - 5 messages
Hello, Does SQL have any sort of checksum value attached to each 8K page or is there a feature we can turn on to enable such a checksum? I'm trying to optimize our block data synchronization product specifically for SQL ...
Transaction log
DJ -
27 May 2005 3:04 AM - 5 messages
I am using SQL server 2000. The transaction log of one of it's database is growing rapidly and now it is 12GB. I tried to reduce it by shrinking but nothing happend. How can I remove its records and reduce it size? ...
DBCC INDEXDEFRAG and Transaction Log
Bill Wang -
27 May 2005 3:00 AM - 3 messages
Hi, Today I met a problem with DBCC INDEXDEFRAG on SQL Server 2000 Enterprise with SP3. I run DBCC INDEXDEFRAG on a table with only one primary key. The size of the table is about 120MB, the size of the index is about 1.6MB. ...
Storing Files as Blobs vs using File System ?
acs68 -
27 May 2005 12:18 AM - 5 messages
Hi all, we have a pretty important decision to make. We are looking at converting our Records System (EDMS) to a new SQl Server version that will store all files as BLOBS rather than how it is currently being done - storing all the files on the fileserver in a docs folder. ...
x64 testing
Brian Mitchell -
26 May 2005 11:25 PM - 2 messages
Ok, I got a hold of a 64 bit test box. It has 8 gig of memory. I can swap out a set of hard drives with the 32 bit operating system installed, so that I can literally test apples to apples. Now here is the question, how ...
SQL Server utilizing 100% of CPU
JLDominguez -
26 May 2005 10:09 PM - 3 messages
During a load process which uses cursors to validate, parse and load data, the CPU utilization hits the roof. I've run profiler for the period in question, however, the profiler only displays 0's on the CPU column. It does ...
How Does SQL Server 2000 Update
cksj -
26 May 2005 9:34 PM - 3 messages
I'm trying to find out how SQL 2K update records. In the past I thought that the record is deleted and then inserted with the changes. One of my colleagues said that the page of the record that change is deleted and the ...
No paradox in DTS of 2005
ad -
26 May 2005 9:23 PM - 2 messages
I can't migrate my paradox to SQL 2005. I can not find paradox item in the data source. There is Paradox in Sql 2000. How can I do with SQL 2005? ...
SQL Log reader APIs
Satish Balusa -
26 May 2005 9:22 PM - 3 messages
We have situation where we wanted to write our own custom application to read, filter and export data from the SQL Log. Are there any Public / Private or Documented /Undocumented APIs that we can make use. Any information in this regard is appreciated ...
Torn Page Detection
Joe K. -
26 May 2005 9:08 PM - 4 messages
I have a production database that processes 600 transaction/sec. and 300 concurrent users. This is a SQL Server 2000 Enterprise Edition database in a cluster server with Windows 2003 server. This is database size is approximately 300 GB. ...
splitting a database
Richard Cranium -
26 May 2005 8:52 PM - 4 messages
Hello, Where can I begin to research splitting up the load for one database across multiple servers? We have a website in IIS that uses a SQL Server database. The website could have up to 500 concurrent users and we want to employ multiple servers to ...
SQL Mail Setup
Jerry Spivey -
26 May 2005 8:20 PM - 8 messages
Hi, I'm taking over a SQL Server environment that currently is not configured to email operators. I'm looking to configure SQL Mail for the SQL Server so that I can receive email notifications for jobs and alerts. Reading through ...
Why register a SQL Server in Active Directory?
Jeffrey Sheldon via SQLMonster.com -
26 May 2005 8:09 PM - 2 messages
I read BOL I read my SQL bible and I just do not get the reason as to why you want to register a SQL server in active directory. Can someone put this in plain english? Jeff ...
moving tables and index to different filegroup
Data Cruncher -
26 May 2005 8:06 PM - 7 messages
I need to create a script to move all tables and indexes to a different filegroup after all tables and indexes are created on the primary. The reason being we don't have license to the code and we all always get ...
Why Should I keep using SQL2000 and not 2005
Lottoman2000 NEWBE -
26 May 2005 7:39 PM - 4 messages
Hi, Many of our IT people are riding the wagon and saying 2005 will bring peace and tranquility to the world :). I argue that i dont see the major gains i get from 2005 that should compel me to use it. I am building .NET application ...
text in row
Jeffrey K. Ericson -
26 May 2005 7:33 PM - 6 messages
How do I know what the current settings are for a table containing an ntext column convering text in row? sp_tableoptions seems to only set not report. I need to see if I can reduce the amount of storage an ntext column is using. ...
Unlocking tables during snapshot generation
Leon Shargorodsky -
26 May 2005 7:13 PM - 2 messages
My goal is to be able to access and modify data in tables while Replication generates the initial snapshot. Is there a way to achieve this? I tried to set @sync_method = N'concurrent' in sp_addpublication, it doesn't work: my insert, update and delete commands do not go through until snapshot ...
Group by is not the same as MySQL
UGH -
26 May 2005 7:06 PM - 5 messages
Group by is not the same as MySQL I am migrating some of the query from MySQL to MS-SQL. I am stump on group by clause and I would need your help. It may not be possible in MS-SQL and I ...
question on memory
ChrisR -
26 May 2005 7:04 PM - 3 messages
Win2K Advanced Server SQL2K Enterprise I need to set up 1 big fat Disaster Recovery box for my 6 production boxes. I will do this by putting 6 instances of SQL on the DR box. I know that there is an 8 gig max (using AWE) limit. But what I don't know is can each ...
Roles/Permissions
jmeyers -
26 May 2005 6:54 PM - 2 messages
I'm wondering if it's possible to set up a database role that will allow the users in the role to apply stored procedures to a specific database, but not do anything else. Any help would be appreciated. ...
changing logical filename
Aron E. Tekulsky -
26 May 2005 6:52 PM - 6 messages
I have a database called test. it has 2 logical files : test_data, test_log. they are in the following physical files: test_data.mdf, test_log.ldf. I make a backup of the database test. I wish to make a copy of the test database with a different name on teh same ...
SQL insalled in Case sensitive collation mode
Kenneth -
26 May 2005 6:15 PM - 3 messages
I think this should be a simple question. All I need to know is how I can tell is SQL server is installed in Case Sensitive collation mode or not. ...
Row lock - Hold Lock
DXC -
26 May 2005 6:03 PM - 6 messages
If I issue a Rowlock and holdlock statements in my select statement, would it still escalate to pagelock or tablelock or it would keep the rowlock until the transaction is done ?. Thanks. ...
can TLog backups cause blocking
ChrisR -
26 May 2005 5:28 PM - 9 messages
I just had tons of blocking in my DB. I tracked down the culprit and killed the spid... mistakingly without running dbcc inputbuffer first. So I the looked in the error log and am 99% sure that what I killed was a TLog backup ...
Delete Duplicate
MS User -
26 May 2005 5:13 PM - 8 messages
SQL 2K I got a table 'DptAct' having 3 million rows with columns - ID, DPTID, NAME, SUPVR, MOD_DATE I want to retain just one row for unique (ID, DPTID) combination, doesn't matter with values of rest of the columns. ...
Return Code Not Capturing an Alter Database Failure
tom frost -
26 May 2005 5:04 PM - 2 messages
I'm trying to apply the following code into a proc I have and wanted to check for the success of the alter database stmt. @@error didn't trip to <> 0 and then tried placing a return status code variable after the execute stmt and ...
transaction log growth
Zeng -
26 May 2005 4:59 PM - 5 messages
Hi, I'm using SqlServer version 2000.80.760.0 and wondering when the last time the transaction log file grows in size. Is there a way to get that info? Thanks! ...
autoshrink causes "Could not complete cursor operation...table schema changed"
A Mackie -
26 May 2005 4:45 PM - 5 messages
I've had a report that turning on autoshrink causes the error "Could not complete cursor operation because the table schema changed after the cursor was declared" Has anyone saw this before ? If a maintenance plan to re-index kicked in during some long running process ...
Is it possible to conditionally skip steps in a job?
Dave -
26 May 2005 4:42 PM - 4 messages
Is it possible to conditionally skip or jump steps in a job without failing a step? For example I don’t want to run a step if the are no records in a table. I also need to loop based on a condition. ...
Using EMC Clariion Database Storage Solutions with Microsoft SQL Server 2000
Delton Blackwell -
26 May 2005 4:41 PM - 2 messages
I was just wondering if anyone was using EMC Clariion Database Solutions with MS SQL 2000. What successes and/or failures have you experienced? ...
Scheduling the process
Helen Stein -
26 May 2005 4:37 PM - 3 messages
Hello I need to run stored procedure once a day. Is there any way to schedule this process inside the database so it is done automatically? Thanks in advance, Helen ...
table exist
Big D -
26 May 2005 4:36 PM - 3 messages
Lets say I have a tablename Flags. How can I check for an existance of that table? I need to validate a table in vbscript before continuing. ...
ASP - Connection to second instance
Mindy Leslie via SQLMonster.com -
26 May 2005 4:02 PM - 2 messages
I have a second instance set up for a sql server. I'm going crazy trying to determine the syntax for the connection string for my ASP program. Please help Mindy Jeanne Leslie ...
DTS in Sproc help....
j c via SQLMonster.com -
26 May 2005 4:00 PM - 5 messages
I have been trying to schedule a DTS package that executes perfectly fine when fired with Enterprise Manager. However, I need this package to run during a run-time process inside my application. So, I have added the exec ...
Feature Questions...
Hal Levy -
26 May 2005 3:26 PM - 3 messages
On: [link] There are lots of numbers in the chart, indicating there should be footnotes.... However the page does not have the footnotes on it! I am trying to compare versions for a client- and one of the features, ...
Errors 5105-5170 when creating large datafile
Dale M. -
26 May 2005 2:53 PM - 3 messages
Greetings. We recently added a second RAID array to our four-way server to add another filegroup to our 400GB database. Using SQL EM, I tried adding a new 400GB data file to a new filegroup on this new array. It ran for about 12 hours ...
Questions on Clustered Index.
MZeeshan -
26 May 2005 2:46 PM - 5 messages
We are using a third party product. It has a central table with a primary key propagated to other tables through identifying and non-identifying relationships (for instance, Personnel system can have EmployeeID, Inventory System ... ItemID, Salers System ... OrderID, etc.). ...
Add Preceeding Zero
box2003 -
26 May 2005 2:40 PM - 3 messages
I have a field in a table, datatype is varchar. The field contains values such as, 1000000, 1000003, 5000001 (Left most position is always > 0). I want to change the field to precede all field values with 0 to yield, ...
Extended Procedure
Lijun Zhang -
26 May 2005 2:36 PM - 2 messages
Does anyone know any undocumented extended procedures that can red SQL scripts from a text file and execute it. The SQL scripts contain multiple batches (contain key word 'GO', which will not be recognized by the regular EXECUTE statement). Thanks, ...
Visibile Operating System Command within a SQL Agent Job
mjhbell -
26 May 2005 2:17 PM - 4 messages
I have a requirement to see the relevant DOS window when I call a cmdexec command from a step within an Agent Job, is it possible to echo this to the screen? Thanks, Mike Bell. ...
AVOID merge joins
Jan -
26 May 2005 1:54 PM - 3 messages
Hi, Does anyone know of a way to AVOID merge joins? I have a complex query that works fine on one system, but not on another. After inspection, I found that the difference lies in different query plans generated by the query optimizer. On the failing system, a merge join is ...
Help: Backup Question
Robert Lie -
26 May 2005 1:44 PM - 6 messages
Dear All, Does anyone can help me up to answer the question below: ============= You are the administrator of a SQL Server 2000 computer The server contains a database named Sales that has two data files and one transaction log file. Each data file is located on its own hard disk and ...
Profiler Issue
DXC -
26 May 2005 1:26 PM - 3 messages
When I was running profiler I got the following message in profiler. Some trace events have not been reported to SQL Profiler because the server has reached its maximum amount of available memory for the process. I was only running 4 columns: Event Class, Duration, SPID and Text Data. ...
Query Help
URG -
26 May 2005 1:20 PM - 3 messages
Hi all, I have one ‘tall’ table that records the following on a regular basis: STATE SERIAL# DATE ====== ======== ======== VA Z32WE12 12/31/2003 ...
Help: Question of 70-228
Robert Lie -
26 May 2005 12:34 PM - 3 messages
Dear All, Please take a look the question in attached file. I need your help, what is the correct answer for it. Thanks a lot Robert Lie ...
Help (question from 70-228)
Robert Lie -
26 May 2005 12:24 PM - 2 messages
Dear All, I need your help to answer this question below: ====== You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. A company e-commerce application uses the Sales database to store sales transactions. The ...
Cannot shrink transaction log - windows 2003/sp1 and SQL 2000/SP4
Sabo, Eric -
26 May 2005 11:24 AM - 6 messages
I cannot shrink a transaction log to a database through the enterprise mmc. This particular transaction log is about 135 GB and is filling up the hard drive. Is there a way to force this? ...
Query performance
Sanjay -
26 May 2005 10:25 AM - 4 messages
Can anyone tell me if there‘s a difference how the queries below are treated by the optimizer Select A.cmpcode, B.cmpcode From dbo.oas_docline B Join dbo.oas_dochead A ...
Date Time Format
Jason -
26 May 2005 9:53 AM - 7 messages
Hi, By using Convert(Char(12), DateTime, 103) we are able to get the date in dd/mm/yyyy format. We would like to know is it possible to convert the datetime in the format of dd-mm-yyyy AND dd-mmm-yyyy ? ...
report manager e-mail
joia -
26 May 2005 9:07 AM - 2 messages
If I schedule a report in the Report Manager, can I also do this if I run Novel Groupwise instead of Exchange Server ? ...
sqlserve 2000 sp4 install problems on win xp sp2 + security updaye
David Fillmore -
26 May 2005 8:57 AM - 3 messages
Hi, I have installed sql developer edition on a windows xp machine which has sp2 plus all security updates. When trying to apply sp4, the update exits with and error when the sql scipts are running, the script which caises the ...
SQL Server Performance
mymobile -
26 May 2005 8:18 AM - 7 messages
I have a SQL Server Standard version running on Windows Server 2003 Xeon 3.06Ghz and 1GB Ram. However, querying 4 million records takes a lot of time. I examined the bandwith and processing load and seems to be very low. What ...
Error: [Microsoft][ODBC SQL Server Driver] Timeout Expired
Syed -
26 May 2005 7:19 AM - 2 messages
I am getting above error msg when I tried to run my View. The view have 12 tables and 20 joins, which tells you the complaxcity of the view. When run this view using Query Analyzer it gave me the above ...
Slow backups after upgrade to Windows Server 2003 SP1
Jonathan Levine -
26 May 2005 6:56 AM - 5 messages
Greetings, I recently upgraded a server to Windows Server 2003 SP1. The server is running SQL Server 2000 SP4 and ARCServe 9.01 SQL Agent. Transaction Log Backups on this server have slowed down by about 50X. ...
Cluster Failed after apply Window2003 SP1 - Urgent Pls. Help!
Henry -
26 May 2005 5:18 AM - 3 messages
Dear Sir/Madam, After applied the Win2003 SP1 on the passive node(e.g. Node B), the cluster can't be up on Node B any more. The scenrio is as below: When Node B restart, 01)It will trigger failover from Node A <Active> to Node B <Passive>. ...
performance problem with MSDTC Transaction
chinn -
26 May 2005 3:22 AM - 3 messages
Hello, We are having a blocked processes problem,then we see sp_who2 active then it's blocked by spid is -2...I know it's a MSDTC transaction.But is there a way to see the sql behind the transaction..we cannot see the sql behind ...
cannot start sqlserver agent - urgent
00allen_iverson -
26 May 2005 1:27 AM - 4 messages
I cannot start the sqlserver agent neither manually or automatically and I get this message in the event log: SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start). Can anyone please help? Thanks. ...
determine whether Index/Table spans multiple files within filegroup
imarchenko -
26 May 2005 12:16 AM - 9 messages
Hello! I was wondering if there is an easy way to determine whether index/table spans multiple file within the same filegroup. Thanks, Igor ...
SQL restore for dummies
EMcGrath@HCA_NOSPAM_Vendor.com -
25 May 2005 11:39 PM - 2 messages
I am not a SQL admin, however I need to document the restore of a SQL2000 enviornment for my disaster recovery testing. I am just a lowley network administrator. Does anyone have any suggestion and documentation they can point me toward ...
Return only first record found
Paul -
25 May 2005 11:03 PM - 14 messages
Just wondering if there is a way to return only the first record found, for example I have a table like ****table1************ * int first * int sec * ******************** * 1 * 4 * ...
Query Analyzer
nick -
25 May 2005 10:23 PM - 2 messages
Hi all: how to change the setting that not showing system table and sp int query analyzer? Thanks Nick ...
BULK INSERT - Urgent
Sanjay -
25 May 2005 10:20 PM - 3 messages
I have a tab delimeted file which i BCP into a temp table using BULK INSERT When i use DTS Transform data task i get all 7000 records in the table In DTS data transform i choose Column Delimeter is a tab ann row delimeter ...
forced restore
Rich -
25 May 2005 9:27 PM - 5 messages
What does the field "Logical File Name" mean in the Restore Database Screen? If I use Forced Restore, does this not place the database INTO the database I am restoring to including the current physical file paths? ...
Newbie: Help with csv Import and duplicates
steve -
25 May 2005 8:55 PM - 3 messages
Hi, I seem to have * A LOT* of problems importing data into my DB. I know that this is SQL Server and it's supposed to be picky and check everything but this is getting too much .... I have the following table: ...
ballpark time for shrinkfile
J Jetson -
25 May 2005 7:37 PM - 6 messages
After completing some intensive DB maintenance I would like to shrink a 400GB database with 200GB free space. I am looking for a ballpark figure for how long something like that would take on a standard 2CPU 8MB RAM server. If ...
All DB ops hangs in sql2000
Mangesh Deshpande -
25 May 2005 7:37 PM - 2 messages
Hi We have a warehouse fact table with millions of rows. When we run a report that select massive amount of data all the queries against that table hangs. We checked there were no outstanding transactions against that table. Any ideas what it could be. ...
database modes in sql server 7
Mangesh Deshpande -
25 May 2005 7:35 PM - 5 messages
Hi Can some one give me a quickly if we have a FULL Mode in SQL server 7? I do not see anywhere mention of Mode of the database unlike in sqlserver 2000. Tks Mangesh ...
another xp_smtp_sendmail question
ChrisR -
25 May 2005 7:28 PM - 6 messages
A snippet from [link] says: How To Set Up SQL Mail With An Internet Mail Server WARNING: Unless you can guarantee 100% connectivity to your Internet mail server without the need to reauthenticate your mail logon, SQL Mail can ...
sp_stop_job
Mark -
25 May 2005 7:17 PM - 3 messages
sp_stop_job allows you to stop a job, but how do you programmatically check if the job is actually running BEFORE calling the stored procedure? It raises an exception if it bombs. sp_help_job provides information, but you have to call it manually and read through the results. I'm looking to ...
error 37000
ft -
25 May 2005 6:21 PM - 2 messages
I tried to run my application linked to sqlserver DB. Iobtain this message : Erreur d'exécution 40002 37000 : [Microsoft][ODBC SQL Server Driver] [SQL Server] the log file for database "app" si full. Back up the transaction log for the database to free ...
|
|||||||||||||||||||||||