Hello experts, I'm trying the run the following query with specific intentions. I would like the query to return 5 results; i.e., 4 distinct and...

alex

02-28-2007 05:27 PM
Erland Sommarskog

I want my application to create a new database/tables when run for the first time. I have created a stored procedure to create the new database...

Shiller

02-28-2007 05:25 PM
Erland Sommarskog

Does anyone know how to purge old data in a MS SQL server 2000 database?

The Man

02-28-2007 05:22 PM
Erland Sommarskog

Hello All: I am in desparate need of assistance. We are using an application called PaperVision Enterprise which takes scanned invoices and puts them...

The Man

02-28-2007 05:18 PM
Erland Sommarskog

I need a way to view all existing triggers in our MS Server database especially since I don't know what tables are involved. Thanks, kwilla

kwilla

02-28-2007 03:00 PM
kwilla

Hi all I am creating a web services application in Visual Studio Dot net which links to a MS SQL database. I need to create a form which lets the...

madhumita.iyengar@gmail.com

02-28-2007 01:46 PM
dgk

I have a situation where I want to filter records for a given day. The field that stores the date/time uses the date() function as a default...

Wes Peters

02-28-2007 11:15 AM
Plamen Ratchev

Hi, I have one table like : MyTable {field1, field2, startdate, enddate} I want to have the count of field1 between startdate and enddate, and the...

Sam

02-28-2007 08:34 AM
--CELKO--

What are the ways to export/import data in/out of SQL Server 2005? I used to use DTS for 2000 to do such thing and now I can't even find the wizard...

othellomy@yahoo.com

02-28-2007 03:52 AM
othellomy@yahoo.com

hi, I have a table with several million rows. Each row is simply the date and time a certain page was viewed. eg page1 1-1-00 page2 ...

C10B

02-28-2007 12:10 AM
Russ Rose

Hey yall, I have a problem, I'm a DBA for about 250 databases. I currently have ZERO means of notification on them. I put together an entire plan...

jlaustill@gmail.com

02-27-2007 02:11 PM
jlaustill@gmail.com

I can't seem to find a way to do the following: create table part_table ( col1 int, col2 datetime ) on psX (datename(week,col2)) I want to...

eavery@cdc.gov

02-27-2007 01:07 PM
eavery@cdc.gov

Our database(s) are all over the place - no documentation - lot's of rubbish and unused stuff. I'm managing a project focusing on data quality that...

oraustin@hotmail.com

02-27-2007 09:33 AM
www.ITjobfeed.com

Hi, I am new to MS SQL. When I create a column in a table, when shall I use nvarchar or varchar? Please help. Thanks, Mike

haidani@gmail.com

02-27-2007 12:28 AM
Ed Murphy

Can someone please tell me what is meant by a file share? I'm doing a little reading on MS Sql Server and they talk about how you can connect to the...

nick

02-26-2007 07:41 PM
Carl Tegeder

hi, I have a table with several million rows. Each row is simply the date and time a certain page was viewed. eg page1 1-1-00 page2 ...

C10B

02-26-2007 05:23 PM
Erland Sommarskog

Hey there! I have a DTS import package from an old SQL server that takes flat text files, does some munging on the columns using ActiveX scripts and...

fboweb.com

02-26-2007 03:29 PM
fboweb.com

anybody know which driver to use to make a linked server connection between MSSQL 2005 and Access 2007

doron.almog@gmail.com

02-26-2007 11:24 AM
doron.almog@gmail.com

Hi, I would like to know how to modify the following selects so that - assuming that NewTable already exists - the result of the SELECT is appended...

pamela fluente

02-26-2007 03:22 AM
pamela fluente

I have a directory of user information. What I would like to do is allow someone to search for person X and then return not only the information for...

michealp@gmail.com

02-25-2007 11:46 AM
Greg D. Moore \(Strider\)

Here is my replace query and I need to run this on every column in my table. Right now I manually enter the column name (_LANGUAGES_SPOKEN) but this...

JackpipE

02-25-2007 08:44 AM
Roy Harvey

Dear Experts, When I use a single table I can easily use constraints to enforce my business logic, but what do I do when I normalize a single table...

Emin

02-24-2007 09:56 PM
Ed Murphy

in the market place that will run a query on multiple DBs across multiple servers? Without having to manually connect to each server? If so, can...

click37@gmail.com

02-24-2007 10:02 AM
Robert Klemme

Hi, This is the log file for my SP1 on 2005 install. Can anyone please look at this and tell me if this looks normal? I'm concerned about the...

kataoki@gmail.com

02-24-2007 05:45 AM
Erland Sommarskog

Hi, After just installing sql 2005 on our test machine, I am trying to restore a database using a backup file on the network. However,...

KR

02-24-2007 04:56 AM
Erland Sommarskog

Hi all, I have the following table Name Date Wish Valid Name is person's name, date defaults to getdate() and is never assigned directly...

Eugene

02-23-2007 04:44 PM
Utahduck@hotmail.com

Hi, We currently have a fairly old product, which was originally only compatible with SQL 2000. When we upgraded our server to SQL 2005, the client...

jsmall@visinet.com.au

02-23-2007 06:49 AM
Erland Sommarskog

I am trying to copy the data from one table to another table linked in SQL. I keep getting an error message saying "the data types nvarchar(max) and...

Duffey

02-23-2007 03:28 AM
Erland Sommarskog

Hi, I have a very simple issue: for simplicity lets say I have 2 tables, A and B. - Table A contains 5 fields. Amongst these there is a 'id'-field...

dhek

02-23-2007 01:38 AM
dhek

I have an ASP that has been working fine for several months, but it suddenly broke. I wonder if windows update has installed some security patch that...

central_scrutinizer

02-22-2007 07:07 PM
AlterEgo

Hi, We want to encrypt MS Sql Server data files - .mdf and .ldf with logged in user certificate and make sure that MS Sql Server service (running as...

rsm

02-22-2007 05:24 PM
Greg D. Moore \(Strider\)

Hi I need to produce an excel output from SQL that shows email - company name - producttype1, producttype2 (where the - denotes a change in...

archanapatelwhite@googlemail.com

02-22-2007 05:13 PM
Erland Sommarskog

Hi, I'm using VS2005 and I'm trying to link the C# windows form to MSSQL. I used BindingNavigator Control to read the data. After that I...

projectid2007@yahoo.com

02-22-2007 05:11 PM
Erland Sommarskog

Hi .. I am geeting myself into many knots around how to do thsi extraction. There is a table that contains the following: aID bID cID ...

Mark Probert

02-22-2007 02:17 PM
Mark Probert

hello I need some help. The following query works perfectly: ------------------------------------------------------------------ select * from...

solonzenetzis@sbzsystems.com

02-22-2007 11:57 AM
Ed Murphy

hi, i have a problem as a sql developer.i have never used DTS packages for sending data in SQL databases. but i used SSIS which is a new feature in...

rrghosh@gmail.com

02-22-2007 10:40 AM
Connie

We have a blob in one table that is storing pdf files. I need to write a select query that will grab that column and write those *.pdf files out to...

Connie

02-22-2007 10:32 AM
Connie

Hello, I thought this would be easy, and I've read a lot of posts, but I can't seem to find exactly what I'm trying to do. formatted as YYYYMMDD...

paulmac106@gmail.com

02-22-2007 10:17 AM
Utahduck@hotmail.com

Hi, Our school has an application in which : - Teachers enter comments through a web interface built in asp (not asp.net). - Comments are stored in...

DL

02-22-2007 04:55 AM
Erland Sommarskog

Hello, I am using ASP.NET 2.0 Membership services and to save some time I am not extending the Membership. I realized that I can create a...

ricardo.sobral.santos@googlemail.com

02-21-2007 05:51 PM
Erland Sommarskog

Hi, I have erronous white space at the end of my 'description' field within my 'product' table. I tried using the RTRIM function but it won't let...

Mintyman

02-21-2007 10:33 AM
Greg D. Moore \(Strider\)

Hi, We have a requirement to run profiler continuously to find out the misbehaving applications/SQL in the dataserver. And we are not interested in...

Thyagu

02-21-2007 10:30 AM
Plamen Ratchev

Hi! How to change the number of re-trys in transactional replication before it times out? Currently (by default) it is set to 10. I would like to...

tolcis

02-21-2007 09:22 AM
tolcis

Hi! I have transactional replication setup to a remote server. My application is pointing to that server for reporting function. Everytime I ran a...

tolcis

02-21-2007 09:18 AM
tolcis

biz.yahoo.com/prnews/070219/sfm012a.html?.v=1 Microsoft Corp. today released Microsoft® SQL Server 2005 SP2, an update to its award-winning data...

admin@neobasic.biz

02-21-2007 04:12 AM
admin@neobasic.biz

Hi, I'm a student and I have the following working example that troubles me (in SQL Server 2005): CREATE PROCEDURE dbo.CustomersOrderHistory (...

Krij

02-21-2007 02:19 AM
Krij

Hi Everyone, I'm working on a site that is running MS SQL 2000. They perform regular backups of databases and log files and in the event of...

Daniel.Peaper@gmail.com

02-21-2007 01:55 AM
Daniel.Peaper@gmail.com

Hi below is the code I am using. ------------------------------------ SET NOCOUNT ON DECLARE @emailid varchar(50), @rastype varchar(50), @message...

archanapatelwhite@googlemail.com

02-20-2007 10:36 PM
Russ Rose

Never say never..... One of my applications loads a huge amount of data from a text file, sifts through and discards much of it, and rearranges...

Wes Groleau

02-20-2007 06:20 PM
Erland Sommarskog

Hi, I have a database and want to store data in Spanish and English. To accompish this: 1. Do i need to create separate tables for both the...

jackal_on_work@yahoo.com

02-20-2007 06:09 PM
Erland Sommarskog