|
|
|
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 |
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 31 service account Posted by Mahesh at 1/8/2006 11:39:02 PM i am starting my sql server and agent with a domain account
for eg domain/user..
Is this account should be present in sql server logins...?
what problem i will face if i remove this login?
i have removed this account but everything seems to be ok...
please help
Thanks in advance...more >>
ignore duplicates from joined tables Posted by enrique at 1/8/2006 11:17:02 PM Hi,
I'm trying to SELECT from two tables with a LEFT OUTER JOIN but I can't seem
to figure out how to return the query without the duplicates.
I know DISTICT works when querying one table but how do I ignore duplicates,
specifically in the primary key (ID) from joined tables?
Here is my b...more >>
Sql Server Express and VS2003 Posted by West at 1/8/2006 9:48:02 PM Hi
Can I build an application with VS 2003 that connects to a Sql Server
Express 2005 instance. And if so what library and object would I use to
connect and communicate with the Sql Server Express 2005 instance, the
programming language of choice would be C#...more >>
There are some bugs for Management Studio. Posted by Frank Lee at 1/8/2006 8:57:52 PM 1.The items in a project cannot have a path different with Project's.
ex. If project is under c:\a\ and the item is under c:\a\items\, it will got
problem to open the item next time user reopen this project.
2.Cannot create a new query folder under a project. However, user can setup
a new...more >>
month and 2 digit year Posted by Scott at 1/8/2006 8:10:30 PM How can I get the month and 2 digit year from a date? For example, how could
I return the month/year like my DESIRED RESULTS 1 & 2 below? Both examples
equal January, 2005? DATEPART seems to only allow 4 digit years.
CODE:
SELECT DATEPART(yy, GETDATE())
Desired Results 1: 05-1
Des...more >>
How to drop sql server object? Posted by celia at 1/8/2006 7:52:42 PM Hi,
I am getting errors when I try to drop a column in sql server table.
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF__hdp_langu__langn__29572725' is dependent on column
'langname_ge'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN langname_ge failed beca...more >>
Detaching & Attaching Database Posted by Terry at 1/8/2006 5:50:06 PM Hello Group.
I have the following problem using SQL Server 2000 on WinXP machine.
I detached a SQL database and then performed a windows copy of the database
to another folder on the system.
I then renamed the database and tried to attach the renamed database to SQL.
SQL sees the old name a...more >>
Client connectivity to SQL Server 2005 Posted by clarkbones NO[at]SPAM rocketmail.com at 1/8/2006 4:00:43 PM Hello!
I am developing an application that will connect to a SQL Server 2005
(including Analysis Services) database. The SQL database will reside on
a server, not on the client my app will be installed on.
I am creating a setup program and I guess that I need to redistribute
the client conn...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Client connectivity to SQL Server 2005 Posted by clarkbones NO[at]SPAM rocketmail.com at 1/8/2006 3:58:09 PM Hello!
I am developing an application that will connect to a SQL Server 2005
(including Analysis Services) database. The SQL database will reside on
a server, not on the client my app will be installed on.
I am creating a setup program and I guess that I need to redistribute
the client conn...more >>
Date Posted by Trond Hoiberg at 1/8/2006 2:51:04 PM I have a SQL 2000 std server with SP4.
Is it possible to find excact date 24 months ago?
I mean if i use Select GETDATE() as Now i get todays date. But if i want to
find the date 24 months ago from todays date?
Select (GETDATE() - 24 months) as OldDate
any hint?
best regards
Trond
...more >>
Can a multi-column index be used for single-column searching? Posted by quizling NO[at]SPAM biztekinc.net at 1/8/2006 2:19:26 PM I know that in the case of some database engines a two-column index can
also be used to speed searches on the first of the two indexed columns
when searched singly, thereby making it unnecessary to create a
separate index on the first column.
For example, a two-column index in (lastname,firstn...more >>
Redeploying CLR UDT Posted by saarcarmi NO[at]SPAM gmail.com at 1/8/2006 10:28:13 AM Hi
I have a created a UDT in a .net assembly and deployed it to sql server
2005.
I have also created a table that uses that UDT.
How should I update my UDT?
It seems that if I want to fix a bug and re-deploy it I need to drop
table that uses it. Otherwise, I get an error saying
"Cannot dr...more >>
Getting a stored procedures return value -- URGENT !! Posted by Tim Greenwood at 1/8/2006 8:56:34 AM We've got some code that has been using a SqlCommand with the commandtype
set to Text. It is running a stored procedure by building a StringBuilder
object to string together the parameters and then execute. The problem I am
running into is that if I add a parameter to the commands paramter
...more >>
create new table based on union of range data Posted by Cathy Smith at 1/8/2006 6:58:30 AM Hi, I was hoping someone could help me out.
Is it possible for SQL to take a table which has date range data (start and
end date indicating the contract period of the client) and create a new
table which creates a union of 'unionizable' range data for each specific
client. For example (here...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |