| Groups | Blog | Home |
|
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 Help! - Which Direction? Posted by newbie at 4/28/2006 11:35:07 PM Hi,
I'm new to SQL Server, I tend to use it quite a lot in my day-to-day work so
I want to learn more.
I'm interested in reporting - creating charts and displaying query outputs
etc.
Where should I start, what would be a good MCP exam to go for with the above
in mind?
Thanks ...more >>
Operating System (CmdExec), SQLCMD Posted by Donald at 4/28/2006 4:25:42 PM Hello everyone,
I want to know if this is a SQL Server Management Studio Bug or something
that I am missing. I want to setup a job to call SQLCMD to execute a sql
script:
sqlcmd -S MySQLServer -d tempdb -i c:\mySQLCmdTest.sql -o
c:\mySQLCmdTest.txt
This command works fine in ...more >>
What is a valid setting for DB Owner in Sql Server 2005? Posted by keithb at 4/27/2006 8:53:34 PM A database that was moved from SQL Server 2000 to 2005 displays the
following message when Database Diagrams is selected from within SQL Server
Management Studio:
"Database diagram support objects cannot be installed because the database
does not have a valid owner. To continue, first use t...more >>
Difference between Sql Server 2005 Management Studio Express and Management Studio Standard Edition? Posted by keithb at 4/27/2006 7:41:50 PM Is there any difference between SQL Server Management Studio Express and the
management studio that comes with SQL Server 2005 standard edition?
Specifically, is diagramming missing from both?
Thanks,
Keith
...more >>
how can a file be created through a trigger or stored procedure Posted by shoeb ali at 4/27/2006 10:53:48 AM i want to create a text file each time the table is updated. how can i
achieve it through stored procedure or trigger
...more >>
SQLServer doing math. Posted by Christoph at 4/26/2006 9:35:18 AM Could someone explain to me what's going on here? I'm obviously missing
something
DECLARE @annualisedPremium money
DECLARE @totalPolicyPremium money
SELECT @totalPolicyPremium = 2500.0000
SELECT @annualisedPremium = (( @totalPolicyPremium / 365 ) * 365 )
SELECT @totalPolicyPr...more >>
SQL Server Express limitations Posted by Dave Joyner at 4/26/2006 9:34:46 AM My boss is trying to answer the question: Is there a limit to the number
of concurrent "users" in SQL Server Express 2005 ?
I realize the hardware limitations of SSE (1GB ram, 1 processor, 4GB
database size) but management unearthed a document from 11/05 from
Microsoft that seemed to indica...more >>
trigger is not fired Posted by sachin bhayana at 4/26/2006 12:00:00 AM I have attatched a trigger with the insertion of a table but when i insert
into the table the trigger is not fired.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Comparison map of SQL Express and other editions Posted by Kenneth E. at 4/26/2006 12:00:00 AM Hi,
I'm trying to figure what features each edition has, and in particular the
webservice/soap connectivity.
Can someone point me to a link or something that tells wether or not the
edition supports native web services.
Thank you in advance!
...more >>
Performance and Time-Outs Posted by Alastair Williamson at 4/26/2006 12:00:00 AM Hello there,
I hope this question is not too general to make it un-answerable.
We have been running Sql Server 2000 for 3 years now without too many
problems. We are not sql server experts, the databases are mainly data dumps
for applications which simply read, write and update, so we have...more >>
Identity column Posted by KatMagic at 4/25/2006 4:50:50 PM Is there a way to get sql to "fill in the blanks" so to speak. I have a
database where the identity number field goes up to 100,000, although we
have no where near that many records. I have some new data I have to import
and they don't want them to be over 100,000. I tried creating a new ta...more >>
It can't be this hard Posted by keithb at 4/25/2006 8:58:33 AM I just want to move my database from sqlserver 2000 to sqlserver2005. I use
Enterprise Manager, select backup, database complete and create a file with
a bak extension. Then I open sql server management studio express, select
restore database, select from a device and enter the backup file pat...more >>
i need Code Generator... Posted by Tark Siala at 4/24/2006 4:51:54 PM hi
i spend more time to write the code, like VB6, VB2005, SQL Stored Procedure
code.
any one know good Application to Automaticaly read Database (Access or SQL),
then write VB Code and Stored Procedure (if this allication free thats good
:) )
--
Tarek M. Siala
...more >>
msde setup Posted by Sam at 4/24/2006 12:00:00 AM msde setup failes with request for strong sapwd
how can i mannage it?
thanks
...more >>
Getting Access Data into SQL Server 2005 Posted by ibeetb at 4/23/2006 8:53:50 PM We have tables of data with about 10000 rows. What is the best way to get
this data into Sql Server 2005. We want toi transfer from Access 2003 to Sql
Server 2005 and want our access data in a sql server table
...more >>
New to Clustoring/Failover Questions Posted by Dennis Burgess at 4/22/2006 11:18:54 AM Simply put we have a Single SQL 2005 server running our applications. This
server runs great, low load, databases under 200 meg mostly, maybe 2 gig of
total data.
We do backup via NetVault to tape everynight.
What we want though, is a SECOND, physical server with the same databases,
tha...more >>
how to group only by DATE, not include time Posted by Taoge at 4/22/2006 12:00:00 AM Hi,
SQL Server only has datetime datatype, but in most of the case, we only need
date. If data the datetime column has time, how to group only by date.
for example,
If the table has following data
ColDatetime
04/20/06 12:23:35
04/20/06 13:23:00
04/20/06 14:23:00
If run
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |