SQL Server 2005 on 2 CPUs
Tue, 8 Jul 2008 22:09:18 -0700
Hi all,
Is there a way that I would be able to know that the 2 CPUs in my SQL Server
2005 are both utilized?
Thanks in advance!
...
|
Warning: cannot write logfile
Tue, 8 Jul 2008 07:07:02 -0700
Hello,
I am scheduling a simple job to run a query. I want the result of that query
written to a text file.
When I am scheduling the job, in the step section I am creating a step of
type "Transact-SQL Script (TSQL)" where I define the query. In the advanced
tab of the Step section there is an option to put ...
|
datetime comparison broken???
Mon, 7 Jul 2008 16:49:11 -0700
I've spent a few hours researching the datetime comparison, and from what I
understand, what I'm doing *should* be working... any help is GREATLY
appreciated.
I have a table that stores a column (EventDateTime) in the datetime format.
If I run a query in query analyzer, the column returns values like 2008- ...
|
Producing data from querying three tables
Fri, 4 Jul 2008 03:56:00 -0700
Hi all,
I'm trying to run a query that produces data from three tables, in essence
these are Location, Category and BannerPeriod, They all have a secondary key
of SiteID and are linked by this, really there are two stages to this query,
Stage 1 produce a complete combination of all categories and locations ...
|
Getdate()+ so many hours
Thu, 26 Jun 2008 05:57:02 -0700
Hi there
Hopefully this will be an easy one for someone. I am using SQL Server 2005.
I am based in the UK and our users are in the UK. We have recently changed
hosting providers and their server is located in the USA.
Our database has a default value of getdate() when a record is added however
as the ser ...
|
Error converting data type nvarchar to datetime
Tue, 10 Jun 2008 17:56:01 -0700
Good morning :)
* Using QL Server 2005
I have created a stored procedure (first time I have done this). It worked
fine when I only had 1 variable (the ProjectCode variable).
However when I add in the PostedDate variable and try and use it I get the
following message.
Msg 8114, Level 16, State 5 Proc ...
|
update querie multiple tables
Tue, 10 Jun 2008 06:35:01 -0700
Hi I wish to create a stored procedure that updates multiple tables.
I have a table called User
CREATE TABLE [dbo].[Users](
[UserId] [int] NULL,
[Active] [bit] NULL,
[OrganisationId] [int] NULL,
[Username] [varchar](20),
[Password] [varchar](20),
[Title] [varchar](50) COLLATE,
[FirstName] [varchar] ...
|
|
|
test
Fri, 6 Jun 2008 18:37:51 +0200
Vendo coche seat ibiza, 1999 . en buen estado, color plata, Precio ,4900 euros. Precio 4566 Euros.
Tfno: 91452123334
Puedes ver mi anuncio gratis en:
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
ww ...
|
COUNT command rejected in SQL Query
Tue, 3 Jun 2008 17:41:02 -0700
My C# Windows program does not recognize the COUNT command in a SQL query
string using SQL Server 2005. I can use the command when I code the query
manually against the data base. It rejects the command SELECT COUNT(*) FROM
EARNDED. Does anyone know how to get around this problem?
Dave ...
|
how to upate ntext fields
Mon, 2 Jun 2008 20:21:00 -0700
I have a mssql 2005 database dbTest with to tables tblOne and tblTwo.
tblTwo.IndexID = tblOne.IndexID.
tblOne and tblTwo has both got fields, tblOne.Article and tblTwo.Article
which is set to type(ntext).
tblOne has less records than tblTwo and I would only like to update the
record fields where tblOne occ ...
|
