Hi, I want to update a column typed datetime. My statement is: update 'tablename' set Datum_Ende = '2007-12-17 08:49:04.000' where 'columnID_name'...

Thomas609@gmail.com

12-18-2007 07:53 AM
Madhivanan

I have built a SSIS package which runs fine in BIDS. I went into Sql Server Management Studio and created a new job and job step. When I select the...

jasonnance77@gmail.com

12-17-2007 07:50 AM
Dan Guzman

The following is part of my stored procedure where I could use some help: If I remark out the two lines regarding dates, it runs fine. The...

Charlie

12-17-2007 07:40 AM
Dan Guzman

Here are my two tables... Object Table: CREATE TABLE .( IDENTITY(1,1) NOT NULL, (12) NOT NULL CONSTRAINT DEFAULT (0), NULL, (1) NOT NULL...

orandov

12-14-2007 11:15 PM
--CELKO--

Does anyone know how to query a field in a table where it contains an ASCII code >= 128 - without looping through every field for every record in...

DennBen

12-14-2007 05:27 PM
Erland Sommarskog

Hi, I've used SQL Enterprise Manager to Export my selected db's locally. My main question is how do I move the export to another pc - which files...

ll

12-14-2007 04:19 PM
Plamen Ratchev

Hi, with some help today I was able to get my stored procedure running and have the results emailed to me. However, this is how its...

Mike K

12-14-2007 10:30 AM
Mike K

Hi, I am new to SQL and I am trying to email my group results of a query as part of a message body. I created a SP and I am using XPSendmail....

Mike K

12-14-2007 09:28 AM
Mike K

Hello everyone, This is more of an architectural question about SQL Server. Can someone please explain why when I perform a query such as the...

Kruton

12-13-2007 11:57 AM
Kruton

The major theme of Release 3.3 is enhanced data visualisation and user interaction. We have not forgotten all the integration options you need to so...

YellowFin Announcements

12-12-2007 04:35 PM
YellowFin Announcements

Hi, Facts: I created a database to support an application that tracks events on different objects. The two main tables are tbl_Object...

orandov

12-12-2007 12:29 PM
jhofmeyr@googlemail.com

Hi, I was wondering if anyone could shed any light on performance problems we are having with sql 2005. We have 3 boxes which are all 64bit itanium...

ianwr

12-12-2007 09:46 AM
ianwr

Hi, Want to earn money by writing articles about sql server? Please, contact me. Thanks, Patrice www.sqldruid.com

Patlv001

12-11-2007 01:15 PM
Patlv001

comp.databases.ms-sqlserver, Stylus Studio 2008 is now available for online purchase or free trial download at:...

Stylus Studio

12-11-2007 01:01 PM
Stylus Studio

Hi, I am attempting to process a proprietary formatted file into flat csv for the purpose of bcp'ing into a SQL Server 2005 install. I tried writing...

cldale@gmail.com

12-11-2007 11:55 AM
cldale@gmail.com

Hi. I have a table, let's name it TableA, containing a list of PINS with some other data. I have another table, "Comments". A PIN in TableA might...

Radu

12-11-2007 10:22 AM
jhofmeyr@googlemail.com

Hi I have a VBScript file which runs fine when I click it or when I run it from a command prompt level. I added it as the 1st step of an SqlServer...

David Greenberg

12-11-2007 09:01 AM
David Greenberg

Hi all, I have an existing table(Several actually) that I want to add a column or two or three. I need to have, I think, at least two columns....

scoots987

12-11-2007 07:46 AM
jhofmeyr@googlemail.com

I use SQLDMO.Bulkcopy in an VB6 (have to) program to load data from a plain text file into a SQL Server 2000. One of the target columns is NOT NULL...

Nils

12-10-2007 05:17 PM
Erland Sommarskog

Hi there, I need help with setting up a reminder in my sql. It needs to check the inventory on hand for a product and if it is below 3 unit, it...

behnaz.behzadi@gmail.com

12-10-2007 03:10 PM
Greg D. Moore \(Strider\)

Hello, I'm using SSIS (SQL Server Integration Services) via Native Informix OLE DB provider to extract (ETL) data from Informix 7.3 to SQL Server...

Georg

12-10-2007 03:04 PM
Georg

We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data...

jags_32@yahoo.com

12-10-2007 11:05 AM
seeker136@gmail.com

Hello Just figured out that database mail is not available in SQL Express. Anyone have any ideas on how I can send mail from sql express ... as part...

roblowein

12-10-2007 09:09 AM
Tom van Stiphout

Within SSIS where can I specifiy the following attributes for package run logs? - File name (e.g. package name with start datetime appended) - File...

Desmodromic

12-10-2007 08:55 AM
jhofmeyr@googlemail.com

Hi All, Can anyone explain me, why we have Resource and Distribution System Database in SQL Server 2005. Whether they were also available...

Om

12-10-2007 08:06 AM
Dan Guzman

Hi, I have two databases on the same server: COMU0002 and 2007DU and two tables: tecnicos on COMU0002 and telf_cli ON 2007DU Being on COMU0002 this...

Santi

12-10-2007 07:37 AM
Santi

I am currently using enterprise manager to run multiple queries on a single table in a DB. I refresh these queries every few minutes. Due to the huge...

Akhenaten

12-10-2007 03:08 AM
Plamen Ratchev

Within the SQL Server 2005 BI product suite, where should metadata be held regarding database objects for reporting? What I mean is if a user is...

Desmodromic

12-09-2007 10:21 PM
Desmodromic

Info: the machine's OS is XP Professional with SP2 sql server 2000 developer's edition installed and running a bit of 'history' last night I first...

Don Li

12-08-2007 05:50 PM
Don Li

To minimize the very large number of stored procedures typically associated with an application, I have gotten in the habit of combining a select,...

JeffRoughgarden

12-08-2007 03:22 PM
Erland Sommarskog

Hi, The following query which used to run regularly is crashing the server. The query is run on two tables which has aroung 60 million records...

Taw

12-08-2007 03:31 AM
Taw

can you conver a Varbinary to varchar declare @sid varbinary(85) select @sid = suser_sid("mydomain\mynam") // how to convert the sid to a string or...

Analizer1

12-07-2007 01:30 PM
Analizer1

I am a beginner with SQL Server and SharePoint. I am trying to migrate the database to other servers that may be running different platforms. I know...

billlucarell@gmail.com

12-07-2007 11:23 AM
billlucarell@gmail.com

Hi, I wondered in anyone can help with the following problem that i'm experiencing, i'll try to provide as much info as possible and any suggestions...

ianwr

12-07-2007 09:12 AM
ianwr

MSDN Search made easy Hi All, Check this cool gadget at http://smartinterviews.googlepages.com for MSDN Search and NameSpace/Class Search A utility...

SanyasiRao09@gmail.com

12-07-2007 01:52 AM
SanyasiRao09@gmail.com

I have Informix 9.4TC6 and SQL Server 2005. DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372). First, I created DSN to Informix. Then tried to...

denis.carabadjac@gmail.com

12-05-2007 05:27 PM
Erland Sommarskog

I have several databases that are used to collect data for different client-projects. My intention was to collect the data, and administer mySQL so...

judy

12-05-2007 01:30 PM
Hugo Kornelis

Hi, I wonder if anyone can shed any light on the following as i just can't explain it. A user is running an update on a 500m+ row table setting a...

ianwr

12-05-2007 02:24 AM
ianwr

Can anyone tell me how to do this in sql server? I am currently doing this query in oracle: select...

Jeff Kish

12-04-2007 10:31 PM
Jeff Kish

I have an extremely large table that is starting to slow down production. I want to keep it for historical queries, but want to have it fast for...

Brian - Support

12-04-2007 06:02 PM
Erland Sommarskog

Hi everybody! I have several tables from which I want to exract the SAME value (along with other referenced data). All the values are in the same...

andro

12-04-2007 05:57 PM
Erland Sommarskog

Greetings, What is the point of Microsoft defining a ROWGUIDCOL property that can be attached to a 'uniqueidentifier' column? This is defined as a...

Sam Bendayan

12-04-2007 05:39 PM
Erland Sommarskog

Hello, We are researching whether the following scenario would be possible: In an upcoming application release, we have to move some tables...

JoshG

12-04-2007 05:30 PM
Erland Sommarskog

Hello , Is it possible/recommended to do SQL server instance backups in Single user mode ? Thanks in advance, atv

velu5

12-03-2007 05:47 PM
Erland Sommarskog

Redhat Linux Network Security Covering everything about security would take several volumes of books, so we can only look at the basics. We can...

troy.john78@gmail.com

12-03-2007 08:34 AM
troy.john78@gmail.com

does anyone know how to keep QA from adding the lines setting these two options on and off along with blank lines at the beginning and end of every...

Ted

12-02-2007 10:38 AM
Erland Sommarskog

I need to create a stored procedure with a parameterised input. An input parameter is declared as a variable,this will hold the units that a...

Dave dcartford

12-02-2007 08:59 AM
Dave dcartford

2 months I had first page organic results and they delivered on every key term I wanted so here they are...

nc3bj6yp

12-02-2007 07:05 AM
nc3bj6yp

..:: Unix and Linux Hacking and Security ::. 1. Unix - Vulnerabilities and Advisories -- Tutorials and Papers -- Specific Exploits and...

Andre.Lee.group.com@gmail.com

12-02-2007 01:42 AM
Andre.Lee.group.com@gmail.com

I'm not a professional dba or dbd, but I'm proficient in the basics of database design and sql. I want to create a database of math definitions, and...

gradeexrex@hotmail.com

12-01-2007 10:08 PM
Plamen Ratchev