all groups > sql server programming > september 2006 > threads for saturday september 30
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 29 30
SQL instance
Posted by Wasim at 9/30/2006 11:56:02 AM
I am trying to connect my laptopname,which has various SQL server 2005
databases on it by using Query Analyzer & Mgt. Studio but it gives me an
error as follws:
An error has occurred while establishing a connection to the server. When
"connecting to SQL Server 2005, this failure may b... more >>
getting strange error
Posted by Rudy at 9/30/2006 11:33:01 AM
Hi All!
I have a SP like this.
CREATE PROCEDURE [dbo].[GetNumWinners
AS
BEGIN
DECLARE @WinNum numeric(10)
DECLARE @Total numeric(20)
DECLARE @Win numeric(20)
DECLARE @UserID nvarchar
DECLARE @House numeric(20)
DECLARE @Guest numeric(20)
SET @WinNum = (SELECT COUNT(*) FROM TblUserID WHE... more >>
SSMS
Posted by Bob Johnson at 9/30/2006 11:04:24 AM
Is there any way in SSMS to have the query editor automatically convert all
keywords to upper case?
For example I type in this:
create procedure MyProcedure
.... and the query editor automatically converts it to this:
CREATE PROCEDURE MyProcedure
I'm thinking that - if it can turn keywo... more >>
Question about adding extended database file and transaction file
Posted by Antony at 9/30/2006 8:43:01 AM
I am using Small Business Server 2003. I think it come with SQL server 2000.
The transaction log is large and getting larger, moreover, a new project will
be add to the existing database in the near future. I am afraid the hard disk
is not large enough to hold the database + log. So I think ad... more >>
sharing a databse
Posted by S.Dickson NO[at]SPAM shos.co.uk at 9/30/2006 5:48:41 AM
I am very new to programing and serves ect and just learning.
have just set up a business with a freind but we both work fro home.
I have built an access database that we enter in ourcustomer details
and any orders they place with us.
As we both work from home we would like a way of sharin... more >>
Need help getting this .sql file into my SQL Server
Posted by MattD at 9/30/2006 12:34:20 AM
I was working originally with what turned out to be a very unreliable
Offshore IT firm in India. I had to finally sever our working
relationship with them. They were about 70% complete even though they
demanded 100% payment upfront. WON'T EVER DO THAT AGAIN!
My problem is they site me all the ... more >>
From 2000 to 2005
Posted by Bassam at 9/30/2006 12:00:00 AM
Hello
We will migrate from SQL Server 2000 to 2005 , side by side installation so
will keep both instances running at first ,
Is there an easy way of transferring all logins from 2000 to 2005 AND
associate them with database users in the database that will be manually
attached to 2005 ?
... more >>
|