Ekrem, how would the Generate Scripts wizard generate a visual reporesentation of the structure of the DB? I see how it creates samples...

toney

11-13-2007 04:16 PM
Jesse

I have an ERP system deployed which uses SQL Server, and we are currently looking to update to a new version. The new version and the old version...

Troy F.

11-12-2007 01:00 PM
Troy F.

Hi all, a customer has several SQL Servers 2000 and wants to migrate to SQL 2005. Currently used licensing model is per server and user CAL. Does an...

Mario K.

11-11-2007 06:45 PM
Mario K.

I thought it is wscript..name but I got wscript Host instead of the name of eh script being run what should it be?

GS

11-09-2007 09:24 PM
GS

hi.. i transferred my website folder from my server 2003 to my winxp and installed a sql server 2003 express on my xp pc. wheni tried to browse...

chunky

11-07-2007 06:38 PM
chunky

I'm looking for an MMC Snap-in for SQL 2005. I found reference to on for SQL 2000 here http://msdn2.microsoft.com/en-us/library/aa174466(SQL.80).aspx...

Mark

11-05-2007 12:58 PM
Mark

How can I install SQL Server 2005 Business Intelligence on windows XP, is it possible or not. I want to design all my resports through BI, need...

Rogers

11-02-2007 12:03 PM
Ekrem Önsoy

Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml...

DR

11-01-2007 06:05 PM
Mike C#

How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a...

DR

10-30-2007 03:30 PM
DR

Hi All Is there any tools to fix log file my H.D.D have bad sector and that on SQL server directory on my database login file(x_db_login.idf) so I...

MOH. I.OWN

10-26-2007 02:05 PM
Russell Fields

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to...

DR

10-24-2007 10:39 PM
DR

what is the best way to store passwords and credit card information in SQL Server 2005?

dr

10-21-2007 10:02 AM
Ekrem Önsoy

I'm trying to use SQL Server 2005 Compact Edition (3.1) with the Enterprise Library data access block (3.1) . I want to be able to use...

Roger Solano

10-19-2007 10:06 AM
Roger Solano

I'm trying to use SQL Server 2005 Compact Edition (3.1) with the Enterprise Library data access block (3.1) . I want to be able to use...

Roger Solano

10-19-2007 10:04 AM
Roger Solano

Hello! The OS I use in windows 2000 professional. I'm going to install SQL Server 2005 and there are three different versions. These are SQL Sever...

TonyJ

10-17-2007 06:53 AM
Razvan Socol

Hi, I installed SQLServer with a instance using the following cmd: /qn INSTANCENAME=MYINSTANCE ADDLOCAL=All...

JP

10-16-2007 07:38 AM
JP

Hello there, just a small question: is the SQL Server 2008 CTP July compatible with the second Visual Studio 2008 BETA? And are these two compatible...

German_BI_Developer

10-15-2007 05:55 AM
German_BI_Developer

Can I use port 88 for SQL Server 2005, just wanted to confirm is it in used by another application, or any tool where I can findout this?

Rogers

10-11-2007 03:35 AM
Saleem Hakani

Can I use same port for SQL server 2000 & 2005, i.e 1433?

Rogers

10-11-2007 02:57 AM
Saleem Hakani

I had a production box that has a database called ECom. I installed reporting services on that box as well. My all reports are stored...

Noor

10-09-2007 11:25 PM
Noor

Hi Noor, You have to backup/restore the database master key and restore that also. THe master key is not backed up in the full database...

Mohit K. Gupta

10-08-2007 12:08 PM
Noor

What is the recommended approach regarding the client tools and application connectivity in a mixed environment where we have SQL Server 2000 and are...

Spencer

10-06-2007 09:18 PM
Saleem Hakani

Hi, I just came across the new feature list of SQL Server 2008 - "Word based report authoring", do I interpret it right when I think it enables me...

michael mueller

10-05-2007 06:37 PM
Kent Tegels

I have two problems, I installed access 2007 when I have been using XP before. I have a program written in access 2003 mdb and I...

MUSIWA

10-05-2007 10:42 AM
MUSIWA

Hi I've failed to turn on single-user mode. I've used the following command sp_dboption <my database>, 'single user', True I've got the...

KHATER

10-01-2007 06:12 AM
KHATER

Hi there-- I'm connecting to SQL Server Express from MS Access via ADO on a number of older workstations. Of three workstations, two connect...

Kevin Chambers

09-29-2007 01:38 PM
Tibor Karaszi

I have a stored procedure with some input parameter and one output parameter. I use SqlCommand and SqlParameter as following ///Set some imput...

Roy

09-28-2007 04:12 PM
Roy

Hi, I have a program written in C/C++ compiled with MS Visual Studio 6.0 that fails to connect to a french SQL Server instance (probably a 2005...

John

09-28-2007 02:15 PM
Linchi Shea

I have SQLServer 2005 installed that has database in which I implemented Symmetric AES_128 encryption and database works fine, when I took the...

Rogers

09-27-2007 05:57 PM
Rogers

I would like to know if derived tables are allowed in SELECT statements in Compact Edition 3.1 For example: SELECT * FROM (SELECT * FROM SomeTable)...

arothberg

09-26-2007 11:41 PM
Peter YangMSFT]

Dear Professional, What would be the best answer if I ask when we use Symmetric Encryption Key and Asymmetric Encryption in terms of SQL Server 2005...

Rogers

09-25-2007 05:09 AM
Ekrem Önsoy

I appologise if this is silly but I am trying. I upsized my access mdb database to access project (adp) sql. It works very well now. my is I now copy...

MUSIWA

09-19-2007 05:38 PM
MUSIWA

In SQL server 6.5, I've got the message (the application log file is full) after restarting the server and before login. this makes the working...

KHATER

09-18-2007 10:51 AM
Russell Fields

I want to disable the identity property on one of my column, can any one tell me how I can do that from query analyzer, I can do that from...

Rogers

09-15-2007 08:51 PM
Mike C#

Hello, I have a client app that connects to a remote instance of SQL Server 2005 Express. The client uses the SQL Browser to locate available SQL...

Keith

09-15-2007 03:19 PM
Tibor Karaszi

I have a VB.NET application using SQL Server that I have been developing using a test database. Recently I wrote a program to convert data from...

Andy Baker

09-12-2007 04:52 AM
Andy Baker

Our Access 2000 database (a front end to MSSQL2000 data) has two main tables with a 1-1 relationship. Call them Client and Assessment. (Why? ...

David H.

09-10-2007 03:49 PM
Russell Fields

I am using SQL Server 2005 Developer edition and I am successfully connected from one of Xp box as I mentioned in my post. "Ekrem Önsoy" <ekrem...

Noor

09-08-2007 03:30 PM
Noor

I want to create DDL trigger like if any view create in the database I want to know the name of the view. like CREATE trigger trg_SelectViewRights...

Rogers

09-07-2007 06:30 PM
Hugo Kornelis

Hi Ekrem thanks for your help ;-) Ekrem Önsoy ha scritto: tipically the SQL server will run on a Windows Server 2003r2 with 1 GB of RAM.... but...

Hornet77

09-07-2007 06:59 AM
Hornet77

How can I change SQL Server 2005 port?

Rogers

09-07-2007 05:16 AM
Jonathan Psaila-Depasquale

Dear professional What would be the best approach and secure. Step 1: Create Master Key. Step 2: Create Symmetric Key Ecryption by Password OR

Rogers

09-07-2007 12:12 AM
Rogers

Same connection string I am using in XP box it works but not in Windows 2003. "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Rogers

09-06-2007 04:50 AM
Rogers

Dear professional. In the ErrorLog file I can see following two entries 2007-09-06 12:01:04.23 Server Server is listening on . 2007-09-06...

Rogers

09-06-2007 02:36 AM
Rogers

Just thinking about disaster recovery, if I want to move the database into another server then how I get the Master Key, Certificate and...

Rogers

09-06-2007 01:27 AM
Rogers

Thanks.... "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Rogers

09-06-2007 01:25 AM
Rogers

Yes, its true and I can ping the remote server. "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Rogers

09-06-2007 01:25 AM
Rogers

Hi, Does anyone know that when I tried to open "Enterprise Manager", it appears error message "The procedure entry point wcscpy could not be located...

=?Utf-8?B?VG9t?=

09-06-2007 12:30 AM
=?Utf-8?B?VG9t?=

Thanks Ekrem "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Rogers

09-06-2007 12:30 AM
Rogers

--------------------------- Visual Studio Just-In-Time Debugger --------------------------- An unhandled win32 exception occurred in msiexec.exe ....

Rogers

09-05-2007 11:26 PM
Rogers