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
Daily Backups SQL 2005 Standard Edition
Posted by Chris Marsh at 2/11/2006 7:43:58 PM
With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Creating relationship between column and replacement column
Posted by Steven K0 at 2/11/2006 5:49:18 PM
I have a table (tblManchineParts) that is the list of all machine parts.
The second table (tblReplacementParts) is a list of all the machine parts
and the machine part that replaced it. I tried to create two foreign key
relationships to enforce Referential Integrity:
Create query from table SS2K vs. SS2005
Posted by Steven K0 at 2/11/2006 5:21:21 PM
When using SS2K, you can create a query by right-mouse click on the table
and then selecting "query" in the Enterprise Manager. How do you do this in
SS2005 when using the Management Studio? When I right-mouse click on the
table, the only option I have is to select "Open", which ru...more >>
sql server 2005 "Change Type" is grayed out
Posted by Steven K0 at 2/11/2006 5:15:16 PM
I am trying to create an update query using the following steps:
Right mouse click on table
Select "open table"
Once I click on the table, I can select most items from the "Query Designer"
toolbar. I can select the Diagram, Criteria, SQL and Results pane.
However, the "Change T...more >>
System-wide 'min memory per query' error
Posted by matt139 at 2/11/2006 8:01:58 AM
Hi everyone, I'm posting a server-wide issue I'm getting on a Windows
SQL 7 server and a Windows SQL 2000 server. Each server has several
databases (the SQL 2000 box has alot more than the older 7.0 server),
and alot of database queries are returning the following error to the
web browser when r...more >>
Dts problem with dual installation of sql 2000 and 2005 on same box
Posted by Colin Robinson at 2/11/2006 7:36:31 AM
I have Sql 2000 installed first, and a second install of Sql2005 installed
as an instance on the same win 2003 server.
Dts 2000 designer is raising errors on initialisation. When you attempt to
create a new package there are no icons in the connections toolbox.
I am sure this is being case...more >>
Slow SQL Server
Posted by Islamegy® at 2/11/2006 12:00:00 AM
We have upgraded From Win2000 Server to Win2003 Standard
with sql server2000 SP4.. after upgrade all our program which connect to the
server is too slow.. doing update or save operation on a table with 100,000
record talk 5 sec or more if few people work on the same table, with the old
Any way to kill zombie locks by commandline?
Posted by Marc Bauer at 2/11/2006 12:00:00 AM
we have some troubles with a object that kills our SQL2000SP4. CPU spikes to
100% and stay there. We are searching for a solution, but currently don't
have one! So it comes to situation where a object named
"company.dbo.fn_example" have more then one ProcessID. If this occour -
"all" o...more >>
Don't see what you're looking for? Search DevelopmentNow.com.