|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Should we change the maintenance plan ?
Peter -
17 Mar 2007 9:08 AM - 2 messages
Just learn that SQL Server 2005 SP2 includes the cleanup task in the maintenance plan wizard. Is it necessary for us to create a new maintenance plan that include the cleanup task or just keep using the existing one (Clean up task already ...
XML datetime conversion
Looch -
17 Mar 2007 1:55 AM - 3 messages
Hi All, I have a column that I need to convert to a datetime datatype (format doesn't really matter). The column's datatype is nvarchar(255) in the '2006-12-12' format. The table originated from an Access table that ...
Creating Database
Michael Mastro -
17 Mar 2007 12:05 AM - 7 messages
I have a question that I am hoping someone can answer. Is it possible to link external sources to a database? What I am wondering is, that if I am creating a music database for CDs, can I program it so that the database ...
Rebuild Index Failing
John Oberlin -
16 Mar 2007 9:40 PM - 4 messages
The SQL Server 2005 (9.0.2047) 'Rebuild Index' maintenance plan task is failing. The text file report is of very little help... Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2047 Report was generated on "SQLSERVER". Maintenance Plan: Weekly All DB Maintenance Plan ...
Deleted row information cannot be accessed through the row
Hang -
16 Mar 2007 9:31 PM - 2 messages
Hi, I got following exception when accessing database using release version of my C# application: System.Data.DeletedRowInaccessibleException: Deleted row information cannot be accessed through the row. at System.Data.DataRow.GetDefaultRecord() at System.Data.DataRow.get_Item(String columnName) ...
MSDE limitations lifted in Express?
William Bernat -
16 Mar 2007 8:35 PM - 5 messages
8 connection limit, 2GB file size limit in MSDE? What are the limits in the capabilities of SQL Express? -billb ...
SQL Query for Dummies
tyrone_bak -
16 Mar 2007 8:01 PM - 2 messages
SELECT PERS_ROLE_HIST.ASGN_TS AS [Assignment Date], Trim(Pers.lst_nm) +" ,"+Trim(pers.fst_nm) AS Name, DIV.DIV_NM AS Division, PERS_ROLE_HIST.AUTH_REQ_ID AS [Order #], ROLE.ROLE_CD, PERS_ROLE_HIST.ASGN_TS, PERS_ROLE_HIST.UNASGN_TS, PERS.TERM_DT, PERS.PERS_ID FROM ROLE INNER JOIN ((PERS INNER JOIN DIV ON PERS.DIV_NBR = ...
Adventures with 64 bit SQL servers and legacy systems
Kristina -
16 Mar 2007 7:15 PM - 3 messages
First of all, thanks to everyone who helped me figure out how to run a legacy DTS with a 32 bit driver on a 64 bit server. In case anyone else has this problelm, you also have to download this from Microsoft: ...
32bit SQL Server on Win2003 64bit server?
kstjohn -
16 Mar 2007 7:13 PM - 3 messages
Does this work? Without an ODBC connector (MSDASQL) for the 64 bit version I'm stuck downgrading to be able to access data from some appliances the use MySQL. If I can get away with only moving to a 32bit version of SQL Server ...
examining server actions while running a query
LdsPaulF -
16 Mar 2007 5:27 PM - 11 messages
Hello, I'm having some trouble explaining the performance difference I'm seeing in a couple of queries. I'm running against an XP Pro desktop installation of Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86) Mar 2 2007 20:01:28 ...
SQL 2005 to SQL 2000 Database Help Needed!
Richard K -
16 Mar 2007 4:43 PM - 4 messages
I have an application that was using a database running on SQL 7 with no problems. The vendor said they supported SQL 2005 so we did an upgrade only to find out there are bugs and we need to revert back 1 version to SQL 2000 ...
SetOpts value in sys.syscacheobjects
cbrichards via SQLMonster.com -
16 Mar 2007 4:08 PM - 5 messages
When I filter for just ObjType = "proc" in sys.syscacheobjects I return the following SetOpts: 155 171 187 235 251 258 763 I have searched BOL, and see that the SetOpts options include the following: ANSI_PADDING FORCEPLAN CONCAT_NULL_YIELDS_NULL ANSI_WARNINGS ANSI_NULLS ...
save web page via DTS
Jack Vamvas -
16 Mar 2007 3:59 PM - 3 messages
How can I recreate from within DTS (slq 2000) ,the equivalent of Save As in an Internet Explorer? So, typically I would normally go to IE , File, Save As. I want to simulate the same but in DTS. Any advice would be helpful , ...
manually truncate a log
MSUTech -
16 Mar 2007 3:57 PM - 5 messages
I have a log.ldf file that has grown to around 150 GB ... I can't really do a BACKUP of the database to truncate it..... it seems to struggle with that.... is there another way that I can MANUALLY truncate this log file? ...
SQL Server backup file locking
Ola Hallengren -
16 Mar 2007 3:30 PM - 3 messages
Hello! I have some jobs that are performing sql server backups to disk. Then I have one job that is copying a directory structure to another server using robocopy. The idea is that robocopy only should be allowed to copy files that are ...
parsing a dts step runs the sp
Dan D. -
16 Mar 2007 3:19 PM - 2 messages
Using SS2000 SP4. We recently discovered that if we create a step in a dts to run a stored procedure and then parse the syntax, it actually runs the stored procedure. I also tried to duplicate this behavior by putting a create table ...
Create User Account
Diane Walker -
16 Mar 2007 2:35 PM - 3 messages
We are running SQL 2000 Enterprise Edition under Windows 2003 Standard Edition server. How do you create an account for READ access only to the database? How do you test this account after creating it? Thanks. ...
How to import data from a .csv file
fhamelly -
16 Mar 2007 2:20 PM - 3 messages
I'm a SQL newbie and am wondering what is the correct procedure to import data from .csv file into a SQL table. I want to electronically clear checks in MS Dynamics GP and need to update one field in the ...
True False 1 0 Yes No?
David Lozzi -
16 Mar 2007 2:12 PM - 3 messages
Howdy, Ok, this may be a novice question but its driving me nuts. In SSMS, bit columns appear as True and False, but when I use them in a TSQL statement its 1 or 0, and then in my asp.net it can be either 1/0 or true/false. Can I ...
Total row effected for a day
Chinna Kondaveeti -
16 Mar 2007 1:57 PM - 4 messages
Hi, It may sound like crazy! But need to ask this question. Is there any way I can find out the total rows affected by any of the DML (S/I/U/D) commands within 24 hours? Trust me it is not my idea! My management wants to identify the activity in ...
SQL Server 2005 and Aggregation
Rahul -
16 Mar 2007 1:18 PM - 2 messages
Hi, I am currently running SQL 2005 SP2. I have a particular scenario in my e-Learning Application which is giving me performance problems. The scenario is that there is a Chapter the sample hierarchy is as follows: Chapter ...
Editing a view in SQL 2005
nomad -
16 Mar 2007 11:14 AM - 3 messages
Hi, I am currently running SQL 2005 SP2. When I right click on a view I have the option to Edit it, so I can then view any comments entered for the view. My colleague is also running SQL 2005 with SP2 but when ...
MS DTC problem
chris.hearson -
16 Mar 2007 11:06 AM - 5 messages
Hi, I've seen this problem posted before but never a solution. I have a .Net app that uses an ODBC connection to a SQL Server 2000 database (running on W2kSP4). Trying to enlist in a transaction fails with the ...
SQL Server 2005 - Generate Script
Senthilmurugan -
16 Mar 2007 10:11 AM - 8 messages
Hi, I attempt to create SQL Script for my database as follows: In "Microsoft SQL Server Management Studio Express" Object Explorer screen. "mydatabase"->Right Click -> Tasks -> Generate Scripts -> In the "Script Wizard" I don't see my database is Listing here. All ...
Shrinking a Database
Gonzo -
16 Mar 2007 9:48 AM - 2 messages
I'm a novice at SQL and I have a database that Is as follows: Tempdb: Total: 4gb Used: 1MB Free: 3.99gb I have tried to shrink it from Enterprise manager but it doesn't change, is there anything I can do via Query Analyzer? ...
Insert Duplicate row in Temp Table
shantanu -
16 Mar 2007 8:54 AM - 4 messages
Hi all My requirement is like I need to write a trigger which will compare the data with the existing one in the table and if the data is duplicate then insert the data into a temp table. ...
Moving logins
S -
16 Mar 2007 4:54 AM - 5 messages
Hi How can I copy or move the users from one SQL server to another? Is there a utility that transfer them or should I create one by one? Than'x SHay ...
Large database - unable to delete even 10 rows?
xuttah -
16 Mar 2007 2:55 AM - 4 messages
I have a table in a database on SQL 2000 Std. that has grown to over 314 million rows. I need to delete the vast majority of these, but as I expected Query Analyzer runs perpetually and I'm forced to cancel ...
Cannot open database "SharePointSharedServices" requested by the l
mg -
16 Mar 2007 12:48 AM - 2 messages
Environment: Windows Server 2003 SP1, SQL Server 2005 (no SP) Up until a few days ago a Maintenance Plan and a dependent job have started to fail with the following error. [298] SQLServer Error: 18456, Login failed for user 'XXXXX\yyyyyyyy'. ...
Table size
sean_mcad -
16 Mar 2007 12:38 AM - 4 messages
I have one table which has about 6 columns each containing very small data (most are an int with a value of either 0,1 or 2). I predict this table will reach 200,000 rows in 12 months. How many rows given such a "thin" table should I be concerned? I will not ...
Deferred Name Resolution gone wild.
Frank Rizzo -
16 Mar 2007 12:14 AM - 3 messages
I have a script that has a spelling error in the insert statement: insert #tempTable(id, statux) values (1, 'this is a test') This statement is deep in the script behind If and Case..when statements and is never ever executed. There is a validation, which prevents this ...
SQL Server 2005 compact edition with VB
Yobbo -
15 Mar 2007 9:43 PM - 3 messages
OK so I've downloaded and installed this 1.7MB wonder, but now what? I just wanted a nice easy to deploy db to use with my VB 6 app and although the size is now great it doesn't seem to be doing much else. ...
Restore Failure OS Related ?
Jim Bailey -
15 Mar 2007 9:39 PM - 3 messages
First off, I'm fairly certain this is an OS issue. However, it manifested itself in Sql Server operations, so I hoping someone here may be of assistance, or has seen it. Sorry for the length of the post, but I'm trying ...
SQL Server Backup and Transactions
Amos Soma -
15 Mar 2007 9:19 PM - 4 messages
Say I do a backup of a database and then restore it. Can someone tell me what the state of the database will in the following scenarios? 1) A single transaction was running before the backup started and the same ...
How to avoid creating duplicate indexes on the same column
Sarah Bram -
15 Mar 2007 9:10 PM - 6 messages
Before creating an index on a table column, how to check if that column was already indexed (with a different index name)? I have to do this in SQL Script. Thanks, Sarah ...
modifying output from osql command line
FS -
15 Mar 2007 9:08 PM - 2 messages
when running a query in query analyzer, you can set the query to result in grid, which i preferably like over result in text. when running it through osql, i'm trying to find a way to do the same. anyone know how? I tried using ...
ISNULL not working
doodle -
15 Mar 2007 8:36 PM - 4 messages
sql 2k5. can someone tell me why this is not working? m.password data type is char(8) select m.JobLogID,m.password from tblJL_Main m where isnull(m.password, 0) thanks, -doodle ...
SQL Server Compatibility Mode Issue
Isaac Alexander -
15 Mar 2007 7:56 PM - 3 messages
My app uses a user defined function which isn't allowed in SQL Server 7. Is there a way to conditionally create a function based on the compatibility mode? Here's what I have so far. I keep getting syntax errors. ...
DATABASE Mail Account Setup Error
Thom -
15 Mar 2007 6:50 PM - 2 messages
When I attempt to setup a new Mail Account using the GUI I receive error: Cannot insert the value NULL into 'servername', table 'msdb.dbo.sysmail_server' column does not allow Nulls. I feel in all the fields on the Account Setup Screen and put in a valid smtp ...
SA Password help
DG -
15 Mar 2007 5:15 PM - 4 messages
Is there a default password for the SA id? Is this id used only for admin purposes, because I am upgrading a database and the install requires me to use the SA id. I made a copy of the database to test so if SA is only for ...
Changing the text of the code of multiple stored procedure
subodh97 -
15 Mar 2007 4:52 PM - 10 messages
Hi, We have four different SQL Servers and each server has 2-3 databases. The stored procedures on each database use link servers to access each other. The link server names are based on the actual server name. The Issue:- We are migrating to SQL 2005 and to save on the licence ...
Conversion failed when converting datetime from character string
cbrichards via SQLMonster.com -
15 Mar 2007 4:39 PM - 2 messages
I have a strange problem that I need help troubleshooting. I have the following statement in a stored procedure: SELECT IsNull(NullIf(Convert(varchar(20), Cast(Value AS datetime), 126), ''), '') FROM #TFieldValues TFV WHERE TFV.DataType = 'Date' When this statement is run, it returns the following error; ...
Memory Pressure Question
Patricia -
15 Mar 2007 4:39 PM - 3 messages
SQL Server 2000 SP4 w/ build 2187 running on OS Windows 2003 SP1. Active/Passive cluster with two nodes. AWE enabled. We are experiencing memory pressure problems with errors such as "unable to reserve contiguous memory" and "insufficient memory available" which lead to fail over. I've researched causes and ...
How to configure SQLExpress on a workgroup
Earl -
15 Mar 2007 4:09 PM - 5 messages
I recently deployed an app with SQLExpress2005 as the backend. Despite testing it here on my dev network, this was my first opportunity to use it in a workgroup environment. I had to really jump through some hoops to get ...
SQL Server Backup
George Schneider -
15 Mar 2007 3:44 PM - 5 messages
We use a software form our provider that runs on a SQL db. I recently asked them what to back up. They informed me that I should only backup the user db's the software created and uses. I question thi sbecuse I was always ...
moving a database causes it to be read-only
Dan D. -
15 Mar 2007 3:13 PM - 6 messages
Using SS2000 SP4. I've done this many times before without problem so I don't know why I'm having trouble this time. I'm running out of space on a drive so I'm moving some databases to another drive. I've tried this with EM and QA ...
Can not change index INCLUDE fields order....
Forch -
15 Mar 2007 2:56 PM - 3 messages
Hi... I was in the process of synchronzing the indexes in two seperate databases; production and development. I ran into a problem with one table. The current production index looks like this: CREATE NONCLUSTERED INDEX [INX_Table1] ON [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5], ...
Database shrink operation
manu -
15 Mar 2007 1:36 PM - 3 messages
Hi, I am confused whether database shrinking operation also does reindexing or rebuilding of indexes in background when it runs because, shrink operation affects the data page location on disk caused by their movement. Thanks Manu ...
Clus. Index keys
manu -
15 Mar 2007 1:33 PM - 6 messages
Hi, I read in one sql document tht--If the table have a clustered index, the bookmarks of all non-clustered indexes will have clustering keys for each row, and physically moving a row on disk would of course not have any effect ...
Default Schema on SQL Server 2005 with Server Role "sysadmin"
Robert Klemme -
15 Mar 2007 1:25 PM - 3 messages
Hi, I have a user with a default database and a default schema that is not "dbo". I noticed that, if I assign this user the server role "sysadmin" the default schema does not seem to be honored any more. Instead ...
Date range for daily job
tolcis -
15 Mar 2007 1:22 PM - 3 messages
Hi! I have a SQL job that runs a query. That job has to be run daily (or couple of times per day) The query has to collect information for some created apps WHERE DateCreated BETWEEN [First Day of Current Month at 12:00am] AND ...
Disable Job Steps
Trevor Howe -
15 Mar 2007 12:42 PM - 4 messages
Hi I have a job setup in SQL Server Agent (SQL 2005) that runs multiple packages. Each package is run as a separate step in the job. I am busy testing the job and want to skip some of the longer running packages for now. ...
Backup and restore to another database
PromisedOyster -
15 Mar 2007 12:10 PM - 3 messages
We are running SQL Server 2000 Standard Edition Every night, I want to take a backup of our production database and restore it to another database that is used for reporting/DR purposes. My thinking was as follows: (1) Setup a job on the source (production) to create the backup to a ...
Trigger generation Error
Krishna -
15 Mar 2007 11:34 AM - 4 messages
Hi, I am krishna .I cerated one trigger based on after insertation in one table .But it's not fire on after record insert the table. Trigger sysntax is below Create TRIGGER InsertFamilies ON Families ...
Number and duration of execution for stored procedures
CM -
15 Mar 2007 9:13 AM - 2 messages
Hello, Will be very usefull for me if I know what are the stored procedures more often use in a database and how long is the execution time.Can someone help me in putting a trigger, or getting this values from tempdb maybe ? I know ...
How to enable the endpoint feature ?
ABC -
15 Mar 2007 7:48 AM - 2 messages
How to enable the endpoint feature ? Is there any step-by-step documents to config the sql server to enable endpoint feature? ...
Restoring log & backup
Ant -
15 Mar 2007 6:39 AM - 3 messages
Hi, Our SQL server has a database with scheduled backups which backup the database & the log file of our production site. I would like to restore this backup to our test DB with the production backup in order for it to resemble the production one. Should I uncheck the ...
Page faults - Help required
AMBROSE -
15 Mar 2007 6:28 AM - 3 messages
The SQL server after some insert ,updates and delete the memory usage after some ten minutes or some is not returning to the memory usage level when it was first started . I read from some websites this is due to the working set not in RAM . ...
Stored Procedure
meka -
15 Mar 2007 6:12 AM - 2 messages
While writing a stored procedure how can I assign the value returned by one query into the local variable declared within the stored procedure which is needed to get some other records through another one select query. my query is ...
Import/Export Wizard SQL SERVER 2005
lorenzdominic_ -
15 Mar 2007 4:56 AM - 3 messages
Hi I am using the Import/Export Wizard from SQL Server Management Studio and have incorrectly exported the results of an SQL Select query to the same database that I was exporting from. However I cannot find the data anywhere after the export completes so I can delete it. Any idea ...
schedule a backup?
Tmack -
14 Mar 2007 11:49 PM - 3 messages
I'm reading Stanek's SQL 2k5 pocket ref and on page 447 #11 he says "To schedule a backup, click schedule". I don't see a "schedule" button anywhere. I created a schedule under the agent (I didn't create a job, just a ...
change a value in a field
Johnfli -
14 Mar 2007 11:31 PM - 5 messages
I have a table with several fields (like who doesn't) I would like a quick and easy way to change a field value If I run a query that says " select fieldA, fieldB, fieldC, fieldD from tableE where fieldD = '3122007' " ...
DATEDIFF and time format in Sql Server
zainab -
14 Mar 2007 11:26 PM - 6 messages
Hello; I'm attempting to use the datediff method to compare two dates, generated under visual studio 2005 with the instruction DateTime.Now.ToLocalTime().ToString(), which returns something like DD- MM-YYYY HH:MM:SS. the dates are then stored in an sql server database and then a query ...
is my sql server 2005 installed correctly?
Steve Richter -
14 Mar 2007 10:50 PM - 6 messages
I installed sql server 2005 enterprise from my MSDN subscription onto a Vista business system. problem is I am getting a "no server connection" message in MS sql server mgmt studio and config manager. do I have to start the server? How do I do that? ...
Plans in Cache
cbrichards via SQLMonster.com -
14 Mar 2007 10:46 PM - 10 messages
If plans in cache are frequently being removed, can that indicate memory pressure? This is probably a "this depends" type of answer, what is an optimal time for plans to stay in cache? ...
Supersocket info:Bind failed on TCP port 1069
lionel -
14 Mar 2007 8:39 PM - 3 messages
Hello we ran into following error message when we reboot SQL server, which cause client side couldn't connect SQL Server. Supersocket info:Bind failed on TCP port 1069 We are wondering what could be reason cause this problem. we suspect that another application take the port 1069 which wouldn't allow ...
DTS Export to Excel
Martin -
14 Mar 2007 8:08 PM - 7 messages
I am using a DTS created by the Export Wizard to send data to an Excel spreadsheet. The problem is that each time the DTS is run, the data gets appended to the spreadsheet, rather than replaced. I used the Drop and ...
Where is SP2a
Cordelia -
14 Mar 2007 8:02 PM - 4 messages
I have not been successful in obtaining the latest service pack for SQL Server 2005. Not sure to call it SP2a or, as I've read it being referred to as, SP2 refresh. I downloaded, what I thought to be SP2a, from the SP2 site. Installed it on ...
Estimating Table Sizes
marcusq71@gmail.com -
14 Mar 2007 7:46 PM - 5 messages
Is it possible to write a query that can estimate the space a table is using in the database? I would like to be able to generate a report that can display the amount of disk space a table is consuming. ...
SQL move to new server
paulc -
14 Mar 2007 7:33 PM - 3 messages
We have a new server for our SQL and I'm planning on moving all tables, etc to the new server. However, the old server is Windows 2000 whereas the new server is Windows Advanced Server. Will this cause a problem for SQL? ...
dumptrdate column gone in sql server 2000?
FS -
14 Mar 2007 6:51 PM - 6 messages
Hello, I am running an environment that has Sybase and SQL Server 2000, and i've been using the dumptrdate column from sysdatabases on all SYbase servers, but it appears that it has been replaced by a Reserved column. Is there an ...
Recompiles where EventSubClass = 4
cbrichards -
14 Mar 2007 6:28 PM - 3 messages
I have high recompiles on a stored procedure. The procedure is quite complex and contains about 2,000 lines. The beginning of the stored procedure starts out with the following, where @Debug is an argument when the stored procedure is executed: ...
Counting GUID s
pltaylor3 -
14 Mar 2007 6:23 PM - 3 messages
Is there a way to do a count on a guid in sql 2000, if I try I get an error when running the query. thanks for your help ...
When All User Databases means System Databases
me -
14 Mar 2007 5:21 PM - 3 messages
We just bought a new server a couple of week ago and set it up with SQL Server 2005 SP2 on x64. Last week we migrated to it...upgrading all our datases to v. 9.0 compatibility mode. This week, I'm trying to run a management plan involving a consistency check ...
Prompt for a database name
bpdee -
14 Mar 2007 4:16 PM - 4 messages
Hi, Is there a way to prompt someone to enter a database name in a script? For example, I have a script where I need to update a table to set a column with a value found in another table in another database. We don't know exactly ...
Please help - Named instances and full-text search
Derek -
14 Mar 2007 3:53 PM - 2 messages
I asked this last week and no one replied :-( i have a sql server 2000 default instance and i'm planning on adding a sql server 2005 named instance to the server. both will be using full text search. i ...
No Commit at end of program processing on 2005
Peter Nolan -
14 Mar 2007 3:48 PM - 2 messages
Hi All, I have written some ETL software that allows the user to turn off autocommit and then set the commit frequency. It is C++ talking via ODBC. We are testing on an SQL Server 2005 machine and the behavior we are ...
ODBC on 64 bit Enterprise SQL Server 2005
Kristina -
14 Mar 2007 3:31 PM - 11 messages
We are preparing to migrate all our 2000 databases to SQL Server 2005 and have run into an unexpected issue. We pull in a lot of Legacy Data from a Thorougbred Basic main system. We use their 32 bit ODBC driver ...
Time zone
Sehboo -
14 Mar 2007 1:51 PM - 2 messages
We have a c# application (with about 100 forms, and 300+ tables on sql server). We have several customers who use that application but everybody gets the copy of the database. Structure of the database is same, but with ...
Marked "IN LOAD" messages
Kristen -
14 Mar 2007 1:36 PM - 12 messages
I do restores on a daily basis. The restores are taken from DISK backups. I am not using backup devices. I am noticing all these errors in the log file: Bypassing recovery for database 'xxxxx' because it is marked IN LOAD. ...
SQL Migration
Shay Hanya -
14 Mar 2007 1:00 PM - 5 messages
Hi I have 2 SQL server, 1 SQL 2000 on Win2000 server, and 1 SQL 2000 on Win2003. 2 diffrent domains. There are 4 DB each 10GB, what is the best way to move the DB to the new server? ...
Importing Stored procedures from one database to another
parasu0107@gmail.com -
14 Mar 2007 12:16 PM - 2 messages
Hi, Any one knows how to import stored produre from one DB another? I imporeted tables and data by using import data wizard. but i couldnt get the SPs Can anyone help me? ...
Is my SQL Server 2000 cluster 2+1 LAM enabled?
Patrick -
14 Mar 2007 10:25 AM - 6 messages
Someone (who left the team) has setup my SQL Server 2000 Cluster1\Myinstance It *was* setup to do log-shipping to a DR server and I thought he has setup the instance to be 2+1 LAM Enabled before he left. ...
Sql Server 2000 Agent Scheduled Job
philiposm -
14 Mar 2007 6:12 AM - 4 messages
Hi, I've got some questions that I would appreciate some help with. I'm working with SQL Server 2000 and every day at midnight we have a scheduled job that runs a DTS package through SQL server Agent. ...
DATE RANGE ISSUE
Ram -
14 Mar 2007 4:49 AM - 3 messages
Hi All, I have below table structure: ItemID Price FromDate ...
Windows 2003 4MB Limitation
alarriva -
14 Mar 2007 2:30 AM - 2 messages
I have an older, cheap ASUS Motherboard with 4GB of RAM installed. I get a lousy 2.9G of free memory available for my use. What motherboard should I buy to get myself closer to 4GB without enabling ...
IDENTITY limit
Alan T -
14 Mar 2007 12:18 AM - 4 messages
I defined a primary field using integer 4 bytes as IDENTITY. What will be the limit of this number? I am not sure the number is big enough in 10 years of time after my application have been running. ...
SQL Mirroring Failover
mo_d -
13 Mar 2007 9:40 PM - 2 messages
I've got SQL 2005 SP 2 setup with high safety mirroring on. My question is - if my principal server goes down how do I force the mirror online (currently in a restoring state)? I believe I need to run "restore database database ...
Write simple batch job to start SQL Server Service
Hassan -
13 Mar 2007 8:52 PM - 4 messages
I want to schedule through NT Scheduler, a task that would automatically start the MSSQLServer Service if its stopped. Dont know really know how to write the command. Can someone help with the command so I can put in a batch file that the scheduler would invoke every ...
Mail Profile
Wild Packet -
13 Mar 2007 8:32 PM - 3 messages
Hey Guys / Gals, I am looking to setup SQL Mail profile on the sql servers but I am concerned that mail enabling the sql boxes poses a security risks. Any truth to this? Is there a way to relay from our Exchange servers instead? Or am I turning ...
How to Monitor ODBC connections
Hurme -
13 Mar 2007 7:50 PM - 2 messages
We're using SQL 2005 sp1 as the db and IIS6.0 on the webserver. There's been a problem where the webserver loses it's DSN connection to the db server. Other machines connectting to the db server on the same lan do not have a ...
Troubleshooting High CPU
cbrichards -
13 Mar 2007 5:56 PM - 13 messages
We are having occasional high, SUSTAINED, CPU. If we just let it go, it stays sustained upwards of 90 percent. We have not discovered the root cause, but when it occurs we are forced to restart SQL Server Service to get back to our ...
SQL Express on a small network
Earl -
13 Mar 2007 5:53 PM - 4 messages
I have an app that is on a small network. The backend is SQL Express 2005. The network is connected through a router without a server. Each of the computers on the network appear in the Explorer browser of the other ...
Restore MB/Sec
Ben UK -
13 Mar 2007 4:51 PM - 2 messages
What sort of MB/Sec do you have for a restore operation? I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the log, and the backup is coming from a 6 Disk RAID10 array.. ..the database I ...
Deadlocks in the error log
Frank Rizzo -
13 Mar 2007 4:35 PM - 3 messages
It seems that the information written to the error log about deadlocks changed in 2005 and I can no longer tell what the numbers mean. Like for instance, the information after KEY? I can't seem to find sql ...
Stale stats
Frank Rizzo -
13 Mar 2007 4:27 PM - 4 messages
Hello, I've recently run into a problem with SQL Server 2005 64 bit edition, that I did not see with the same exact structure and very similar data on SQL Server 2000. It manifests itself in the following way: ...
SQL2005 Plan Maint Rebuild Index
Gerard K. -
13 Mar 2007 4:25 PM - 2 messages
First of all, excuse for my english. As part of a maintenance plan in a
SQL Server 2005 SP1 x64 environment, we have a Rebuild Index scheduled
for 2:00 AM every Saturday followed by some others maintenance tasks.
On executing the following query we ALWAYS get an error: ...
Trace flags for deadlock detection on startup.
Frank Rizzo -
13 Mar 2007 4:02 PM - 6 messages
In SQL Server 2005, I can log deadlocks to the error log by turning on the 1204 trace flag using the following command: DBCC TRACEON (1204, -1) How do I make sure that the flag is turned on every time the server is ...
Service account authentication cache
Steve Beaugé -
13 Mar 2007 3:43 PM - 3 messages
Hi, I've a developper version of Sql Server 2005 (SP2). The service account is a domain user (domain\user). I've started the service many times (so credentials are ok). What about if the server is seperated from the corporate network ? In fact ...
Second Instance os SQL 2005?
George -
13 Mar 2007 2:46 PM - 7 messages
Hello, I have a question about installing two instances of sql 2005. I have ot set up two apps on a machine and they use different collations. Do I need to install two instances of sql? That is how we did it in sql 2000. ...
|
|||||||||||||||||||||||