all groups > sql server new users > august 2007 > threads for august 8 - 14, 2007
Filter by week: 1 2 3 4 5
SQL 2005 express
Posted by april at 8/14/2007 2:05:03 PM
When I tried to apply service pack 2 for SQL 2005, it wont let me update
Database services (status NA). Why is that? After the update,
MSSQLServer still stays version 1399 for the original. Can someone advise?... more >>
Snapshot or backup restoration
Posted by Jim in Arizona at 8/14/2007 9:49:41 AM
We have two SQL2000 standard machines (two seperate boxes). One is our
primary, production database and the other is a testing database which has a
copy of the database from the production server.
Being tasked with making the testing server up-to-date, I was wondering
which would be a bette... more >>
Rename
Posted by Dr.Acrobat at 8/14/2007 12:00:00 AM
Is possible create a script for rename some file with date/time for name???
Thanks.
... more >>
mysql+php
Posted by Shakeel Ahmad at 8/13/2007 9:41:07 PM
is there any server other than apache that is easy to use which can be used
with mysql and php?
i am trying to use apache but it is not working on my computer....
IIS works on my computer...........
... more >>
propery assigning data to a variable in a select statement
Posted by Jim in Arizona at 8/13/2007 2:34:03 PM
I got this error:
A SELECT statement that assigns a value to a variable must not be combined
with data-retrieval operations.
This is the select statment I used.
select
amount=(total-paid)
,datedue=dateadd(day, cast(@value as int), [date])
,total
,paid
,stmtdate
,guarantor
,@invoic... more >>
Question about sql server express edition?
Posted by Paul at 8/11/2007 5:04:40 PM
Can I create an vb.net client/server Windows application using SQL Express
as the backend database? If so what is the pros and cons as to compare it
with the Access database?
... more >>
Looping through results, placing into 1 result set
Posted by Jim in Arizona at 8/10/2007 10:22:31 AM
I'm experimenting with some SQL trying to add the rows from a single column
into a variable then looping through it to produce a single result set of
all the returned rows. I can get the loop but produce one result set per row
of data.
I'm using a cursor (first time in eveer trying to attem... more >>
How to kill users who has blkby <> . (SQL Server 2005)
Posted by Winanjaya at 8/10/2007 5:02:02 AM
Dear All,
I am running SQL Server 2005, how to kill users who has blkby <> . at once ?
currenly, I am running it manually by running the following:
sp_who2
kill <n>
one by one
Please help
Thanks & Regards
Winanjaya... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can't Create database diagram in sql2005
Posted by dotComPaJi at 8/8/2007 12:00:00 AM
I am new to SQL 2005 and want create a new database diagram but in my SQL
server in Database Diagram I cannot find 'New Database Diagram Node" any
Idea Why??
Following are my steps
1.. On the View menu, click Object Explorer.
2.. Open the Databases node and then open the <My Datanas... more >>
|