Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
xp_cmdshell runs randomly11 Mar 2008 11:40 GMT2
I have a problem with the xp_cmdshell stored procedure on SQL Server
2005.
I've allowed its execution on the databases which require it, using
the sp_configure 'show advanced options' and sp_configure
Determine if MSDE or SQL Express is installed?11 Mar 2008 09:50 GMT1
Is there a best practice in determining whether MSDE installed on a
workstation or if SQL Express is installed?  The SQL Express installs
are all with the default named instance of .\SQLExpress, but it's not
otherwise generally known as to which version is present.
Close to real time sync for data in relational and flat schemas10 Mar 2008 23:22 GMT4
Can someone point me to the right direction?
I need to synchronize data updates in relational schema with data in it's
flat (denormalized) equivalent in near real time mode.
What is the best way to achieve this if using triggers is not an option ?
Can't import Access tables..?10 Mar 2008 22:27 GMT1
When I use the import Wizard in SQL-2005 I get the following message:
TITLE: SQL Server Import and Export Wizard
------------------------------
Error 0xc002f210: Preparation SQL Task: Executing the query "" failed
Updating Statistics10 Mar 2008 21:33 GMT3
I have a database which has logical fragmentation in some of the tables.
I have scripts that now will run an update_statisitics with fullscan on all
the objects.
I also have a job that perfroms a dbcc dbreindex on the indexes if the
Which SP2 for SQL Server do I install10 Mar 2008 21:20 GMT1
I have an x86 version of SQL Server 2005 installed on an x64 Windows Server
box.
Which SQL Server SP2 do I install?  The x86 one or the x64 one?
database size and raid configuration10 Mar 2008 21:07 GMT4
Hi
I need to provide following information:
1. Size of all the current databases on all sql server (2000 and 2005). Is
these a query I can use to get this information.
difference in file size on disk and sysaltfiles10 Mar 2008 21:01 GMT4
SQL server 2000
When i select size of files using sql server using
"select name,filename,size from sysaltfiles" I get size of files as
File one size: file1.mdf = 4976
Testing Phase - Migration from SQL 7 to SQL 2000 - Queries are slo10 Mar 2008 20:30 GMT1
We are using 2 CPUs which are quad core. We have one SQL 2000 License with
1CPU license.
The queries are  slow when upgraded to SQL 2000, We thought of upgrading to  
2 CPU license, Before buying we increased the SQL Proccessor usage to two the
nText and RTF format10 Mar 2008 17:31 GMT1
we have a field under nText which contains both text and RTF text!(database
design and app are by another company, no way to modify them)
simple select query returns normal values under text data, but when it is
RTF we get unnecessary info such as:
Weekly maintenance plan hogging system resources10 Mar 2008 17:23 GMT12
Our weekly maintenance plan takes up so much RAM on our Windows Server 2003  
with service pack 2 (2 GB of RAM) that we have to reboot the server the next
day in order to free up the RAM.
Besides adding more RAM, is there anything else that can be done to
Need help with SQL Select Count statement10 Mar 2008 12:58 GMT3
I want to pull records from a "Column" within a "Table".  I recall in the
past doing a:
SELECT COUNT "n" FROM .... (This is where I am lost!).
I am hoping to pull the contents of the column in a table.
Security context?10 Mar 2008 12:53 GMT2
SQL Server 2005 sp2
Windows Server 2003
I have a scheduled stored proc that executes Bulk Insert.  It works
fine.  Agent runs under a domain, sys admin account.  I know, I know,
query help10 Mar 2008 12:49 GMT1
I want to bring up the following data for groups:
Blue, Red, Green and Yellow.
I have the following view in sql 7 which brings up the data i want,  How can
i bring up the data for the other groups within the same query.
Reload an ASO.NET page on database insert10 Mar 2008 12:43 GMT1
Is there a way to reload an ASP.NET web page each time a new record gets
iinserted into an SQL database table?
Thank you i advance,
Hrvoje
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.