Hi; We just migrated to SqlServer 2005. When I import tables from from SqlServer database into another the identity fields get switched off from...

Steve

05-17-2007 05:52 PM
Erland Sommarskog

I have a statement in my code; Sum(CASE WHEN Rcv > 0 and Rcv < 100 THEN Rcv ELSE 0 END) as D100 It gives me a different number if I just add an "="...

Hermes

05-17-2007 02:37 PM
David Portas

Our web application requires that when a new Organization is created,a separate Database is to be created for the corresponding organization, so that...

mplpost@yahoo.com

05-17-2007 09:08 AM
Erland Sommarskog

Hi. I deleted a stored procedure (one I had written) out of the master database. I thought I had accidentally put it there, then I got to thinking.....

Jeff Kish

05-17-2007 08:21 AM
Jeff Kish

Hi; I thought I would rephrase a question I asked in another post to more quickly get to the heart of the matter. My apologies for anyone who is...

Steve

05-17-2007 08:21 AM
Plamen Ratchev

Jaros³aw Kozik (jkozik (AT) op (DOT) pl) writes: Why did it become suspect in the first place? This is not a situation that is easy to assist with...

Erland Sommarskog

05-17-2007 06:05 AM
Erland Sommarskog

Hi All : A couple of tables have been identified to be deleted. My job is to find if it is at all used. On searching the web, i found a proc to...

rshivaraman@gmail.com

05-16-2007 06:49 PM
Erland Sommarskog

JOB ID: SB 0501 Please refer the to Job ID in all your communication both in subject line of your email and in the body text. Hi Friends, Hope you...

Imran

05-16-2007 04:40 PM
Imran

I have several SSIS packages. I am trying to see if there is a way to print out ALL the details in the progress tab. I'm familiar with SQL Server...

jdopey2000@yahoo.com

05-16-2007 02:33 PM
jdopey2000@yahoo.com

Hi. I have a procedure with this in it (there are no other references to asset_number_bak_tmp_pk in the procedure and it calls nothing else written...

Jeff Kish

05-16-2007 10:15 AM
Erland Sommarskog

hi, i have used apt-get upgrade from a debian sarge and a paquet add "expire_logs_days=10" line in my.cnf, i have uncomment this line and now mysql...

sebastien@willemijns.com

05-16-2007 09:35 AM
sebastien@willemijns.com

hi..i'm new in sql progaming, i try to make make a query that in table field "match" return to "1" if no member record in another table and return to...

neolempires2@gmail.com

05-16-2007 08:02 AM
neolempires2@gmail.com

How to fix error 207 in ms sql server 2000 with out applying SP4 service pack 4,on SQL SERVER 2000 wit sevice pack 3a - current environment ?

Eckhart

05-16-2007 07:15 AM
Erland Sommarskog

Hi. I am between beginner and intermediate level of knowledge of sql server. I am dealing with an sql server 2005 situation (oracle also but thats...

Jeff Kish

05-16-2007 03:24 AM
Erland Sommarskog

Greetings. I am trying to add some debug to a stored procedure. I put some statements like this throughout the code: select 'some message...

Jeff Kish

05-15-2007 08:14 PM
Jeff Kish

Hi friends, ID LASTNAME --------+---------------------------- 2 FFF 1 XXX 0 CCC 1 DDD 2 BBB

Oonz

05-15-2007 01:21 PM
Oonz

Hey folks, I'm looking at making the following query more efficient potentially using the ranking functions and I'd like some advice from the gurus. ...

Mark

05-15-2007 12:47 PM
--CELKO--

I'm using SQL 2000, which is integrated with a VB.NET 2003 app. I have an Audit trigger that logs changes to tables. I want to apply this trigger to...

Ots

05-15-2007 12:30 PM
Ots

Hi friends, please help me in sorting this table. the table should be sorted based on LASTNAME, and then the ID (only non-zero id should be...

Oonz

05-15-2007 06:34 AM
Oonz

Hey Guys, are you aware of anyone moving from MYSQL to MSSQL or vice versa - what were your experiences - Mark Smith

mark_smith

05-15-2007 02:53 AM
mark_smith

Hi there! I need to write a trigger that will check referential integrity of my data. I have few FOREIGN KEY constraints but, as You probably konow,...

Wojto

05-14-2007 05:44 PM
Wojto

I'm trying to get a UNION of UserIDs from multiple subselects. The original query--which puts all the found UserIDs into separate columns, looks like...

nullGumby

05-14-2007 01:42 PM
nullGumby

So you think your database is secure? Think again. Scuba by Imperva Database Vulnerability Scanner is a FREE, lightweight Java utility that safely...

s.....@gmail.com

05-14-2007 01:31 PM
s.....@gmail.com

Hi, I have a query which works for one day: SELECT SOME_COL AS something, SOME_COL2 AS something2 FROM myTable WHERE DATE = '2007-05-11' AND...

Gooseman

05-14-2007 09:40 AM
Plamen Ratchev

Hello, I'm trying to import a Xml file in a table. It's working find, but when the data are inserted, my trigger on this table doesn't work ? I put...

M6C

05-14-2007 08:53 AM
M6C

(Pardon me for asking a very basic question. I have come back to SQL Server after five years of Oracle, and my memory is a tad rusty). I have a bit...

bbcworldtour@hotmail.com

05-14-2007 05:24 AM
SB

hi..i need help for my exam, I retrived data from my sms inbok and insert to table.The record just like this: ID1,12x100,56x12,90x90..,how to pars...

neolempires2@gmail.com

05-13-2007 10:23 AM
Ed Murphy

Could someone tell where I can find out if it's true that during UPDFATE SQL Serve deletes data from table, and then inserts new one. Thanks -A

kdpo

05-11-2007 06:48 PM
Greg D. Moore \(Strider\)

Does anyone know if there is a simple way to get the results of a DBCC INPUTBUFFER() request into a table? I have a process for monitoring activity...

Tom

05-11-2007 06:18 PM
Tom

Although CURRENT_TIMESTAMP/GETDATE is listed as non-deterministic, it is deterministic at the statement level (it is evaluated only once...

brymcguire@googlemail.com

05-11-2007 04:49 PM
Hugo Kornelis

So you think your database is secure? Think again. Scuba by Imperva Database Vulnerability Scanner is a FREE, lightweight Java utility that safely...

system.audit@gmail.com

05-11-2007 04:44 PM
system.audit@gmail.com

What is the best way to essentially use the charindex(find) function if the value is could be more than one variable (A or B or C) I can't seem to...

matthewwhaley@gmail.com

05-11-2007 01:25 AM
SB

Experiencing a little weirdness with SQL Server Management Studio... Have created a login, that has fixed server role "securityadmin". The login can...

Larry Bertolini

05-10-2007 06:14 PM
Erland Sommarskog

Hi All, I'm trying to write a query that gets more granular as criteria is available. for example: select name where A is true, B MIGHT be true and...

Looch

05-10-2007 05:52 PM
Erland Sommarskog

Hi, I have a problem which I don't entirely know how to tackle: Essentially, is it possible to query a web service (via http), using sql server...

markjerz@googlemail.com

05-10-2007 08:41 AM
Plamen Ratchev

Hi, I need to output result of my query to txt file. So I'm using -o parameter, for example: osql.exe -s (local) -d database1 -U sa -P sa -i...

mamin@o2.pl

05-09-2007 06:17 PM
Erland Sommarskog

Ok a newbie here... i have a sql server db I got from a book to learn. I am having problems with the 'Authentication' mode. I need a valid id to...

M K

05-09-2007 06:16 PM
Erland Sommarskog

I inherited a SQL Server 2000 which is configured to run under CPU based license mode. Is it possible to switch it to be based on 'Per seat mode'...

akkha1234@gmail.com

05-09-2007 02:30 PM
akkha1234@gmail.com

I have a query that takes blobs that have been created within the last day out of sql server and places them on a disk drive. The query is a stored...

Connie

05-08-2007 05:56 PM
Erland Sommarskog

hi All : I have an insert statement which reads INSERT Into TableA (Col1) SELECT CASE WHEN Col1 LIKE '%%' THEN 999999 ELSE Col1 END AS Col1, FROM...

rshivaraman@gmail.com

05-08-2007 03:07 PM
Plamen Ratchev

I wonder if anyone can help ... Today I tried to create another non-clustered index on a table. This failed as I apparently already had 249...

Laurence Breeze

05-08-2007 07:50 AM
Dan Guzman

Is it possible to create a unique constraint on two tables? In mssql2000?

Igor

05-08-2007 01:57 AM
MC

Use the Northwind database Products table as an example. Purchasing dept gets a report showing when inventory items on hand qty are below the reorder...

rdraider

05-07-2007 06:09 PM
rdraider

hello, I have a table like this: thing, size, color, type_mov, vary 1, s, red, sell, 1 1, s, red, buy, 2 1, m, green, return, 10 ....

estesiquevale@gmail.com

05-07-2007 01:31 PM
Ed Murphy

Hi, i want to create a solution which shall consist of a sql server 2005 - data base (express edition if the following features are available...

Wolfgang Kraus

05-07-2007 08:25 AM
Plamen Ratchev

Hello, This is driving me nuts!! I have Windows 2000 server SP4 visual studio 2003 (.net framwork 1.0) visual studio 2005 beta (.net framework...

Matthew Wells

05-05-2007 04:06 PM
Erland Sommarskog

1. Are stored procedures WITH ENCRYPTION slower than the ones without encryption? 2. Should i put most restrictive conditions first or last in...

Igor

05-05-2007 01:53 PM
Igor

1. In this...

Igor

05-05-2007 06:45 AM
Igor

I have a DTS Job that is reporting failures but it looks to me as if the job is actually completing successfully. The job only has a couple steps. ...

Connie

05-04-2007 06:01 PM
Connie

I'm trying to get back key value for a newly added record "in one shot": sConnectString =...

gok

05-04-2007 05:34 PM
Erland Sommarskog