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
Rename MDF file
Posted by George Schneider at 2/4/2006 7:45:27 PM
Is there a way to rename the mdf and ldf files associated with a databse.
Also can I rename the fil nemae that is created for these when the databse
gets created....more >>
linked server, oledb for odbc, slow performance on join to cache
Posted by steven NO[at]SPAM ironcube.com at 2/4/2006 7:30:44 PM
I have a sql linked server pointed to a cache database. I created it
using the oledb for odbc and pointed it to an odbc data source I
created using the intersystems odbc driver install. I can openquery the
database fine if i need to pull back specific record fine. But if i try
to join data betwe...more >>
debug via Enterprise Manager
Posted by Dariusz Tomon at 2/4/2006 6:24:14 PM
I wonder if there is a trick I can use to debug what was changed in my
The idea maybe sound stupid but my boss have got old console application
which is doing some changes in database (only in data in tables rather:). I
have no code for that application and we are ...more >>
A few compilations/sec
Posted by Hassan at 2/4/2006 1:24:12 PM
Im seeing an average of 4-5 compilations/sec with max at 60s and 70s at
times. But the recompilations/sec could average around 0 or 1..
How can i find out what sprocs are triggering the compiles ?And why would
I tried to look at sysprocesses at the waitresource column for values tha...more >>
Posted by George Schneider at 2/4/2006 12:59:36 PM
Can you have Databse names that contain spaces such as Intanet Content
Databse? Will this cause any issues in SQL 2000?...more >>
SQL Server 7.0 to SQl Server 2005
Posted by Srikanth at 2/4/2006 12:22:49 PM
We just upgraded SQL Server 7.0 databases to 2005. Backed up 7.0 database and
restored in 2005 Server.
when we migrating the data from new sql server 2005 database(that is just
converted) to spred sheet we are getiing an error messages
"can not convert nicode and nonunicode string datatypes....more >>
SQL Server 7.0 to 2005
Posted by Srikanth at 2/4/2006 12:06:30 PM
We just migrated SQL Servver 7.0 tables to SQL Server 2005.
When we try to export the data of one table to spred sheet we are getting
these error messages
"can not convert nicode and nonunicode string datatypes.
I verified the sort order in 7.0 is 52
and 2005 also 52.
any one any idia what ...more >>
Linked server connection to SQL Server 2005
Posted by KTN at 2/4/2006 9:57:23 AM
I have an error message of connecting to a SQL Server 2005 from SQL Server
7.0. I tried to set up a linked server connection from SQL Server 2000 and
it works fine. It not working on SQL Server 7.0. Is there a restriction of
connecting to SQL Server 2005 from 7.0? Thanks!
Error Message:...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Deadlock Issue - Cannot pinpoint resource causing contention
Posted by John at 2/4/2006 6:19:44 AM
Have a deadlock issue - see 1204 trace info below.
After reviewing BOL I cannot ascertain the exact resource (table, page,
index, etc) that is causing the deadlock. I believe it might be a row in a
table (ie - RID: 2:1:81:0 and RID: 2:1:81:1) but I am suspicious about this
and I cann...more >>
Renaming warm standby server to assume role of primary.
Posted by vic at 2/4/2006 5:40:50 AM
I've been shipping logs to a warm standby server and now wish to switch to
this server in order to perform maintenance on the primary server. (Both are
running SQL Server 2000 Standard Edition). I intend to take the primary
server offline, and rename the standby server so all clients on t...more >>
SQL Server hangs when Server reboots
Posted by VM at 2/4/2006 3:36:55 AM
I am having this strange behaviour on couple of our database servers. Our
system crashed and it got rebooted, but SQLServer hangs forever and its
status of service is always "Starting". After seeing this we try to reboot
the system, but same thing happens again and again.
SSIS Fails on Create Package (2005)
Posted by Alex Clark at 2/4/2006 12:00:00 AM
I have SQL 2000 and SQL 2005 both installed on the same machine. I'm trying
to migrate a SQL2K database to my SQL2005 server using the Copy Database
Wizard. Every time, it fails on the Create Package step with a message that
it has no additional information for the specific error (yea...more >>
Last iserted ID - MsQL
Posted by Tom at 2/4/2006 12:00:00 AM
Is there any solution? Do you know some and would like to share? Please