URG: cannot update SQL2K on 2003R2
Fri, 3 Jul 2009 17:30:29 -0300
I'm trying to install and update SQL2000 on a clean Win2003R2 SP2 32 bits
fully updated and i cannot get it to work.
start the install(first tried SQL2000 standard spanish), installation ends
ok, then fire up SP4 and it hangs forever in the step previous to the
scripts execution(updating server....)
checkin ...
|
'Generate scripts' functionality in SQL 2005 not being consistent
Fri, 3 Jul 2009 09:07:01 -0700
I'm running SQL 2005 (version 9.0.4035) and I like to use the 'Generate
scripts' functionality in SQL Server Management Studio to create one big file
with the scripts for an entire db as a way to track changes to the various
objects in the db.
Problem is that in 2005 the 'Generate scripts' feature does not ...
|
Problem with SUM - Help please
Fri, 3 Jul 2009 03:15:49 -0700 (PDT)
See DDL Below
Put simply, I need to get some numeric values in a SELECT statement
and then SUM them (I realise in the example below that I don't need to
SUM them, I can just + them). The numeric values are stored in a
related table so I've created a scalar function to get the value. The
first SELECT stateme ...
|
Cartesian with one table
Fri, 03 Jul 2009 10:00:35 GMT
Hi
I have entered some extra fields "site_name and site_code" into some SQL but
when i try to use it to search for one record i recieve a result against
every site availible in the database.
I have linked the site to the existing data and have referenced it in the
GROUP BY clause but am having no joy with i ...
|
ID large queries while they execute and kill
Fri, 3 Jul 2009 09:39:55 +0100
Hi,
Im having a problem with large read queries initiated by end users causing
problems with my write times.
i would like to understand how to ID the query while its running and kill
it.
I use profiler and i see the query after its executed but how do i ID a
process thats causing the problem while its ...
|
database log file keeps growing
Thu, 2 Jul 2009 10:27:03 -0700
Hi sql server experts:
I thought if I set the recovery mode to SIMPLE, the log will not grow.
But it is not true.
How do I set up the database so that the log file does not grow?
Thanks,
Pingx ...
|
problem with new login
Thu, 2 Jul 2009 19:23:19 +0200
Hi,
i defined a new login 'test' for Management Studio sql server express 2008.
This account must be able to connect via Sql server Authentification and
must be able to access database 'dbtest', but not the others. There are
three databases: 'db1', 'db2' and 'dbtest'.
Here are its properties:
server rol ...
|
|
|
Column Limits
Thu, 2 Jul 2009 09:40:01 -0700
I have 100+ fields of data in a single record relating to an individual
person. The data is unique to that person and has a one to one realtionship
to him. I have been told that that is to many fields and that it should be
broken up into other tables. That is is not normailzed. This does not make
sense to me ...
|
Problem with triggers an ntext
Thu, 2 Jul 2009 14:44:32 +0100
Hi
I have a bunch of triggers which
back up data being deleted into another table.
These work fine except for one table with
ntext fields.
I found that INSTEAD OF works with this
however it does back up the table
but doesn't delete the record.
Lookign at the syntax I can't see anyway of
modifying th ...
|
SQLhas encountered 2 occurrence(s) of IO requests taking longer th
Thu, 2 Jul 2009 03:20:06 -0700
HI All,
Environment:
WIN2003 Enterprise Edition
SQL2000 with SP4(cluster with 2 nodes)
I see below messages in SQL logs almost everyday for tempdb and for other
few databases. They are more for tempdb. The Tempdb is on seperate drives.
SQL Server has encountered 1 occurrence(s) of IO requests taking l ...
|
