|
|
|
March 2003 April 2003 May 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 |
Filter by week: 1 2 3 4 5 NEWBIE: Query Help Please Posted by kambizg NO[at]SPAM cox.net at 6/29/2006 12:37:17 PM Hi All:
Here is my question:
I have a table with a field called REFNBR, this is defined as CHAR(10).
The current value in the field is '0000000000'.
I would like to update this field to '000000001', so I want to have a
stored procedure or an update statement that will increment this value...more >>
Is moving detach/attach, copying ldf/mdf reattact same as Upgrade/Migrate Posted by yanky at 6/29/2006 12:35:31 PM We have a SQL 2000 server. We want to get some of the databases over
to the new sql 2005 server. I have found many docs regarding 'moving'
databases from 2000 to 2005. Is this the same as
'Upgrading/Migrating'? I know there are issue with the DTS and
possibly the stored procedures. Do we lo...more >>
how/what should be the query for this result Posted by choudharymv NO[at]SPAM gmail.com at 6/28/2006 7:25:24 AM I have 1 table "Progress"
P_no b_no status build_date
----------------------------------------------------------------
25 1 First_slab 2006/4/5
25 1 second slab 2006/5/6
25 2 ...more >>
SQL Express (General Qs) Posted by Maura Jenkins at 6/27/2006 3:01:29 AM Hi ...
I would sincerely appreciate some input on a few questions related to SQL
Server Express:
(1) Is SQL Server Express free for business use ?
(2) Does the 1GB RAM limit does that mean SQLExpress will only use 1 GB or
the machine it's running can only have 1 GB installed ?
(3) Si...more >>
Have Insert statement, need equivalent Update. Posted by rhaazy at 6/26/2006 1:54:26 PM Using ms sql 2000
I have 2 tables.
I have a table which has information regarding a computer scan. Each
record in this table has a column called MAC which is the unique ID for
each Scan. The table in question holds the various scan results of
every scan from different computers. I have an ...more >>
Would replication work here? Posted by mkerrigan NO[at]SPAM ktoys.com at 6/26/2006 12:48:46 PM I have two databases on the same server. I want to populate and keep
synchronized a table on database 2 from a view on database 1. Whenever
data would change in the underlying tables on database 1, it would
update the table on database 2. Is this something that can be done
through replication...more >>
SELECT statement help Posted by schoultzy at 6/26/2006 12:36:19 PM Hello everyone,
I am working with the following code:
select section_master.trm_cde, section_master.crs_cde, crs_title,
crs_capacity,
crs_enrollment, section_master.udef_3a_1, monday, tuesday, wednesday,
thursday, friday, begin_time, end_time, bldg_cde, room_cde,
name_master.last_name
f...more >>
SQL Help Posted by Bill Schanks at 6/26/2006 9:13:31 AM I have this SQL:
SELECT
U.ID,
U.PrefID,
U.LastName,
U.FirstName,
U.FirstLogin,
U.LastLogin,
UserActive =
CASE
WHEN (U.LastLoginAppVersion = '' OR U.LastLoginAppVersion IS
NULL) THEN 'No'
ELSE 'Yes'
END,
COUNT(DISTINCT A.ID) AS AssingedIssues,
COUNT(DISTINCT R.ID) AS...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How do I query pc making call to data base? Posted by prumery NO[at]SPAM verizon.net at 6/25/2006 9:04:37 AM I'm using one account to connect to the 2005 express data base via
asp.net v2 and I want to get the users domain account and insert it
into journal tables. Is there a way for me to get the users domain
account from a stored procedure? If not, how would you track changes
to data from a shared a...more >>
Exporting Table with Data to Script text file in MSSQL 2005 ? Posted by olo at 6/23/2006 11:07:44 PM Hi!
How to exporty table to script file with data ? When I use Scipt Table As
option I get script to create table but without data :(
...more >>
Unique key on 2 fields in which 1 is non unique under the first unique key Posted by Vicky at 6/23/2006 4:53:55 AM Hi ,
I want to create a unique field on 2 columns named (customer_id ,
is_default ).
but the problem I have in having this is in my customer table
customer_id field is unique and can have more than 4-5 values for
is_default field. hence if I want to create a unique key composed of
the above 2...more >>
not enough storage is available to complete this operation err msg Posted by Dica at 6/22/2006 6:10:07 PM i'm receiving this error message in my dts package:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Note enough storage is available to complete this
operation.
Note enough storage is available to complete this operation.
Note enough storage is available to complete...more >>
assign each instance by each IP Posted by Racheal at 6/22/2006 2:43:44 AM Dear all,
Do you know how to assign each instance by each IP.
eg.
SQL/Instance1 = 192.168.0.2
SQL/Instance2 = 192.168.0.3
SQL/Instance3 = 192.168.0.4
Thank
Racheal
...more >>
SQL Server 2005 and Cursors Posted by steve_craze NO[at]SPAM hotmail.com at 6/22/2006 1:01:13 AM Hi Everyone!
We are using a cursor for paging results in SQL server, mainly due to
the performance gains achieved when working with large results sets.
We have found this to be of great benefit when working with SQL Server
2000, but have run into major problems when using it on SQL Server
200...more >>
how to troubleshoot connection problems Posted by Selden at 6/21/2006 3:04:21 PM I have a server (running sql server 2000) used by several offices. The
connect to it over the Intenet, using ADO.Net. This has been working for
more than 6 months, without any apparent problems.
For the past couple of weeks, we've been having intermittant connections.
Here's one symptom:...more >>
how to trace all executed ,slect,alter and update from sql server 2000 Posted by ch.adilaziz NO[at]SPAM gmail.com at 6/21/2006 2:15:23 PM HI !
I need help to know that how can i trace or capture all Tsql statements
(slect,alter and update ) runs on my server on daily
bases.................................
...more >>
Restoring 90+ Databases to new SQL 2005 Server Posted by kambizg NO[at]SPAM cox.net at 6/20/2006 5:09:34 PM Hello:
We have a new SQL 2005 server. We have an existing SQL 2000 Server. The
existing SQL 2000 server has about 90+ database that we need to restore
to the new SQL 2005 server.
Does anyone know of the best efficient way to do this?
Thank you. Kam.
...more >>
IF within CASE Posted by gg NO[at]SPAM xemaps.com at 6/20/2006 6:34:13 AM Why does this work:
declare @x char(1)
set @x = 'a'
print case @x
when 'a' then
case when 50 > 40 then
'50>40'
end
end
But this gives a syntax error on the if statement?
declare @x char(1)
set @x = 'a'
print case @x
when 'a' then
if 50 > 40
'50>40...more >>
why are insert statements not allowed in user defined functions? Posted by Dica at 6/19/2006 4:33:15 PM i've got a function that attemtps to look up a region id by name. if it
fails to find the region name in the table, i'd like the function to add the
missing record to a separate table for later review. any attempts to add an
insert statement within my function fail with an err msg about insert
s...more >>
Restore 32-bit system DBs on 64-bit SQL 2005? Posted by bill_sheets NO[at]SPAM hotmail.com at 6/19/2006 10:05:08 AM I have a 32-bit installation of SDQL Server 2005, and I am preparing to
reinstall the system with 64-bit OS and SQL Server 2005.
Can I restore the master, msdb, and model databases from backups made
on the 32-bit version? User databases should be fine, but if I can't
restore the system DBs, t...more >>
SQL Server 2005 Developer Edition Posted by Snake Eyes at 6/16/2006 11:54:51 AM I have installed the SQL Server 2005 developer edition, all components, and
it seems to be running fine. I see the configuration IDE only.
However, I see no Enterprise Manager (Visual Studio, etc). What am I
missing?
Thanks
Snake Eyes
...more >>
Server Domain Name Change Posted by MeTed at 6/16/2006 11:35:20 AM Hi All,
Does anyone know the potential impact on SQL7 (on NT4) if it is joined to
another domain (along with the users, of course).
...more >>
How to code Oracle 'to_date' function in Microsoft SQL Posted by Red at 6/16/2006 3:41:06 AM How do you code the Oracle 'to_date' function in Microsoft SQL.
Thanx...more >>
Disable the service responsible for listening port 1434 Posted by scottzuehl NO[at]SPAM gmail.com at 6/15/2006 5:00:02 PM Is it possible to disable the listener on port 1434? All our client
connectivity is defined with the server name and port and we do not
allow our clients to do a lookup on the sql server. What do I need to
do to disable this listener?
thx
...more >>
.NET SqlClient Data Provider generating long durations Posted by John Bailo at 6/15/2006 3:43:09 PM
I'm doing a profile on my SQL Server to see if I can eliminate any long
running statements, and periodically, I see an entry for ".NET SqlClient
Data Provider". The durations for it are very long, the example below
shows 386 seconds!
I would think that whatever these are they are "gummi...more >>
Select / Group By First Word in Column Posted by harrys NO[at]SPAM gmail.com at 6/14/2006 7:38:28 AM Hi,
Could anyone tell me if this is possible:
If i have a table like follows:
Col1
John Smith
John Jones
Ann Smith
Ann Thoms
John Peters
I want a query to group by the first name, so is there anyway to select
the first word and then group by it.
ie: My desired result is:
First ...more >>
Is this a SQL server BUG? Posted by mail2lei NO[at]SPAM gmail.com at 6/13/2006 11:28:23 PM I ran the following code on SQL server 2005 (SP1) to output deleted
rows to a table,
CREATE TABLE dbo.test(dateKey int)
go
declare @tt table ( datekey int)
insert into @tt values(1)
delete @tt output deleted.dateKey into test(dateKey)
go
But I received the following assertion error.
...more >>
A floating point exception occurred in the user process - Msg 3628 Posted by maidonical NO[at]SPAM gmail.com at 6/12/2006 3:49:36 PM I am trying to run "select * from <table> where <columnname> = 0.0" in
query analyzer
<columnname> is a float
I get the following error:
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current
transaction is canceled.
I get the same er...more >>
stored proc cannot be found err msg Posted by Dica at 6/12/2006 1:36:07 PM most of my stored procs can be called okay by my asp pages, but i keep
getting an error about one of them not being found, but it's there. the only
thing suspicious is that the majority of the stored procs were created via a
database restore on this server. the one that's crapping out was created...more >>
Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure Posted by news.sbcglobal.net at 6/11/2006 12:31:36 AM Here's my problem:
I'm developing an ASP.NET 2.0 application that has a user select one or more
auto manufacturers from a listbox ("lstMakes"). Once they do this, another
listbox ("lstModels") should be filled with all matching models made by the
selected manufacturers. If lstMakes was not m...more >>
SQL 2005 Mirroring Problems, HELP Posted by foren NO[at]SPAM wollweber.org at 6/10/2006 5:23:06 AM I try to Mirror a Database, i get the following Exception:
The server network address "TCP://xxx.xxxx.xxx:5022" can not be reached
or does not exist. Check the network address name and that the ports
for the local and remote endpoints are operational. (.Net SqlClient
Data Provider)
I can re...more >>
Running MS SQL query from Excel VBA Posted by excel_hari NO[at]SPAM yahoo.com at 6/8/2006 11:14:33 AM Hi,
(MS Sql 2005 and Office 2003)
I have a MS SQL query file which generates 8 outputs. I want to be able
to run this query from excel VBA and channel the 8 outputs to different
worksheets of a particular workbook. These are the things I want to
know:-
a) How to connect to the Database f...more >>
Cursor, last value twice... Posted by Zamdrist at 6/8/2006 10:16:31 AM Pardon my wrapping...I'm trying to figure out why this procedre returns
the last value twice, and how I can stop it from doing that...ideas?
Thanks.
Create Procedure MG_EcolabReport As
Declare @sColumnName As Varchar(40)
Drop Table tblEcolabReport
Create Table tblEcolabReport (fldMatter ...more >>
PK vs Clustered Unique index Posted by Pippen at 6/7/2006 3:29:48 PM Is there a difference between a Clustered Unique Index and a Primary Key
(Clustered / Unique)? The reason I ask is that someone suggested adding a
non-Clustered PK on on a table that has a Clustered Index. Their thought was
that the other non-clustered indexes may benefit for their lookup with...more >>
How do you use SQL server 2000 Posted by WR at 6/7/2006 1:42:23 AM High, I jsut started this database class, so this is all new for me.
I also installed some Microsoft SQL server 2000 Developer Edition on my
computer. The components include Query analyser, Enterprise manager,
Import Export Data, Profiler, Server Network Utility, etc.
I would like to kno...more >>
changing datetime Sql Server 2005 Posted by kleo at 6/7/2006 12:25:10 AM what am i changing datetime in sql server 2005??
i want to change my datetime english to turkish ?
i wrote a query
select getdate()
it reults
2006-06-07
i want to change tukish ,because i must take a result 07.06.2006
...more >>
REINDEX Question Posted by Ed at 6/6/2006 7:54:36 AM Quick question for you all.
I have recently ran a reindexing on all of the tables in the DB and
after it was complete it went from 8 GBs to 15 GBs (this does not
include the log file, which also grew)!!! Why would the DB grow so
much on a reindexing?
Thanks,
Ed
PS. I ran the Shrink D...more >>
Deleted large table, shrunk database, backup file was not smaller Posted by jbiros NO[at]SPAM sppinc.net at 6/6/2006 6:58:26 AM SQL Server 2000:
Hello,
I ran a stored procedure to find the top 25 largest tables in our
database and noticed that the 4th largest table was no longer part of
the system as of 2 years ago. The table was approximately 300MB in
size. After verifying that it was no longer being used, and th...more >>
xp_regread problem on Windows XP Posted by FireSoft at 6/6/2006 4:18:20 AM Hi,
when i read a registry in remote on Windows XP professional as server
and client the xp_regread function doesn't return a value when if i
read the same date on a server with Windows 2003 server and client with
Windows XP professional works well...
I use:
USE MASTER
DECLARE @test varc...more >>
Version of Sql Server 2005 Posted by sndeepgoel NO[at]SPAM gmail.com at 6/2/2006 9:02:28 AM hi friends,
want to go for exam 70-431 for MCAD certification. Want to ask which
edition of Sql Server 2005(70-431) should i use?
Sandeep
...more >>
How to count current login user by login id Posted by Silas at 6/1/2006 9:52:05 PM Hi,
Is anyone know how to count number of sql users login in with specific login
id (e.g. sa) ? Inaddition, if the users use a machine run sql enterprise
manager with three connection the count should show as "3".
Regards,
Silas
...more >>
Is there an easy way to make a copy of a DB on the same server Posted by kgslego at 6/1/2006 11:39:55 AM I would like to create a copy or two of a database on my SQL server and
give each a unique name and then use them to run various tests.
I am running SQL 2000 on W2003 and have only the one SQL server.
Can anyone point me in the right direction?
...more >>
sql express vs msde 2000 = reverting back to msde 2000 Posted by Vlado Jasovic (www.excelleinc.com) at 6/1/2006 10:58:13 AM Hello,
We're developing a c# application that used msde 2000 as a backend.
Our customers have used it for some 2+ years, 5-15 concurrent users and no
problems whatsoever.
- After upgrading to SQL Express 2005 we're experiencing HUGE speed issue.
It's probably due to SQL Express' 1 CPU...more >>
Stored procedure suddently stopping. (very very urgent( Posted by archana at 6/1/2006 5:44:22 AM Hi all,
I am having one windows service in c# in which i have 2 threads.
In each of thread i am executing one stored procedure and waiting for
that stored procedure to complete in thread procedure itself.
My stored procedure is long running which may take 2-3 days.
What is happening is ...more >>
sql server is not allowing connections on port 1433 anymore Posted by Stig Vanmoerkerke at 6/1/2006 4:52:38 AM Hello,
we have a strange thing. A sql server of a client of ours has run
always very well, but all of the sudden, it does not allow connections
on port 1433 anymore.
doing a telnet xx.xx.xx.xx 1433 gives this error:
Connecting To 10.173.10.100...Could not open a connection to host on
port 1433...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |