|
|
|
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 >>
How to use Access 2003 with SQL Server 2005? Posted by ibeetb at 4/21/2006 4:39:40 PM Can someone tell me the best way to use My Access queries and forms with a
SQL Server 2005 DB
...more >>
Difference between Local System, Local Service, Network Service Posted by Wade at 4/20/2006 1:47:43 PM Under the SQL Server Properties dialog (I'm using SQL Express 2005) the "Log
in as: - Built-in account" lists Local System, Local Service and Network
Service.
What are the differences between these?
If I install SQL Express 2005 on a Windows 2003 Domain Controller, Local
Service and Netw...more >>
how i can connect to table in SQL? Posted by Tark Siala at 4/19/2006 5:30:13 PM hi
i working on VB6 + SQL2000
i have table called (tblBuffer)
and want do something in my application everytime table added new record
(its like trigger in SQL)
thats mean if someone add new record to this table, this table call my
application to do some event.
now i made small monitor (w...more >>
How to get started creating a cross tab report? Posted by MickeyD at 4/19/2006 10:01:02 AM Hi,
I am a SQL Server 2005 Newbie. I got the task of getting data from a
reporting server view. I can do basic SQL queries. My question is how do I
get started if I want to create a report without having to import this into
Excel and transpose. I have to extract data from users who answer Q...more >>
Generate SQL Script using a DTS Posted by Matt C at 4/19/2006 6:23:54 AM Hi
Each month I back up the structure of our databases by right-clicking
on each database and select Generate SQL Script...
>From the General tab I select script all objects and from the Options
tab I select script database, along with script indexes and script
primary keys.
As we have s...more >>
need some help with reporting? Posted by _adrian at 4/18/2006 4:13:00 PM So, my client says that they need to take existing SQL Server table data,
and export the contents to a tabbed-delimited text flat file. I've been
told that Reporting Svcs can do this for me, and even help email that flat
file to teh client (which would be great!)...
Can anyone confirm this ...more >>
backup restored to other machine is missing stored proc and functions Posted by keithb at 4/18/2006 8:41:39 AM I made a backup of my sql server 2000 database and restored it to sql server
2000 on another machine. Checking the restored database, several of my most
recently created stored procedures and functions were not there. What causes
this, and how can I make sure that the most recent version of my...more >>
update table1 from table2 Posted by Matt Williamson at 4/17/2006 5:09:23 PM I'm having way more trouble with this than I should be. There are no
constraints on either table. This is just a temporary data dump to export to
a file.
I just want to update a field in one table (AcctNum) with the same field
from another table using a common column (Name).
ex.
Table...more >>
Which is Better/Stable: 2000 or 2005 Posted by ibeetb at 4/17/2006 4:23:52 PM Trying to decide which is better and more stable SQl Srver 2000 or 2005.
(also, which is easier?)
Can anyone provide any key points?
Thank you
...more >>
Need to extract data Posted by _adrian at 4/17/2006 1:07:05 PM I need to be able to take an existing table's data, and automatically export
it to a tab delimited text flat file. Suggestions / tutorials on how this
can be done? I then need to be able to call this from ASP...
...more >>
Deadlocks Posted by Diane at 4/17/2006 5:48:02 AM This seems to be a popular subject, but I didn't quite find what I was
looking for so here goes ...
I am getting user deadlocks (from what the client tells me). It is
perceived to be occurring when one user is importing a fairly large file into
a table where someone else has accessed a rec...more >>
Syntax problem with SCHEMA_ID Posted by Greg at 4/16/2006 12:00:00 AM Hello
I came across this problem with SCHEMA_ID,
then I tried DB_ID and the same problem appeared,
though DB_ID works at the beginning of my SQL script.
What's wrong?
Sorry if it's a dumb question, I can't think up anything now.
IF SCHEMA_ID('Administration') IS NULL
CREATE SCHEMA Adminis...more >>
Export SQL Data Newbe Question Posted by Thomas Grassi at 4/14/2006 11:35:34 PM I am trying to export my SQL database to Access and it seems to not be
exporting all records. Any Ideas on why?
SQL Server 2000 Developer Edition running on Windows XP Pro SP 2
Access is Office XP SP3
Thanks
Tom
...more >>
Intelligent/weighted search...how to start? Posted by msft-sql at 4/14/2006 1:41:28 PM Hi: I have a simple search page that queries a SQL product dB by breaking
apart multi-word queries, strips out plurals, punctuation and other
conditions, then builds a query first using "and" between the query terms,
and if it finds no results, re-runs the query using "or" between the query
...more >>
Heterogeneous queries and Linked servers Posted by garth at 4/14/2006 9:46:39 AM I have enable both options on both linked servers on the "connections" =
tab. However I continually get this error message when running my query.
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options =
to be set for the connection. This ensures consistent query semantics. =
En...more >>
Backups - Backup Device on Disk?? Jobs vs Maintenance Plans?? Posted by neemic at 4/12/2006 11:20:01 PM Hi there -
Apologies if this has been covered many times here - I have searched and
found related questions but not exactly what I need.
I need to set up backup / recovery procedure for a SQL Server 2000 instance.
It will be a Production system, but requires no point in time recovery so
...more >>
getting smalldatetimes for grouping Posted by Daves at 4/12/2006 1:34:03 AM hi,
a table has logged all logins for a long period as
DateIn datetime
UserID int
I need to return a table with short-date-formats (dd.mm.yyyy), count(UserId)
to databind with a graphical chart.
How can I easily convert the long dateformats to short ones (that is; skip
the times)?
...more >>
Linked Servers Posted by garth at 4/11/2006 4:45:52 PM In SQL 2k, can a linked server have a "-" within it's name? If not how can I
get around this issue with one of my SQL server having a hyphen it is name?
...more >>
Extracting a list of all tables and their row headers Posted by Bill Bradley at 4/11/2006 4:28:43 AM I have an SMS 2003 SP1 server using SQL 2K SP4. Since MS doesn't publish a
listing of the SMS Views or Tables, I am usually searching around for the
(thousands) of right Row to use to query for things.
I'd like to be able to do a dump of ALL the Tables with their Row Headers or
Names into ...more >>
Viewing MULTIPLE databases from the same SQL registration in ENTERPRISE manager Posted by Darrel at 4/10/2006 10:48:30 PM This might be a dumb quesiton, but...I'm stumped...
At my web host, I have more than one client that end up with their database
on the same server.
In Enterprise Manager, I have a server registration pointing at the server,
with a username/pwd.
Of all the databases listed, I can only ac...more >>
newbie view problems Posted by Thomas Homan at 4/10/2006 4:36:42 PM Hello all,
I'm attempting to construct a view and one area is giving me fits if I may
ask for help.
My problem:
in tbPARCEL_SALE_DOCKET.INST_TYPE I have approx 10k rows (of 200k)
containing a value of 0
in luINST_TYPE.INST_TYPE there is no value 0 to look up.
When I query the view and...more >>
Transaction log backup ERROR Posted by msnews.microsoft.com at 4/10/2006 2:42:49 PM Sorry if this is not the best place to post this, please direct me and I
shall follow instructions..
Created a new maintenance plan to backup transaction logs and if seemed to
work fine except I got the following at the end of the txt message, and is
shows FAILED in the history. here is th...more >>
Error when trying to start sql server agent Posted by Alejandro at 4/10/2006 1:37:57 AM I get the following error when trying to start the sql server agent:
[241] Startup error: Unable to initialize error reporting system (reason:
The EventLog service has not been started)
The "EventLog" service is not listed in the services running. Though the dll
is there.
Any ideas ?
...more >>
Create View Query Posted by Steve at 4/9/2006 2:39:27 PM Hi All:
I am brand new to sql server.
I have been provided a query to establish a view.
CREATE VIEW dbo.View6
AS
SELECT TOP 100 PERCENT dbo.Manufacturers.Name AS Expr1,
dbo.Cigars.Cigar, dbo.Cigars.Length, dbo.Size.EnglishSize,
dbo.Shape.Name AS Expr2
FROM ...more >>
sql 2000 or sql 2005 express..? Posted by Henri at 4/8/2006 8:01:01 AM I'm a bit confused about this:
I'm installing a WS2003Standard - and have several choises for further
installs - like - SQL2000, SQL2005Express, WSS and SPS..
Could someone enlighten me on this:
On previous installs I have installed SQL2000 and WSS..
Now I would like to try something new - s...more >>
Auto Generating Field Posted by Mike TI at 4/7/2006 10:08:32 PM April 7, 2006
Hi all
I am new to SQL server and am using SQLEXPRESS 2005.
I want to add a field that should be unique and auto generating. Even if a
record is deleted, the value of this field should not change.
Thanks
...more >>
instance of sqlDataReader - is not available to an exteranl method Posted by Web learner at 4/7/2006 5:48:40 PM I am trying to create a method GetDataFor(string column) becaues I have =
to repeat the same statements for several columns but I get an error as =
follows:
The name 'dr' does not exist in the current context
It seems the dr -the instance of sqlDataReader - is not becoming =
available to th...more >>
Booleen: Testing if one field equals another Posted by Conan Kelly at 4/6/2006 10:55:57 AM Hello all,
In Excel I can enter the formula "=A1=B1" to return TRUE/FALSE.
Is there a way of creating a calculated field in Query/View Design that will do the same thing. I tried [AcctNbr] = [AltAcctNbr]
and all it did was put single quotes around it: '[AcctNbr] = [AltAcctNbr]' which mean...more >>
Sql server 2005 back up Posted by Richard at 4/6/2006 12:00:00 AM Hi
I have set up Sql Server 2005 and I am planning to move the existing
msaccess to the server. Appreciate if someone out there might help me on
some issues I need to clear up.
1. If I backup (copy), do I copy the whole folder MSSQL , the 'data' folder
or just the mdf file?
2. If I lose ...more >>
Specified cast is not valid, when column returns NULL Posted by Web learner at 4/5/2006 7:30:12 PM while (dr.Read())=20
//dr is an instance of sqlDataReader
{
double minAirTemp =3D (double)(Single)dr["minAirTemp"];
// minAirTemp is column in SQLExpress table (data type: real, =
allows nulls)=20
}
The above code works. But when there are NULL, I get the following error
System.In...more >>
Problem with table owners (2) Posted by david epsom dot com dot au at 4/5/2006 12:00:00 AM Is there any special permission that is required for 'user1' to
be able to create tables as 'dbo'?
Is there any particular advantage or disadvantage to having
tables owned by "db_admin" or "dbo"?
I think that up to now, we have been lucky, 'sa' has been the
login name for dbo, the only user...more >>
Disabled indexes Posted by Rich Belanger at 4/5/2006 12:00:00 AM Is there a catalog view that shows what indexes are disabled?
Rich Belanger
...more >>
Year only data from daily dates Posted by Web learner at 4/4/2006 8:33:36 PM I have daily data from year 1995 to 2004. The following query
SELECT [obsDate] FROM [tblObs]
returns 3653 datevalue records for each day.
1995-01-01 00:00:00
1995-01-02 00:00:00
1995-01-03 00:00:00
----------------------
----------------------
2004-12-29 00:00:00
2004-12-30 00:00:00
200...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |