celeberties living style you want to know This site contain information about luxury living includs (houses,cars,hotels) video and informative...

yaqub khan82

06-28-2009 07:28 AM
yaqub khan82

Contact Immediately : Hari Krishna Ph : 972-332-3471 Ext: 106 Yahoo ID ! harikr_85 (AT) yahoo (DOT) com G Talk ! harikr.85 (AT) gmail (DOT) com

nani

06-26-2009 04:54 PM
nani

i have Several Databases with the Same view in them (vCustomers) I have to do work on these views (drop , modify etc) depending on the Data Sent to...

DaveL

06-25-2009 04:44 PM
Erland Sommarskog

Hi, I work for a company that handles 100k Insurance claims per Day Weve stared a new Part of the Web site that handles a new type of...

daveL

06-25-2009 11:16 AM
DaveL

I've read in the BOL best practice creating the tempdb; it states create one data file for each CPU. In addition, it states to create .x25 - 1.0 data...

rcamarda

06-24-2009 05:05 PM
Erland Sommarskog

I have successfully configured mirroring in SQL 2008. I use a witness server and it is running in sync mode. I can fail over the databases and...

rcamarda

06-24-2009 03:52 PM
rcamarda

Summary: How can I ensure that sys.sql_dependencies is 100% up to date and accurate prior to querying it for a list of dependencies? Detail: The...

bill

06-24-2009 02:24 AM
Erland Sommarskog

Hello everyone! I am a corporate recruiter for a technology company based in San Diego, CA. My company currently has openings in the software...

Ahmed

06-22-2009 07:47 PM
Ahmed

health is wealth because see how you live healthy its contain usefull information about everyone its includs information about...

yaqub khan

06-18-2009 10:40 PM
yaqub khan

Our new clients have a mature database but a new requirement to obtain some summary data. Frankly, I don't think it's terribly well designed, but...

teddysnips@hotmail.com

06-17-2009 01:19 PM
--CELKO--

Hi, I am a newbie in sqlserver 2005. I would like to backup with new backup name with date eg. backup200900601, backup20090602 etc. how am I going...

andrewl

06-17-2009 10:02 AM
samalex

Hi I'm writing a package in SSIS )Visual Studio 2008) that will perform a DB backup task. I've created a server connection and tested it...

David Greenberg

06-17-2009 04:58 AM
David Greenberg

Hi get information about latest laptop and pc and also free download latest software games and beautifull screen savar ,,,,,, and many more ,,,, get...

Mohummadasif

06-16-2009 05:25 PM
Mohummadasif

If you want to know what tables a particular view (call it 'JUNK') depends on, there's an easy answer: SELECT TABLE_NAME FROM...

bill

06-11-2009 04:40 PM
bill

ok. thanks for your help. i have used this in a table function. it works. i would now like to call this from a stored procedure and pass it to a...

p-rat

06-10-2009 08:53 PM
Plamen Ratchev

Hi Ed, table "a" and "b" have no specific constraint or similar. In the current case we fill several tables during a data import. If we want repeat...

Jens Riedel

06-09-2009 08:26 AM
Jens Riedel

Hi We are moving to Sql 2008. I'm writing an SSIS with several sql tasks that I would like to be commited in the same transaction (which also means...

David Greenberg

06-01-2009 12:57 AM
David Greenberg

Hi Im trying to get a list of Ssis Packages from Msdb any help is appriciated DAveL

DaveL

05-28-2009 04:10 PM
DaveL

Hey all - I've been googling around trying to find some code that will process a tsql query string (with *=, =*, = joins) into ansi sql using the ...

my name

05-27-2009 10:01 AM
Sylvain Lafontaine

Hi All I have a large csv file to import into a SQL Server 2005 database as an intermediate step to processing. The file has over 900 columns...

bevanward@gmail.com

05-26-2009 08:49 PM
bevanward@gmail.com

I have 2 web server in load balancing configuration (NLB) and one database. We are going to add another web server. The problem is simple: too many...

mastiff

05-23-2009 03:21 AM
mastiff

Hi. I have a "for insert" trigger, that calls a procedure (using SQL 2000). Within the procedure I use an "openrowset" function. This gives an...

jc

05-20-2009 04:27 PM
Erland Sommarskog

Let's say I have a list of publications along with the version number. So, publication 1 might have three versions, and publication 2 might have...

christopher.secord@gmail.com

05-19-2009 07:34 AM
christopher.secord@gmail.com

Which editor for T-SQL can you recommend? I'd like it to have code completion invoked by ctrl-space, including: -parameters of functions and stored...

pk

05-19-2009 03:53 AM
pk

Hi... I would like to be given a Stored Proc name as a Parameter then i would like to interogate it for parameters and tables that it uses is there a...

DaveL

05-18-2009 08:51 AM
DaveL

hi, Our app servers are essentially doing the following: In a transaction (READCOMMITTED): select * from T1 with UPDLOCK where pk = ... --...

Hacking Bear

05-17-2009 06:41 PM
Hacking Bear

Canon PowerShot A590IS 8MP Digital Camera with 4x Optical Image Stabilized Zoom Price:$129.99 Image:...

Angiano@norberto.com

05-16-2009 08:40 PM
Angiano@norberto.com

Our current db is returning Msg 823, Sev 24: I/O error (bad page ID) detected during read at offset 0x000024bf7da000 in file...

kennedystephen

05-16-2009 12:03 PM
Erland Sommarskog

Hi All, I'm unable to do this: SELECT A.One, A.Two, A.Three, A.Total as T, T + B.Total FROM TableA A, TableB B What am I doing wrong? Even...

Billy

05-16-2009 03:29 AM
Billy

We've got this database at work where all of the incoming calls are logged. Currently a daily backup of the database is made and restored elsewhere....

Jennifer

05-15-2009 04:31 PM
Erland Sommarskog

Hi All, I have two identical tables containing different values, what I would like to do is return a Result Set that is, for example, a sum of the...

Billy

05-15-2009 07:37 AM
Billy

I have SQL 2008. Through the server Management Studio I run the report Disk Usage report. Under the Data/Log Files Autogrow/Autoshring Events lists...

rcamarda

05-14-2009 04:21 PM
Erland Sommarskog

Hi, I'm a relative noob to SQL Server but have been using Ack!Cess for a long time. Where is a good site for tutorials, or sample DBs so I...

Piet Linden

05-14-2009 03:52 PM
Piet Linden

Server A - SQL 2005 Server B - SQL 2005 Server C - Oracle 10G I have created a linked svr from B->C. It works fine. A->C fails. The err is...

nzrdb6@googlemail.com

05-14-2009 03:14 PM
Michael Austin

We have some code which causes a deadlock on SQL Server 2005 which we cannot work out how. I have attached some sample code which is a very basic...

DBMonitor

05-14-2009 07:09 AM
Dan Guzman

On Sun, 10 May 2009 20:55:52 +0000 (UTC), Erland Sommarskog wrote: (snip) Hi Erland, That's an implementation problem, not a design error. And, as...

shripaldalal@gmail.com

05-13-2009 06:04 PM
Hugo Kornelis

I noticed while installing sql server 2008 express. At early stage in the process, it has a System Configuration Checker (SCC), which is really...

DL

05-13-2009 07:36 AM
DL

I'm wondering if people also experience frequent problems with sql server 2005 express installation onto an XP or Vista box. Recently I receive...

DL

05-13-2009 07:30 AM
DL

Is there a way to get the modification date of a stored procedure?

Jennifer

05-12-2009 04:13 PM
Erland Sommarskog

Having problems with this... I have one master table called SSIDIiaries Two tables: WeeklyDiariesFile and AllDiaries Here are the...

JJ297

05-12-2009 03:01 PM
--CELKO--

Hi everyone, In order to provide security for a database I have been using stored procedures to obtain data from a MS SQL server. I establish an...

Daniel.Peaper@gmail.com

05-11-2009 02:16 AM
Erland Sommarskog

Usenet Rulez wrote: 1) This newsgroup is for Microsoft SQL Server, not MySQL. 2) Take a basic database design class.

Ed Murphy

05-10-2009 10:14 AM
--CELKO--

Bonjour, I'd like to lauch a PHP script once a week. (the server would execute it automaticly). Do you know how to do that ? On Apache server...

Sylvain Hugues ebookers

05-08-2009 08:17 AM
Sylvain Hugues ebookers

Hi, I am not able to use alias column name in dynamic sql.Whether this feature is available or not i dont know? please point me in right direction...

Sreenivas

05-07-2009 05:24 PM
Plamen Ratchev

Got a table that holds multiple hierarchies in the same structure. Suggestions for redesign not be of interest, because I am working with a vendor...

bill

05-07-2009 04:49 PM
Erland Sommarskog

If I try to create this function, I get an error: CREATE FUNCTION udf_test() RETURNS @DATER TABLE ( DATE_THEN datetime --collate...

bill

05-06-2009 04:46 PM
Erland Sommarskog

I am working in MS SQL 2005. I have a growing number of clients and each client gets their own database. The same exact stored procedures are applied...

DennBen

05-06-2009 08:55 AM
DennBen

I am using dot net to call a stored procedure. It to check a session string value for a website. Now this is going to sound weird, but, it fails,...

Robert Skidmore

05-05-2009 12:04 PM
Robert Skidmore

Hello... I'm hoping that someone can help me calculate a monthly billing total. I'm writing a report where I need to account for a minimum price...

fix me

05-02-2009 05:58 PM
Dan Guzman

I will be doing two classes in connection the YAPC (Yet Another Perl Conference) 10th Anniversary conference at Carnegie Mellon University in the...

--CELKO--

04-30-2009 03:58 PM
--CELKO--