Hi, I have created 2 tables, Orders and Order Items. Using C# I am able to add a single order and use that order's ID as an input for OrdersItems...

Hezal

06-25-2008 10:45 PM
Ilya Albrekht

Dear all, Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based Oracle and SQL database backup manager for Windows and available...

info@sifobo.com

06-18-2008 12:47 AM
info@sifobo.com

I am not sure where I have to place this question. My question is how I can integrate Ms Great Plain with Reporting Services. I want to create...

Noor

06-16-2008 01:47 AM
Linchi Shea

I have indexed my db and I don't think it has speeded it up at all ! Do I have to "build" the indexes or anything else ? Best regards KSO, Denmark

KSO

06-12-2008 01:08 PM
Russell Fields

I have searched extensively but have not found an answer, so I am posing the question here: (1) Is there a comparison chart showing the differences...

michael sorens

06-10-2008 11:15 AM
michael sorens

I've got a new client machine with Windows XP SP3. I'm trying to install Proclarity Desktop Pro v. 6.3.129.200. The install starts and then it...

rwilliams3

05-28-2008 02:41 PM
Bob

I have the need to get the last child of each parent. Note: eDate if what points me to the Last child not the c1_id Parent ( pk1_id ,...

LVP

05-28-2008 01:02 PM
LVP

1. Can we create merge replication through script including distribution database. 2. I am wondering if one of the box (either subscriber or...

Rogers

05-28-2008 12:29 PM
Rogers

Thanks for replying but it doesn't work. I got an error message. I think it doesn't like the + sign... Here is the query: SELECT inv2.in2_in1_code,...

Amiro

05-28-2008 10:32 AM
Amiro

I have created Merge Replication and it worked perfactly fine. All the tables and replicating fine. I have created new stored procedure on Publisher...

Noor

05-24-2008 03:13 PM
Ekrem Önsoy

Just want to clarify one thing before i have to BEGIN DISTRIBUTED TRANSACTION on production boxes. here is an example. SET xact_abort ON BEGIN...

Noor

05-23-2008 10:54 AM
Sean McCown

My error log is full of login failed messages: 2008-05-16 19:46:19.19 Logon Login failed for user 'kziv'. 2008-05-16 19:46:19.20 Logon ...

Sagi Shkedy

05-21-2008 10:14 AM
Charles Wang [MSFT]

Hey Guys, I want to generate file end of the day and need to upload into FTP. Is there any way through SSIS or thorugh SQL Server we can generate a...

Rogers

05-16-2008 05:29 PM
Rogers

Hey Guys, i want to ask quick question regarding Merge Replication on two 64 bit SQL Server. Can anyone send me the step by step documentation for...

Rogers

05-15-2008 01:28 PM
Rogers

HELP! I can not create a new database with SQL SERVER MANAGEMENT STUDY EXPRESS and Windows VISTA. ERROR: Permission denied CREATE...

Odla

05-12-2008 02:42 AM
Odla

Sql Server 2005. I have tried installing the SQL Server Management Studio tool on my client workstation from the SQL Server 2005 installation CDs to...

Chaplain Doug

05-08-2008 02:59 PM
KLK

I'm unable to open SQL Server Management Studio. I get and error that it has encountered a problem and needs to close. I'm using a dell latitude...

Allen

05-06-2008 05:05 PM
Subhen Kar [MSFT]

Hi, SQLServer 2000 Personal Edition SP4 Simple Question: I have a small environment with one GUI computer and one Database computer. I have one...

georgejetson

04-29-2008 01:42 AM
Tibor Karaszi

Dear professional, I want to ask one question regarding Database Mirroring. For last 1 year databse mirroring works fine and suddenly the mirroring...

Noor

04-28-2008 08:55 AM
Ekrem Önsoy

Sometimes I need to work on a client system from my laptop, but my laptop is not part of the client's domain. I have login credentials in their...

Paul Shapiro

04-24-2008 06:33 AM
Truan

Hi guys, MSSQL DBA’s life could become easier with the help of a new tool named Secure Auditor which is capable of performing enumeration,...

alvin

04-21-2008 03:08 AM
alvin

Hi Professionals, I want to know how database let application know is any DML operation occurs. We have an application in C++ and in the morning it...

Noor

04-19-2008 08:53 AM
Noor

Hi at all, one week ago, I tried to resolve vs2008 debugging problem; this is my scenario: Windows Vista x64, VS2008 Team Suite, SQL2005. I tried to...

acolmano

04-18-2008 04:36 AM
acolmano

We have a custom application that seems to run fine but when multipe users on a Terminal Server run it at the same time the processor time for the...

Saylrman64

04-16-2008 04:58 PM
Saylrman64

Hi All, I have some programmers that are writing a custom Time/Attendance/Time Billing software for us and they are writing it in VisualStudio. ...

adamwpsd@gmail.com

04-16-2008 04:57 AM
Ekrem Önsoy

I've read that the advantages of sprocs over embedded queries is that the former are compiled once. Does one loose the advantages of stored...

Siegfried Heintze

04-16-2008 01:17 AM
Andrew J. Kelly

Hey guys, couple of questions... I just installed SQL Server 2005 Express on a laptop. I created a database on it, and I'm trying to get into the...

Todd Jaspers

04-15-2008 03:47 PM
Todd Jaspers

I would appreciate if anyone let me know why the log file size is increasing too much. My database size is 15 GB and my log file size is 10...

Test

04-15-2008 10:23 AM
Hans S

Dear professional, I am working with Flex development team, they are development a flex interface and we are using this in the front end and in the...

Noor

04-13-2008 12:11 AM
Mike C#

Just want to clarify one thing before i have to BEGIN DISTRIBUTED TRANSACTION on production boxes. here is an example. SET xact_abort ON BEGIN...

Noor

04-12-2008 06:30 PM
Noor

Dear Professionals. What are the major difference between DTC, this is the services running on our local box and what if I have to installed...

Noor

04-12-2008 05:17 PM
Noor

Dear Professional.. I would highly appreciate if anyone can guide me about SET BEGIN DISTRIBUTED TRANSACTION update first server table update...

Noor

04-11-2008 07:45 PM
Noor

Hi, Sorry, I should've been more clear: There is actually nothing listed in the in SQL server 2005 services in configuration manager. That's my...

srain001

04-10-2008 09:58 AM
Rick Byham, \(MSFT\)

Dear Professional, I would highly appreciate if you can guide me for my one problem, I have two servers and I want to create link server. One is at...

Noor

04-09-2008 09:43 AM
Russell Fields

Can one one let me know the major difference of SQL Server 32 and 64 bit. We are thinking to go with 64 bit but I don't have ample information and...

Noor

04-08-2008 07:51 AM
Andrew J. Kelly

Dear Professional, I am working on trading environment and I am working on SQL Server 2005 at the backend and application designed on C++. Since...

Noor

04-07-2008 10:10 PM
Noor

Dear Professional. I would appreciate if you can guide me one thing. I am working on one of the trading environment and I am expecting billions of...

Noor

04-07-2008 06:25 PM
sekharsql

my problem is the following... Sometimes I create table "X" in my database, I meed someting to know if I have table "X" already created, can you...

Deiny García Pérez

04-07-2008 03:07 PM
Tibor Karaszi

Unable to log into remote Sql Server through a local machine using Visual Studio 2008. I received the following error message: "A connection was...

hal

04-06-2008 03:38 PM
madhu

help,a text how to sql table code ? i have a text as follow, line with ¡°|¡±and...

agiler

04-06-2008 12:10 AM
Linchi Shea

Which one is better in terms of performance? Database mirroring in 2005 or Snap shot replication in 2005 Please advice Thanks in advance.

Test

04-05-2008 04:26 AM
Ekrem Önsoy

Dear professinal, I am having one problem in terms of database mirroring. Is there any way I can resolve my following issues. Communications to...

Test

04-03-2008 04:02 PM
Test

I am using fn_trace_gettable for fetching records from trace file which is around 256 MB. the query is something like select * from...

Munish Narula

04-01-2008 02:27 PM
Andrew J. Kelly

Hi everyone, I am using SQL Server 2005 and I've created 2 tables - Orders and OrderItems and so for each order I have multiple order items. So far...

Hezal

03-31-2008 06:36 AM
Hezal

I am looking for expert advice regarding the simultaneous access one of our production database. In my database I have insert, update and select...

Rogers

03-28-2008 08:13 AM
Linchi Shea

I would appreciate if anyone can let me know which approach is the best for doing error handling. From APPLICATION or FROM Database. Application...

Rogers

03-26-2008 10:24 AM
Mary Chipman [MSFT]

Is there a way to script an Alias in Configuration Manager on the client machines. I do not want to go to each client and point and click. I...

Denny

03-19-2008 10:09 PM
jason

I would appreciate if any one let me know which one is the best for disaster recovery and why. Database Mirroring Replication I am using SQL Server...

Noor

03-18-2008 03:15 PM
Ekrem Önsoy

Thank you soo much Ekrem :) I will try that now.. "Ekrem Önsoy" wrote:

Hezal

03-11-2008 08:45 AM
Hezal

Hi I am kind of new at coding, i dont know if any of you guys can help. I got a webpage with an access table and right now everytime someone visits...

Chris

03-07-2008 09:35 PM
Mike C#