|
|
|
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 |
Filter by week: 1 2 3 4 5 SQL Server Developer w/Multiple Profiles Posted by CJF at 11/30/2004 8:15:02 PM Hi, I'm just starting to use SQL Server Developer Edition on my laptop.
When I'm networked I sometimes need to copy databases onto my local SQL
Server using DTS, which requires a networked account with local admin
privelages on the local machine and remote machine; however, when I need to
...more >>
datetime to smalldatetime Posted by Gerald Baeck at 11/30/2004 5:55:21 PM Is there a way to convert a datetime field to a smalldatetime field. I try
to Update the filed with a cast or convert function it htrows an overflow
exception, also changing the datatype via mmc is not possible.
thx, Gerald.
...more >>
triggers Posted by ayordy at 11/30/2004 5:15:03 PM will a update trigger fire a insert and/or delete trigger?...more >>
triggers Posted by ayordy at 11/30/2004 5:13:05 PM will an update trigger fire an insert and/or delete trigger?...more >>
FW: how to exclude weekends from a datediff? Posted by meg at 11/30/2004 4:47:33 PM "meg" wrote:
I've created the calendar table and inserted my holidays, however I just don't know how to implement the
query. If anyone has any experience with this I would greatly appreciate it!!
Thanks,
meg
"Alejandro Mesa" <AlejandroMesa@discussions.microsoft.comwrote in me...more >>
Migrating Informix Database to SQL Server Database Posted by -herbO- at 11/30/2004 8:19:02 AM I used the Data Transformation Services Import Wizard to create SQL Server
(SS) database and everything went weel up to a point. The tables were
created and they were loaded with the data found on the Informix DB. What I
also need are the parent-child relationships (primary/foreign keys) an...more >>
Error 5 - (Access is denied.) Posted by Freedomring at 11/30/2004 5:07:04 AM I have upgraded an NT 4.0 server to Win2k server. The NT 4.0 server had SQL
Server 2000 on it. Once the upgrade was done and the server rebooted and SQL
Server did not start on boot up. When I tried to manually start it I
received an error saying Access Denied, clicked ok and received a SQL...more >>
Error 5 - (Access is denied.) Posted by Freedomring at 11/30/2004 5:07:02 AM I have upgraded an NT 4.0 server to Win2k server. The NT 4.0 server had SQL
Server 2000 on it. Once the upgrade was done and the server rebooted and SQL
Server did not start on boot up. When I tried to manually start it I
received an error saying Access Denied, clicked ok and received a SQL...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error is storing data Posted by wessam at 11/30/2004 4:41:04 AM Hello,
i've made an application with the vb.net and i created my connection
through the sql server by stored procedure. The identity of the [ID] of the
table that the data is stored in is on and i've entered some data as a trial.
Then i've deleted the rows that i've entered and i made the id...more >>
unable to install microsoft sql server 2000 developer 64 bit to wi Posted by leong at 11/30/2004 4:35:01 AM I bought microsoft sql server 200 developer edition 64 bit. I try to install
to my window 2000 xp professional,but can't install.The message always prompt
that "setup.exe can run in win32 application",why like that??
How to solve this problem?Thanks.
warmest regards,
leong...more >>
SQL 2000 issues in XP Posted by Andrew K at 11/29/2004 11:49:06 PM Hi,
I am having issues running SQL server 2000 on my XP box. after installation
I am unable to gain access to the local server group. I get continual log in
errors. I am unable to regisiter new servers. SQL server just wont start.
I have installed and uninstalled a couple of times with di...more >>
Installing SQL Server 2000 Standard Edi. on Windows XP Posted by MM at 11/29/2004 8:25:03 PM Hi,
I know that SQL Standard Edition would not let me install the Database
Server in my machine. But will let me install only client components.
the message I get is as follow:
Microsoft SQL Server 2000 Standard Edition server component is not support
on this operating system. Only client...more >>
SQL 2000 client install error Posted by GG at 11/29/2004 5:45:05 PM who can help for this:
install SQL2000 client on Win2k / Winxp, meet the folllowing error:
setup cannot continute because some system files are out of date on your
system, click OK if you would like setup to update these files for you now.
You will need to restart Windows before you can ru...more >>
Newbie: Help with T-SQL Posted by Kaimuri at 11/29/2004 2:40:41 PM I have created a table called events with default Start and End Dates. I
would like to modify the EndDate. Here's the table created.
CREATE TABLE Events
(
EventID int IDENTITY(1,1) NOT NULL,
EventType nvarchar(10) NOT NULL Default 'Party', EventTitle nvarchar(100)
NULL, EventDescript...more >>
ASP, looping, and stored procedures.... error '800a0bb9' ... Posted by Beau at 11/29/2004 10:50:06 AM Hi all, thanks in advance.
Ok, heres the story.
What is happening......
--------------------------------
I've got an ASP page that loops.
It loops in order to get data in different, sequential date ranges. I.E.
from 9/1/2000 - 10/1/2000 then 10/1/2000 - 11/1/2000 etc etc etc.
It calls SPs...more >>
EMAIL SQL Posted by Tom at 11/29/2004 8:21:02 AM Hello
I have several w2k3 ent servers running sql2k. They all replicate to a main
server which is working great. What i would like to do is have the main
server page me or email me when an error accurs with the replication. Is this
possible? Thanks for any insight!
--
TC
...more >>
OO and high performance needs. (Is SQL the answer ?) Posted by Acoquinar at 11/29/2004 6:53:03 AM Greetings,
Our application is in VC++ and our business logic involves intensive
calculations on huge amounts of data.
For business reasons, we're forced to use MS SQL and not the obvious ODBMS.
We were wondering if anyone would be in the same situation and if anyone
chose to use an Ob...more >>
SQL Server 2000 doesn't like my SQL Server 7 query Posted by Paul at 11/29/2004 5:39:03 AM Hi
I have a very large program which includes a facility which allows users to
search for a client based on a number of parameters they select.
This has worked perfectly with SQL Server 7 and MSDE until we upgraded to
SQL Server 2000.
Query analyser returns results when connected to SQL...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |