|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 August 2008 |
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 Erro while changing database to multi_user mode Posted by Suresh at 4/29/2007 11:50:02 PM Hi,
I'm trying to change database from restricted_mode to multi_user mode. I'm
running the following command:
ALTER DATABASE MyDatabase
SET MULTI_USER WITH ROLLBACK IMMEDIATE
If any user is connected to database, the above statement fails and gives
the error as shown below:
Msg 1222...more >>
How to improve data transfer speed on link server Posted by M A Srinivas at 4/29/2007 10:42:26 PM
Server A
SQL 2000 SP4
Server B
SQL Server 2005 SP1
They are connected through internet
Server A and B are geographically located around 2000 miles apart
Statement at Server A : select * from serverB.databseB.dbo.tableB
No WHERE Clause in the statement . Currently 1 miiilion row ...more >>
Take database offline runs forever? Posted by Olav at 4/29/2007 9:37:00 PM I have a web application that uses a database and it does of course have new
requests all the time. When I attempt to take the database offline, it runs
forever.
How can I stop new requests to the database, let existing requests run to
complete and then get the database offline?
Olav
...more >>
Access to SQL 2005 and spaces in object names. Posted by Nishant at 4/29/2007 9:24:01 PM Hi,
We need to migrate Access 2000 databases to SQL2005. the table names and the
column names have spaces in them in the original access database.
Acesss reports will be used against SQL2005 instead on Access after migration.
An initial test of the reports againts a migrated SQL2005 datab...more >>
How to increase timeout value? Posted by Olav at 4/29/2007 8:58:06 PM 'LogActivity' table
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
How can I increase the timeout value?
Olav
...more >>
NVarChar vs. NText Posted by scott at 4/29/2007 6:31:53 PM I need a field to hold the maximum amount of characters as possible. Which
data type is best for such a requirement?
I've used nvarchar in the past, but wanted to know if there are any
advantages when using ntext instead of nvarchar.
thanks for any insight.
...more >>
SQL Server 2005 Tips and Tricks Posted by Never at 4/29/2007 4:22:47 PM Having been in software industry for more than 9 years, I feel this is
the time to share my little knowledge. I have started my own blog
called SQLTips. This blog is totally focused on SQL Server 2005 tips
and tricks and provides solution for day to day issues in SQL Server.
I am trying to cov...more >>
Universal Time to Pacific Time Conversion Posted by imani_technology_spam NO[at]SPAM yahoo.com at 4/29/2007 10:15:26 AM We have data stored in a datetime field that is in the Universal Time
(UT) Zone. We need to convert it into Pacific Standard Time or
possibly Pacific Daylight Time. Is there a function for converting
time from UT to PST or PDT?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Running Time Posted by shapper at 4/29/2007 7:07:23 AM Hello,
I have two tables: Articles and Comments
I need to Select some articles (no more than 20) and for each article
I need to select its Comments.
I am populating a .Net class with the data.
As far as I can see, I can do this in two ways:
1. Use Inner Join in my SQL stored procedur...more >>
Need help with SQL count, most popular Posted by Bonzol at 4/29/2007 5:36:00 AM Hey there
I need to find the most popular course,, so the course(s) with the
most amount of stdNo,, and not display the others.
So far ive tried this
SELECT R.courseID, C.cName
FROM Register AS R INNER JOIN
Course AS C ON R.courseID = C.courseID
WHERE (COUNT(*) > ANY
(SELECT COUNT(*) AS ...more >>
Creating Data Sources (ODBC) via code Posted by John at 4/29/2007 3:39:10 AM Hi
I need to create a User DSN based on SQL Server driver under Data Sources
(ODBC). As I need to do it on multiple PCs, is there a script or another
automated way to do this quickly?
Thanks
Regards
...more >>
Dynamic Search Posted by Alex at 4/29/2007 12:00:00 AM Hello, (SQL Server 2000 (s3))
I read this great article but i need let me say a little bit more
http://www.sommarskog.se/dyn-search.html
CREATE PROCEDURE search_orders
@orderid int = NULL,
@fromdate datetime = NULL,
@todate...more >>
Function Sequence error? Posted by Olav at 4/29/2007 12:00:00 AM I have a strange problem. Sometimes I get a "ERROR [HY010] [Microsoft][ODBC
SQL Server Driver]Function sequence error" in my code (see code included
below).
How can the below code cause a Function Sequence error?
Olav
public static System.Decimal LogActivity(int userId, string ipAddre...more >>
concating columns Posted by perspolis at 4/29/2007 12:00:00 AM Hi all
I have a table name Group that has a relation with itself.
GroupTable
Code int,
Name varchar (50),
ParentId int
in this table Code has a relationship with ParentId.
I want to concat Name column heirarchically.
thanks in advance
...more >>
Run the script if database does not exists Posted by Alan T at 4/29/2007 12:00:00 AM I want to create a database if not exists, I tried something like:
if not exists (select * fron master.sysdatabase... name = N'Employee)
return
else
begin
create table1...
create table2...
end
go
However, I got a error something like:
cannot locate entry point....
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |