Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Link to Oracle Server
Posted by David Dvali at 2/17/2006 10:19:01 PM
How can I connect to Oracle from MS SQL and read/write data into Oracle's
Error Message 22029 on SQL Server 2005
Posted by Paolo Taverna at 2/17/2006 4:30:04 PM
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 >>
SQL Server 2000 installed with wrong CD Key
Posted by Thomas Maier at 2/17/2006 3:07:35 PM
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.
SQL 2000 Different Performance on Servers with Similar Hardware
Posted by Elroyskimms at 2/17/2006 2:24:32 PM
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 >>
Out of disk space
Posted by Richard Douglass at 2/17/2006 2:17:16 PM
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.
Multiple instance name
Posted by Max André Bündchen at 2/17/2006 1:19:21 PM
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
Posted by ChiWhiteSox at 2/17/2006 12:51:27 PM
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.
SQL Backup Maintenance
Posted by Diane Walker at 2/17/2006 12:25:44 PM
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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSSQL 7.0 - 2000 linked servers
Posted by MedioYMedio at 2/17/2006 11:24:04 AM
Is there any known issues related to MSSQL 7.0 linked server from 2000 and
Is it fully compatible?
Help with SubQuery
Posted by sck10 at 2/17/2006 10:10:33 AM
I have two tables to track Travel request and track Travel Approvals:
Approver_ID (Email Handle)
What happens is that a traveler will submit a t...more >>
sql query help join
Posted by uspensky NO[at]SPAM gmail.com at 2/17/2006 8:28:38 AM
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 >>
Posted by Rich at 2/17/2006 8:03:29 AM
when the Audit Level is changed from Everything to Failure, do I have to
stop and restart the SQL Server Windows Service?
How to restore a Transaction Log and do a forward roll?
Posted by T.Taylor at 2/17/2006 7:59:31 AM
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 >>
Time-out occurred while waiting for buffer latch type 4 for page (1:4275463), database ID 6.
Posted by kim NO[at]SPAM regionalhelpwanted.com at 2/17/2006 7:33:36 AM
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.
Cannot create table: SSMS Hangs
Posted by Tamer Yousef at 2/17/2006 6:44:44 AM
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.
The missing default db and a connection to SQL Server 2005 via a D
Posted by Andrey Odegov at 2/17/2006 5:39:23 AM
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;
3. Alter the d...more >>
Posted by anoni at 2/17/2006 3:29:29 AM
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?
Table Transfert MSSQL8
Posted by Simon at 2/17/2006 3:15:07 AM
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 >>
Cannot create diagram and not run jobs with my domain account logi
Posted by Tommy at 2/17/2006 12:47:27 AM
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 >>
Posted by Frinton at 2/17/2006 12:00:00 AM
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 >>
TempDb "log in use" growing. Fixed by manual checkpoint or SQL Restart
Posted by Paul Cahill at 2/17/2006 12:00:00 AM
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 >>
Posted by Prasad at 2/17/2006 12:00:00 AM
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
SQL-DMO gives it.