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
Verify upgrade path12 Mar 2008 09:16 GMT1
I was trying to verify that one cannot directly upgrade from MSDE to SQL 2005
Standard.  Is this correct?  If so what would the proper path be?
Thanks,
Brian
CASE problems with select statement.12 Mar 2008 02:49 GMT5
I'm trying to build a select statement using the CASE expression. All
I want is to build the WHERE piece of the select statement based on a
parameter value.
I want to somehow CASE the WHERE clause based on a parameter of let's
Total # of records.12 Mar 2008 00:52 GMT3
Ok, this is dumb. How do I get the total number of records in an SQL table.
I know I've done this before, but the mind is mush.
Thanks.
Mirror Status Change12 Mar 2008 00:06 GMT3
How can I determine when the status of a mirrored database on a server
changes from Principal to Mirrored?
Also, can I determine who or what caused the status to change?
adding datafile to database11 Mar 2008 23:22 GMT1
sql server 2000 sp4
Hi
I have a database that was initially created for 70MB. It has a application
associated with it and can not be deleted. I need to increase size of the
Clustered Index quetion11 Mar 2008 23:20 GMT1
I want to implement clustered indexes on some tables and have a couple of
questions.  I read that a clustered index has its columns shared with
non-clustered indexes by default.  Does that mean I can remove the columns
found in the clustered index from the non-clustered indexes?
EXECUTE AS question11 Mar 2008 22:04 GMT3
I'm trying to give my users the ability to run sp_who2 on SQL 2005 and
see all sessions, without granting them additional permissions.  I
thought I could do something like this:
CREATE PROCEDURE [dbo].[sp_who2_all]
Simple SQL 2005 install question11 Mar 2008 20:31 GMT3
Good Day,
We have a SQL 2000 and we are planning on upgrading to SQL 2005.  Our
current copy of SQL is installed on the C drive of the server but do to size
restraints on the C drive and other issues  I am looking at doing a side by
backup size and initial database size11 Mar 2008 19:05 GMT3
SQL server 2000
Hi
How can i find
1. Information about all/current  backup files, size of backup file on
Help with weird error11 Mar 2008 15:14 GMT2
I am working with Access frontends and a SQL Server 2000 backend.
One user gets the following error when trying to insert directly into
a table through access or through a form into that same table: "String
or binary data would be truncated". It doesn't matter into which type
How to get results back from a Stored procedure.11 Mar 2008 14:53 GMT1
I have a stored procedure1 calling stored procedure 2. Stored
procedure 2 when it is finished returns a single row with 2 columns.
Is there a way to grab the return of column 1 from stored procedure 2
inside stored procedure 1?
next run date11 Mar 2008 13:46 GMT3
I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?
Linked server11 Mar 2008 13:37 GMT1
i have added a linked server (Linkser)having sybase db in mssql server.i
added a
procedure for getting data from Linkser
SET ANSI_NULLS ON
Backup from SQL Server 2005 - restore to 200011 Mar 2008 12:53 GMT6
I need to restore a backup of a db in SQL 2005 with 80-compatibility level
into SQL Server 2000. I have tried to do it but I have an error. Is it
possible to do it?
Does exist another fast method to bring a SQL Server 2005 db into 2000?
Finding Sql Server Licensing information11 Mar 2008 11:47 GMT1
I want to retrive the licensing information such as Licensing count, which
licensing is currently in use, whats its type (per processer or per user),
licensing code etc. From where i can retrive the information? I want to do it
for Sql Server 2005 and 2000. I read the blog ...
 
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.