SQL Server 2000 - Manual uninstall steps needed
Thu, 7 Aug 2008 14:48:01 -0700
I have SQL Server 2000 and 2005 on the same server. I tried doing unstall
(which failed-and now the uninstall option does not exist). I still see
services and instance names that are no longer there. I also still get
Enterprise Manager when I start it.
I'm looking for manual steps, or some tool that ca ...
|
Table Relationship Question
Thu, 7 Aug 2008 13:58:01 -0700
I have an Equipment table and three location tables:
tblEquipment
EquipmentID int PK
SiteID int FK
LocationID int FK
SubLocation int FK
...other fields
tblSite
SiteID int PK
Site char (50)
tblLocation
LocationID int PK
SiteID int FK
Location char(50)
...
|
Insert current values of updated table
Thu, 7 Aug 2008 13:08:36 -0700 (PDT)
SQL Server 2005.
I want to implement an update trigger that will write the current
(new) values to a new table. How do I get the current values for this
updated row?
thanks,
steve ...
|
Installing RTM SQL Server 2008
Thu, 7 Aug 2008 12:53:01 -0700
Hi All,
I have a server running Windows 2008 and I had installed SQL Server 2008 RC0
on this server. Today, I downloaded the RTM version and want to install it.
I went through control Panel --> Programs and Features and removed
everything related to SQL Server. I delete Microsoft SQL Server and Analysis
Serv ...
|
Time-Out Error
Thu, 7 Aug 2008 11:43:01 -0700
We are getting the folowing error on our MTS server where we have our
application. It is going againts a Windows 2000 SP4 server that has SQL
Server 2000 SP4.
It is using something called "ExecShape" (I am not sure what it is). Where
do I start to trouble shoot this time-out error.
Note that this is a ...
|
Alphabetical order
Thu, 7 Aug 2008 15:25:50 -0300
Hi, if I have a table with the columns:
NAME CODE SUPPORTCODE ADDRESS CUSTOMERNAME ... ... ...
Can I do a select that will return me the columns on alphabetical order???
ADDRESS CODE CUSTOMER NAME SUPPORTCODE ....
...
|
What is blocked process -2 ??
Thu, 7 Aug 2008 09:08:01 -0700
Hi folks
I see strange thing. When I run simple delete statement, it shows it's
blocked by spid -2.
Does anybody know what it is? ...
|
|
|
Monitoring Creation/Deletion of Databases
Thu, 7 Aug 2008 06:55:04 -0700 (PDT)
Hi,
I have posted this over in the programming newsgroup but have not had
much response. If anybody can help here (where it seems a little more
active) then that would be appreciated.
Thanks!
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/2a809ce72b3f0e7f# ...
|
Copy tables from seperate servers
Thu, 7 Aug 2008 06:55:01 -0700
Using SQL Server Management Studio.
I have connections to many different SQL servers.
I need to move some tables from one server to another to consolidate.
This should be a basic question but I'm struggling with it. How do I copy to
tables over?
Thanks
...
|
SQL 2008 RTM
Thu, 7 Aug 2008 06:11:01 -0700
I have downloaded the ISO image. How do I burn it to DVD on Vista?
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.) ...
|
