Hello. How can I connect to Oracle from MS SQL and read/write data into Oracle's tables? ...more >>

Hello I have a problem with the SQL Server 2005 This is the Version i am using: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) On the Server in the SQL...more >>

Hi everyone, installed SQL Server Std. Ed. with a wrong CD Key, is there a chance to change it to the right key without uninstall/new installation of the complete product? Thanx for any help. Thomas...more >>

Our primary server is running dual Xeon 3.06GHZ w/ 512KB L2 cache at 533MHZ on a SuperMicro X5DPA-8GG motherboard. Our backup server is running dual Xeon 2.80GHZ w/ 1MB L2 cache running at 670MHZ (CPU allows up to 800MHZ) on a SuperMicro X6DH8-G motherboard. Each server has 2GB RAM and identical...more >>

We are having a ton of problems with a full backup. The db is 120 gigs, there are 270 gigs free on the server and it continues to fail saying out of disk space. Makes no sense. Any ideas?? Thanks Richard ...more >>

Hi, Is there a way to make the default instance (SQL 2005) work at the same time as a "named instance" ou make a "named instance" work with two or more names? My problem is that I'm using the QuickStart for VS 2005 and all code work with a "SQLExpress" named instance and I just have a defa...more >>

hello y'all! does anybody know how i could browse all my previous postings here particularly in sql server? i need something done which i know i already posted it a few months ago. thanks!...more >>

We are running SQL Enterprise 2000 on Windows 2003 Standard Edition server. We scheduled to run the daily backup job in Database Maintenance Plans. The report showed that "Backup cannot be performed on database "msdb". This subtask is ignored" and "Backup cannot be performed on database "p...more >>

Is there any known issues related to MSSQL 7.0 linked server from 2000 and viceversa? Is it fully compatible? Greetings,...more >>

Hello, I have two tables to track Travel request and track Travel Approvals: tblTravelRequest -------------------- ApprovalStamp_ID tblTravelTool_Approval -------------------- ApprovalStamp_ID Approver_ID (Email Handle) ApprovalStatus What happens is that a traveler will submit a t...more >>

kind of a tough one i think but any help is appreciated. please try to stay away from T-SQL... I have a table with products and closing dates for each of 4 quarters and annual for several years back. (Earning_Dates) I have another table that has those products with dates and closing prices. (un...more >>

Hello Group, when the Audit Level is changed from Everything to Failure, do I have to stop and restart the SQL Server Windows Service? Rich...more >>

We have SQL Server 7.0 and the drive it was on died before we completed our weekly backup. The logs are on a different drive so that was ok. We were able to restore the previous weeks data but now we would like to do a forward roll from the Transaction logs. How do we restore the transaction l...more >>

The last 2 days, I've been getting this error msg when a store procedure is ran. Any ideas? Note - This store procedures has been running without any problems for a long time. -Thanks ...more >>

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU. My machine is: 2.6 GH with 512 of RAM. Win XP proffessional SQL Server 2005 Developer edition ..Net 2.0 & VS.NET 2005 proffesional edition. ...more >>

I receive an error when i try to connect to SQL Server 2005 (SS2K5) via a DAC and an account i use cannot get access to its default database. Steps to reproduce the problem: 1. Log into SS2K5 with the sa account. 2. Create a database: CREATE DATABASE StubDb; GO 3. Alter the d...more >>

Hi, I like to move sql 2000 databases from 2003 server A, on drive D to 2003 server B on drive N. But master database would stop working after I moved to server B, on drive N. What I need to do to resolve the problem or is this do able? Thanks...more >>

Hi, How can i transfert only tables form database to another database. Here, some precision : I have two server under MS SQL 8 SP3, called ORI and DEST. on ORI, I have a database called datab1, with the following tables : a_1, a_2, a_3, a_4, a_5, b_1, b_2 on DEST, I have a database cal...more >>

Hi! I'm using SQL Server 2005 Dev. Ed. on a local machine. I'm logging in with my domain account (HIK\Tommy) wich is a member of the Administrators group on my computer and there is a corresponding Windows login account with sysadmin permissions in SQL Server. I can do most things with th...more >>

Hi, Can anyone help me with a query? Let say I have a table called tblTest with one int field called NumOfCall. NumOfCall hold numbers in sequential order but some are missing. for example the table has 100 records 1 - 105 and 4, 19, 32, 46, 86 are missing. I need a query that will tell...more >>

SQL 2000 SP4 We had this issue occasionally on our production database but it went away when we changed from "Simple" recovery model to "Complex" Everynow and then SQL Server seems to stop automatically checkpointing a database. The log file in use will then start to grow. We can fix this...more >>

Hi, From where can I get SpaceAvailableInMB and KB for a database for SQL 2000 and SQL 2005. sp_spaceused gives the Size of the Database, Data Space Used, Index Space Used. SQL-DMO gives it. Thanks Prasad ...more >>