Tagged Questions
2
votes
1answer
272 views
Remove sql server service from windows 7
I had installed and later uninstalled SQL Server 2005 . I used registry cleaner tools and deleted all files related to SQL Server . Still the services console shows entry for previous installed ...
4
votes
2answers
147 views
Display all tables and their columns
Is there a way to display the layouts for all the tables to see their columns? I am trying to find tables with a certain column names.
I am using the web app Web Data Administrator
Example:
table1
...
2
votes
2answers
196 views
Minimum/Maximum Server Memory in SQL Server 2005 with /3GB and /Userva switches
I have a 32-Bit Windows 2003 machine with 3.75GB RAM running one SQL Server 2005 instance. I am trying to optimize memory. If I use the switches in boot.ini like below,
/3GB /Userva=2490
should I ...
5
votes
2answers
103 views
New Cluster Testing - Best Practice
We've finished setup of a 4-node SQL Server 2005 cluster. We are using Windows 2008 R2 as the underlying OS.
We are looking for suggestions on a set of tests we could perform to test failover of the ...
1
vote
1answer
244 views
Failure to detach database
I used sp_detach_db to detach SQL Server 2005 databases. This works properly in Windows XP and Windows 7.
However, the same fails in Windows Server 2008.
The error message states:
The process ...
1
vote
1answer
64 views
Log Custom SQL Results During Maintenance Plan
I would like the last step of my Maintenance Plan to execute a simple custom SQL script (SELECT * FROM <SomeTable> WHERE <Condition>), and save the results to a file (Text, CSV, etc).
Is ...
3
votes
1answer
90 views
migrating from SQL server 2005 to 2008
I had SQL server 2005 installed on my windows server 2008 R2.
Recently i installed SQL server 2008 and SQL server management studio 2008 r2 (SSMS) on my virtual server and i configured the instance ...
0
votes
1answer
71 views
can I copy-paste SQL Server 2005 Express on XP Pro or Vista machine and make it work without installer?
I am having installer problems on several machines trying to install SQL Server Express 2005 Express as well as later versions (but I would be happy with 2005 anyway). However, I do have one machine ...
3
votes
1answer
696 views
How to find the detail cpu high process name which occupying most resource in the SQL Server database?
I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env.
DECLARE @ts_now bigint;
SELECT @ts_now = cpu_ticks / CONVERT(float, ...
