|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Applying SQL hotfixes to a SQL cluster
Spin -
22 Jul 2006 9:15 PM - 4 messages
Gurus, Running two instances of SQL on a SQL Server 2000 cluster. Windows Server 2003 SP1 is the OS. Are there any special rules I must follow to execute the SQL hotfix on each node of the cluster? I am assuming I just need to ...
SQL version & SP version
Shashi -
22 Jul 2006 8:32 PM - 2 messages
Hi, How to check which version of Service pack is applied on SQL 2000? Thankx ...
Transaction log full
Rob -
22 Jul 2006 8:12 PM - 2 messages
Is there a specific command (stored proc) that may be issued to tell whether the transaction log is "full" ? ...
Update table from different database server
Jonas Mandahl Pedersen -
22 Jul 2006 8:08 PM - 2 messages
Dear NG I need to run an update query every night, to update my datebase with some information from another database on another server with another login. I best explain stuff through samples, so here we go. My database: SERVER=DBJONAS, TABLE=INFO ...
Change the @@Servername
mecn -
22 Jul 2006 6:39 PM - 7 messages
Hi, We have changed the server name. If I run select @@servername, it came out the same server name. any ideas> Thanks, ...
lost indexes moving from 2000 to 2005
mpaine -
21 Jul 2006 11:07 PM - 7 messages
Hi everyone, I can't find seem to find any reason why my MSSQL 2005 dev database is producing 1000+ error messages that look like: Msg 7999, Level 16, State 41, Line 15 Could not find any index named '_WA_Sys_AUCTION_ID_014935CB' for table ...
Reading and parsing the MS SQL ERRORLOG File
BS -
21 Jul 2006 9:43 PM - 2 messages
Folks, Do anyone have a script to this or know how this can be done? I tried writing a perl script and when perl script reads the error log file, it see a white space between every single character on the every single ...
SQL 2005 Linked Server issues.
ChrisR -
21 Jul 2006 9:06 PM - 5 messages
SQL2K5 SP1. Ive been trying to set up Linked Servers between to boxes for quite a while now and am getting really frustrated. On Box1 I run a query to Box2 and get: I set up the Linked Server on Box1. On Box2 I used the Surface Area ...
\\.\Tape0 is not a vaild Microsoft Tape format backup set
Andre Gibson -
21 Jul 2006 8:54 PM - 5 messages
hi all I am using Sql server 2000 with sp3 on Win 2003. Recently all of my nightly sql server backups have started failing. Here is the error message I get with it The file on device '\\.\Tape0' is not a vaild Microsoft Tape format backup ...
error when assigned key relationship when attempting to save
Paul -
21 Jul 2006 8:37 PM - 5 messages
ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Employee_Department_T'. The conflict occurred in database dbase1, table 'Department_T', column 'Department_ID'. HI I have a simple table arrangement and in EI after I add a primary to ...
copy a job from one database to another
gerry m -
21 Jul 2006 7:51 PM - 9 messages
Hi, new to sql server 2000, wondering if there is a easy way to copy a job from my test database to production database...they are on same instance.... Thanks, Gerry ...
Tuning question
markrr -
21 Jul 2006 7:46 PM - 2 messages
I have a fairly complex SELECT statement. It is running on a server with 8 CPUs and 8GB RAM (using about 6.5GB). The statistics that I get when I run it are below. It is not the first time that I ran it so the ...
Sending email when SQL Server goes down.
BS -
21 Jul 2006 7:31 PM - 3 messages
Folks, Has anyone tried to send an email to notify when SQL Server goes down for any reason? I'm able to setup the emaill whenn it starts but not when it goes down. Thanks. ...
is it possible to number the records?
Roy -
21 Jul 2006 7:06 PM - 2 messages
I am using Sql Server 2000. I have a select query which returns rows from a table. For exmaple let's say it returns 10 rows. I would like to return one additional column with numbers 1 from 10 against each row. ...
begin transaction in a sp or not????
tpp -
21 Jul 2006 6:36 PM - 6 messages
Hey. I've SQL 2000 ent. ed. right now. The application is vb .net and it doesn't handle transactions at all. We'll be moving to SQL 2005 soon but dont know when. I know I can use Try...Catch in SQL 2005 to do transactions or ...
Connecting to SQL Server 2005
programmingcodeATjards.com -
21 Jul 2006 5:55 PM - 3 messages
I have successfully installed SQL Server 2005 on a server that also has SQL Server 2000. Using SQL Server 2005 interface, how could I connect to a named instance of a SQL Server 2005 database? As I try, it keeps connecting ...
SQL Profiler Help....
Paul Widner -
21 Jul 2006 5:38 PM - 8 messages
Are there definitions any where on what the different columns of of a trace represent? I can't seem to find them in the SQL Server books online. Specifically I'm wondering what the "Reads" column represents? Physical Reads, logical ...
tables called by stored proc
sullins602 -
21 Jul 2006 5:35 PM - 3 messages
Does anyone know how you could get a list of tables called by a stored proc? I am setting up replication and need to get a full list of tables called by all of our reporting stored procedures. I figure if I can get ...
sql query testing
sakcee -
21 Jul 2006 4:59 PM - 4 messages
Hi I need to make test plans for some sql select queries, what conditions or things I should test? I was thinking of testing where clause for data types etc? any help is greatly appreciated thanks ...
Adding a new datafile
Federico G. Babelis -
21 Jul 2006 4:29 PM - 2 messages
Hi: I have SQL Server 2000; a database with three file groups located in three different operating system files; the database size is 200GB; for performance reasons we added an additional storage to the server and we have an additional disk volume, what we want to do is to add a new datafile ...
finding primary (integer) row with paramaterized query
ejhines -
21 Jul 2006 2:57 PM - 4 messages
Hi gang, What I am using: - Windows XP pro -Visual Studio 2005 Pro -Visual Basic 2005 - \SQLExpress What I am doing: - I have a frmFindForm which contains a find button, and a textfield - I have a frmProjectDetails form which is supposed to supply the data (when ...
transaction log size/perfomance problems
Diane -
21 Jul 2006 12:39 PM - 10 messages
I am running SQl Server 2000. Transaction log is (unfortunately) on the same server as the db. The transaction log is set to grow at 10% and is currently 11GB large since it has not been backed up/truncated. I have seen a steady ...
Problems starting SQLServer2005-Express-Instance
Henning Friese -
21 Jul 2006 12:16 PM - 4 messages
Hello NG, I'm having a hard time getting my MSSQL2005-ExpressEdition-installation to work. When I try to start the service I get a couple of errormessages (in the eventlog, see below) which seem to indicate that theres a problem with the network-component ...
DTS
Alan T -
21 Jul 2006 11:02 AM - 2 messages
I used DTS to export data to a text file. Then I used these text files to import to another database, during the DTS import, why I did not need to specify the table to be imported the data ? ...
Copying a full-text index from 1 DB to another...
almurph -
21 Jul 2006 10:49 AM - 3 messages
Hi everyone, I noticed that when I did an export on a database (lets call it DB_a) to another one (lets call it DB_b) it did not copy over the full text index (FTI) that was on DB_a. ...
++ IIS + SQL (Not enough storage is available to complete this operation)
tolgay -
21 Jul 2006 10:34 AM - 4 messages
Sometimes we got an error (Not enough storage is available to complete this operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix installed) sql server sp4. mdac 2.81. It occures random and we could not ...
SQL2005 standard on AMD Opteron not using all cores
Ole Thomsen -
21 Jul 2006 6:33 AM - 14 messages
I noticed that on a HP BL25p dual CPU dual core, the SQL2005 SP1 server only uses the first core on each CPU, so that two cores are virtually "sleeping". Overall CPU usage is around 30% during normal load. Is this normal? ...
Shrink Database
doller -
21 Jul 2006 6:08 AM - 3 messages
Dear all, What would be the effect on the database if we shrink the database after every day database backup. from Doller ...
Cannot Register Remote Server
Alex AU -
21 Jul 2006 5:42 AM - 13 messages
Dear all, I've installed SQL2005 on my local machine. And there is another SERVER which has install both SQL2000 and SQL2005. I can use my local Management Studio to register the SERVER\SQL2000 instance but I cannot register SERVER\SQL2005 instance. ...
Sql server error msg9001 the log for database is not available
dontknowperson -
21 Jul 2006 3:00 AM - 2 messages
Another one know why the sever encounter this error? In the eventviewer error log it prompt LogWriter: Operating system error 33(The process cannot access the file because another process has locked a portion of the file.) encountered. What is the remedy? Shall I restart the sql server or reboot the computer? ...
Fatal exception error in MSSQL2005 SP1
stephanie -
21 Jul 2006 2:55 AM - 4 messages
The SQL server was terminated by exception acess violation at 10pm but before that, I got some dump logs between 8pm to 10pm. Any idea? Thanks in advance ****************SQLDUMP.LOG************** Memory ...
Disable Job Still Executing
Bruce -
21 Jul 2006 2:33 AM - 2 messages
I have data archive process that disables the backup job then enables the job when the process has completed. One thing the job still executes as schedule. I tried disabling the schedule as well as the job which did not ...
How do I save a Word document in SQL Server 2000?
Jason Huang -
21 Jul 2006 1:45 AM - 3 messages
Hi, I am wondering how to save my MS Word file into my SQL Server 2000. Would someone give me some advice? Thanks for help. Jason ...
Query performance
Mike -
21 Jul 2006 12:15 AM - 3 messages
Hello, I wrote the query below, but I was wondering whether there was a better way of doing so. I am basically trying to build a recursive process. Any suggestion would be greatly appreciated. Thanks. Mike ********************************************************************************************* ********************************************************************************************* CREATE PROCEDURE dbo.CustomersFiltered ...
SQL 2005 upgrade problem
Jim Norton -
20 Jul 2006 9:47 PM - 3 messages
Hi all: After upgrading to SQL 2005 from SQL 2000, some (not all) of the Sql logins have incorrect passwords...meaning the password used to log into the server "before" the upgrade no longer works "after" the upgrade. But again, this ...
Enterprise manager crash>lost all file associations
Daniele -
20 Jul 2006 9:39 PM - 4 messages
Hello, I have MS SQL Server 2000 SP4 installed on a Windows Server 2003 Ent. Possible scenario: -Import/Export using DTS wizard to copy tables from one database to the other on the same server. (has also happened when selecting "Design" on ...
Union Query from Different SQL Servers (Parsing Issue)
Dave -
20 Jul 2006 9:02 PM - 3 messages
Hi, I am trying to develop a union query from two different SQL Servers. I was able to add one server to my server group with just it's server name "SQLSERVER", however for some strange reason, I could only add the ...
Question on upgrade to SQL Server 2005
shub -
20 Jul 2006 8:41 PM - 3 messages
We are planning to upgrade one of the SQL Server 2000 instance on a windows 2003 box to SQL Server 2005. I was wondering during the upgrade will it allow me to chang the name of the existing 2000 instance to a ...
Adding a Field
Rich -
20 Jul 2006 7:53 PM - 10 messages
Hello Group, I am adding a field an SQL table. This field will not be used a PK or FK. It is just another field to hold data. My question is at the point of saving the field into the table I get a ...
restore a transaction
CAMC1 -
20 Jul 2006 7:36 PM - 6 messages
Hello, Someone came to me and asked me to restore a record, deleted by acident via an ERP program. Problem is how do we restore only his record without touching integrity of other peoples record. There are more then 20 table ...
Upgrade to 2005
Janet -
20 Jul 2006 7:07 PM - 3 messages
Am not a true sql dba, and just barely a developer. Running sql2000 svcpk 4 on Svr2003. Want to bite the bullet and upgrade to sql2005. Read some other stuff, downloaded the MS Upgrade Tech Resource Guide and have some questions: ...
Auditing all tables in a database
Paul -
20 Jul 2006 6:04 PM - 7 messages
I have an application that we purchased that accesses it's database in SQL Server 2000. I wanted to know what tables the application accesses when a certain function is performed. I thought that I could add a trigger to each table that would insert a flag ...
Log Shipping (SQL 2000) btwn OS versions?
yellowbug -
20 Jul 2006 5:17 PM - 4 messages
Has anyone noticed any problems logshipping in a SQL 2k Ent. Ed. environment with Windows 2k to a SQL 2k Ent. Ed. with Windows 2003? Thanks! ...
Very large database
Fabio Rebelo -
20 Jul 2006 5:06 PM - 2 messages
Hi, We have a SQL Server 2000 run on SAP R/3 (4.07). This database have 3 files (data1.mdf, data2.ndf and data3.ndf) witch 300GB each. Somebody know how best pratice to configure database large with SAP or ...
strong performance problem with a parameterized query
Silvere -
20 Jul 2006 4:40 PM - 3 messages
We have a strong performance problem with a quite complex query. The query executes in approximately 7 seconds in Query Analyser (which is okay for us), but takes much more time from ADO.NET : it timesout after 30 sec, or after 240 sec if we increase the timeout to that value. ...
Newbie sql query
ina -
20 Jul 2006 4:29 PM - 3 messages
Hello I am newbie to sql and I have this data and I would like to group them Have these record Date ID A ...
Truncate logs on checkpoint option
Ellie -
20 Jul 2006 4:17 PM - 4 messages
Hi, I have this option checked but it does not seem to be working. The docs say that stopping the server will force a checkpoint so I did that. I also shut down (the ultimate server stoppage) and that still did not truncate the ...
Blkby Spid -2
JosephPruiett -
20 Jul 2006 3:35 PM - 2 messages
I have an issue with and testing enviornment between weblogics application and SQL server where we are trying to the transaction threshold above 5000 transaction per hour. We have a test that was ran yesterday for 12 hours trying 8000 transactions per hour threw weblogics against sql server. When ...
Rename 2005 server
sqlboy2000 -
20 Jul 2006 3:07 PM - 3 messages
Hi all, Is renaming a SQL 2005 server any different than renaming a SQL 2000 box? ...
Remove numbers in a column in sql 2005
Pratcp -
20 Jul 2006 2:55 PM - 3 messages
I am uploading data from a text file to sql 2005 tables and one of the columns contains a bunch of weird text to parse. Here is the sample data from the column: 1~ONS~ 2~ONS~AC~ 1~~ 1~ONS~ ...
Restore SQL 2000 db to SQL 2005
Vinni -
20 Jul 2006 2:44 PM - 6 messages
Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible? Thanks in advance. ----------------------------- Vinni | [link] ...
Programatic Import (Space delimited) import into SQL Server 2000
John Wycoff -
20 Jul 2006 2:15 PM - 5 messages
I am trying to find a way to do a programatic import of a space delimited file into a SQL Server 2000 database. The file is actually an IIS web log file. I can run through the file and strip out the header information, I can even create a seperate file for each ...
Sql Server Problem
ilyas -
20 Jul 2006 1:58 PM - 6 messages
sql 2000 is running on windows 2003 server i got backup file from server and i restored it on my computer ( xp prof , sql 2000 ) so same db , same query must to give same response and same execution plan but its different ...
attach db sql in a previous sql server version
VT -
20 Jul 2006 1:06 PM - 3 messages
Hi, anyone can tell me if is possible to detach a db from a sql 2000 server and attach it again into a sql 7.0? thanks VT ...
How to backup and restore
Alan T -
20 Jul 2006 12:28 PM - 5 messages
I have a database called "Office1" in my office machine, and want to do a backup. After that, I want to restore this .bak file to my home database called "Home1". This "Home1" database was just created in EM has only the system ...
Export the schema and data
Alan T -
20 Jul 2006 12:14 PM - 5 messages
How do I export the database schema along with data, SP, Views..etc into a script file ? ...
Database Size
Rick -
20 Jul 2006 12:08 PM - 2 messages
Can I get a snapshot of all my Database size's on my sql server. Something I could import into Excel? thanks Rick ...
SQL Generator
Bit Byter -
20 Jul 2006 11:43 AM - 2 messages
Hi, This may be a little OT, but I don't know exactly where else to post it. I am writing a little parser that generates valid SQL using "English like" text. I want to use this to allow non-technical users to ...
Microsoft OLE DB Provider for SQL Server error '80040e31'
Nachi -
20 Jul 2006 3:18 AM - 3 messages
Hi Till now the website was ok. But now I am getting Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired My connection in Config.inc is <%Set MyConn=Server.CreateObject("ADODB.Connection") MyConn.Open "PROVIDER=SQLOLEDB.1;Persist Security Info=False;User ...
documentation clarification on nonclustered index
Zen -
20 Jul 2006 2:05 AM - 14 messages
I have read through the explanation of how non-clustered and clustered index but I never understand this part. This is a part of non-clustered index documentation that I got from sql server 2005: "If the table has a clustered index, or the index is on an indexed view, the ...
US-DE - SQL Server Programmer / Developer
NuVision -
19 Jul 2006 10:56 PM - 2 messages
Job Title: SQL Server Developer / Programmer Job Location: DE: Newark Pay Rate: Negotiable Job Length: temp Start Date: 2006-08-01 Company Name: NuVision Infotech Systems ...
Restore database to default location on anohter server?
Marcus -
19 Jul 2006 9:10 PM - 3 messages
I have a database called "test_db" that has been backed up with the command: BACKUP DATABASE test_db TO DISK = 'c:\temp\test_db.bak' I want to restore it to another Sql Server and call it 'Test_Restored_DB', as well as save it as a different physical file ...
Dynamic Variables in DTS packages.
kpraoasp -
19 Jul 2006 9:02 PM - 2 messages
Hi, I have built a DTS package to load a file into the database. I want the package to be such that it can be run on any database. So, I tried defining a Global Variable by creating a "Global Variable Task" and ...
SQL Service will not start
Jim Abel -
19 Jul 2006 9:01 PM - 4 messages
I have SQL Server 2000 installed as the default instance and SQL Server 2005 instance named mysql2005 on the same Physical server. The 2000 version is working fine but the 2005 version will not start. I did not see any errors ...
SQL Express 2005 to SQL Server
daz -
19 Jul 2006 8:14 PM - 2 messages
Hi Guys I am currently runing SQL Express on a winXP Pro enviroment and need to transport the data in to the full blown version. What is the best/integral way of doing this? I also need to copy the ...
32-bit vs 64-bit
Jan Leste -
19 Jul 2006 6:55 PM - 3 messages
We are getting a new server and considering running 64-bit versions of the OS and of SQL 2005. I've never worked with 64-bit operating systems and am trying to understand the "gotchas". For instance, is it possible ...
SQL Server Reporting Services
djs_tn -
19 Jul 2006 5:32 PM - 4 messages
This for a user logged in via VPN. I have been able to log in locally as this user and it works fine. She has created a very simple report. Operation Failed The numeric portion of 0pt cannot be parsed as a unit of type Point. ...
using SQL Profiler to detect timeouts
Dan D. -
19 Jul 2006 5:22 PM - 3 messages
Using SS2000 SP4. Will sql profiler tell me if queries or stored procedures are timing out? If so, what objects do I need to look at? Thanks, ...
Excessive locks after upgrade to 2005 crashes server
aaron n -
19 Jul 2006 4:13 PM - 2 messages
We recently upgraded to sql 2005 from 2000. this server has a lot of traffic around 1200 batches/sec while the traffic is high the server was fast and it ran ok, around 30-70% cpu. and perf mon showed around 10-50,000 locks ...
table security
tshad -
19 Jul 2006 3:50 PM - 6 messages
I have a database that has for 2 applications. I need to give access to this database for an outside user but only for one of the applications. The problem is that when I give the user the following database roles: ...
HELP!!! - Problem with hints...
segis bata -
19 Jul 2006 3:44 PM - 4 messages
Hello everyone, I'm having this problem, I'm trying to run a query that consists of six tables and one view (all joined together) When I run it without anything on the where (or just one criteria in the ...
IIS + SQL (Not enough storage is available to complete this operation)
tolgay -
19 Jul 2006 3:26 PM - 7 messages
Sometimes we got an error (Not enough storage is available to complete this operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix installed) sql server sp4. mdac 2.81. It occures random and we could not ...
Question on Error message
DataPro -
19 Jul 2006 3:14 PM - 12 messages
Running SQL Server 2000 and new to the DBMS. Getting a consistent error messahe on a test system 'Backup failed to complete the command EmptyTransactionLog1" I checked the documentation, and the OS logs but no additional info. Seems to be happening either at startup ot shortly thereafter. ...
Transfer diagram from one database to another
Norbert Meiss -
19 Jul 2006 3:07 PM - 3 messages
Hi, does somebody know a procedure how to transfer a diagram from one database to another (e.g. from development to production). TIA, Norbert Meiss ...
Post SQL 2000 SP4 hotfixes - confused???
Rob -
19 Jul 2006 3:03 PM - 4 messages
Hi, I'm confused with what hotfixes needs to be applied after installing SQL Server 2000 SP4. One of my server is using AWE so applying hotfix - 899761 (FIX: Not all memory is available when AWE is enabled on a computer that is ...
Changing column collation
Alex -
19 Jul 2006 2:44 PM - 4 messages
Hi all, I have an interesting doubt: In our SQL environments we have some problems with different collations. Unfortunatelly when this servers and db's were created people didn't care about collations. Now would like normalize these environments and db's. ...
Truncate table
David -
19 Jul 2006 2:35 PM - 4 messages
Hello there, I want to truncate a table through a stored procedure. A user say Dev_Staff only has db_datareader, db_datawriter and EXEC role (Customised) to execute all the SP's. How can I allow truncate operations to Dev_Staff user since Truncate command ...
SQL 2005 Server Management WORST than enterprise manager 2000
vorxio -
19 Jul 2006 2:10 PM - 13 messages
Hey you at Microsoft, WHAT ARE YOU'DOING ... ARE YOU TRYING TO BEAT YOURSELF IN MAKING THINGS WORST?!? SQL 2005 Server Management is a few step behind the old and good SQL 2000 Enterprise Manager One example: in ***EVERY*** Microsoft Product option pages are put on TAB (tabbed ...
Restore DB to Point in Time
A McGuire -
19 Jul 2006 1:58 PM - 9 messages
I have a group of folks that are Peoplesoft Developers, of which the back-end is a 65 GB SQL Server database. They run test procedures and processes against this database, but then it is a pretty common practice for ...
select the no. of rwos from the current database
ssingh -
19 Jul 2006 1:58 PM - 4 messages
Hello, I want to select the names and number of rows of all tables in the current database, whose name starts with 'sys' my query is: select o.[name], sum(i.[rows]) as numbers from sysobjects o inner join sysindexes i ...
sql 2005 express
Ponch -
19 Jul 2006 1:52 PM - 3 messages
Hello, I installed sql 2005 express on my winxpsp2 pc. When i try to install one of my sql databases, i get this error : [SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQL Native Client]Login timeout expired ...
SQL Server Harware Configuration
Praveen -
19 Jul 2006 1:23 PM - 3 messages
Hi, I am planning to set a up new sql server in 32 bit environment?. What are all the things should I consider in terms of hardware configuration?. 1) Processor -- Which vendor (HP,intel,Dell etc...) ...
MsSql Server 2000 Backup to tape
EngHim -
19 Jul 2006 12:23 PM - 2 messages
i have 3 schedule job for backing up different databases (4 database) to a tape drive. first job is to do database backup. 2nd job is to backup different database. 3rd job is to backup Transaction log database. each job consist of 4 step, which each step is for each database ...
Multiple applications Accessing the BDE
andz -
19 Jul 2006 12:00 PM - 4 messages
Hi, There are multiple applications accessing BDE on the same machine. Both work fine independently but when they access BDE concurrently..One app stops working when i.e the app that is installed 2nd stops working.It freezes.. Any Ideas?? ...
Data loss
andz -
19 Jul 2006 9:10 AM - 4 messages
We have a situation in here were one of my collegue has accidently uninstalled a Delphi app......how will I recover data that is lost?Are there any tools to recover the data? ...
uploading file into SQL 2005 using .asp
jo uy -
19 Jul 2006 8:47 AM - 4 messages
Hi, Anyone who can send me a sample code of how to upload a file into SQL 2005 server using .asp running on IIS 6? I have a code that has been working when uploading into SQL 2000 but when I ...
debug
meri2 -
19 Jul 2006 8:29 AM - 3 messages
Hi all, I go into SQL QueryAnalyzer for debugging. Expand Stored Procedures for my database, right click the SP I want and select Debug. It prompts me for the parameters and I enter them. It seems to execute the procedure and give me ...
query to populate child tables
dwightsmail -
19 Jul 2006 4:49 AM - 3 messages
hi all, can anyone help me? I am a relative newbie to sql server and I am more familiar with Enterprise Manager than QA. I have made many many access databases though. I am making an asp.net application where by there are a set ...
SS is 'guessing' date format?
Sean S - Perth, WA -
19 Jul 2006 3:49 AM - 3 messages
Hi all, I am inserting/updating a datetime field in SSEE 2005 using a command parameter in ASP. The server's Regional Settings are set use the Australian date format. The date/time string being used is in this format 'DD/MM/YYYY HH:MM:SS' but ...
SQL Server 2005 - SP1
John Smith -
19 Jul 2006 3:30 AM - 3 messages
hi folks, i encountered problem installing sql server 2005 sp1. apparently it is thinking that the sql server version i have is sql express. so the question is: how do i completely remove traces of sql express installation from my machine? ...
Copy a standby/readonly database
stephanie -
19 Jul 2006 3:16 AM - 5 messages
Any idea to copy a standby/readonly database. We a have a standby/readonly DB from logshipping for hot standby and we would like to make a copy of this standby/readonly DB into a read/write DB in the same server for daily ...
MS SQL 2000 Desltop
Raj -
19 Jul 2006 2:03 AM - 3 messages
I have installed MS SQL 2000 Desktop Engine. How can I create database, tables and query through command. There is no GUI available. ...
SQL Server 2000 x64 Compatibility
Brad Baker -
19 Jul 2006 12:14 AM - 7 messages
As I understand, there is an ia64 version of SQL 2000, but is there an x64 version? If not, can the x86 version be run on Windows 2003 R1 or R2 x64? Thanks, Brad ...
db recovery
VT -
19 Jul 2006 12:12 AM - 5 messages
hi, i have a failure on a server controller and i have lost some volumes where logs and index files of a db so now i have only the db (.mdf file) and none backup. SQL versione 7.0 sp3 ...
Short circuit evaluation
Daniel Jameson -
18 Jul 2006 11:26 PM - 5 messages
Hi, Does SQL Server use short circuit evaluation? That is, if I execute the code below, will the query part after the "or" get executed? Is this the same or different between SQL2000 and SQL2005? if ( (1 = 1) ...
View editor in Enterprise Manager not showing table fields
Merlin -
18 Jul 2006 11:24 PM - 6 messages
I have a SQL Server with several databases on it. Just one database is exhibitting this strange behaviour: When I open the View editor in Enterprise Manager and add tables, rather than listing all the fields, it only the 'All Fields' box. ...
Copy MDF and LDF files Over Existing Database
bcumminsr -
18 Jul 2006 9:59 PM - 7 messages
I am not a DBA and it will be obvious to you soon. :) I have two databases on the same server. I want to basically restore a db from an existing db on the same server. The catch is that I don't want to ...
MIgrating DTS packages from one machine to another
RK73 -
18 Jul 2006 9:45 PM - 3 messages
I am building a new machine (SQL server 2000 SP3a on Windows 2003 R2) for an exisitng production michine (SQL server 2000 SP3a on Windows 2000) with 27 user databases. I can move databases, logins, scheduled jobs. I have lot of ...
SQL Server 2005
Srikanth -
18 Jul 2006 8:31 PM - 5 messages
I am seeing these error messages in SQL Server Error log, This is happening on one of the table had a xml data type in it. LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. ...
Cache Hit Ratio Issue
Isaac Alexander -
18 Jul 2006 8:23 PM - 3 messages
I have a customer using SQL Server 2000 Enterprise Edition on two clustered servers (Windows 2003 SP1) with the following spec (times two): 4 x Intel Xeon Processors @ 2.7GHz 3.5GB RAM 36GB Local Hard Drives 175GB of SAN space for Data and log files ...
|
|||||||||||||||||||||||