Problem opening UDF

Hey,

I am using SQL Server 2005 client tools on a 2000 server. Everything works fine except ................

WHen I try to open (Modify) a user defined function, an error msg appears saying "QuotedIdentifier property not available for the function"

Anyone having same problem and found solution?

This sounds like the following bug, which is scheduled to be fixed in Service Pack 1:
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=FDBK38845
Steve Kass
Drew University
|||Thanks a lot!

problem of creating database

I am using Visula Studio 2005. When i try to create database from the visual studio Tools option-> careate database and press ok then following error occur......

Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.

how can i fix the problem?

first of all you must have a clear picture what is this User intance and do u really want to create user instance. if the answer is yes refer this link the problem is discussed here

http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

If you don't need user instance then go to SQL Server man agement studio and create database

Madhu

|||

i have told that when i am creating database in SQL SERVER 2005, it shows that it can't create instance of sql server. it clearly explains that the user instance is Sql Server instance. See my problem again.......

Here is the error

........

Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.

.........

|||

But...do you want to create user instance, or do you want to create a database on a server instance ? If the latter, you will have to use the server explorer, not the Add New Item > Database.

If you want to create a user instance, you will need to have SQLExpress installed on the machine and configured in the database option of Visual Studio.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Problem installing SSQL Server 2000 client tools

Hi,

I'm trying to re-install SQL Server 2000 Desktop Engine and
SQL Server client tools. I have succesfully re-installed the desktop engine,
but I am getting the following error message when attempting to re-install the
client tools.

"Setup has detected an existing client tools only installation.
Please use the maintenance mode to add client components"

Unfortunately the Upgrade/Add/Remove option is greyed out as
an install option.

I attempted the registry hive rebuild option and the install appeared
to succeed. However, I cannot access any tools (Enterprise Manager
comes up with the message "The selected file cannot be found").

At this point, the desktop engine appears in Add/Remove programs
Window, but no other SQL Server components.

Any help very much appreciated!

Eric Yeoman.
Eventually solved the problem by manually uninstalling SQL Server;

http://support.microsoft.com/kb/290991/#4

Problem Installing SQL Mobile 2005 Tools

I'm trying to install the SQL Mobile 2005 Server tools on a Windows 2003
Server with IIS & MSSQL 2000 sp4.

I've stuck .NET 2.0 on already, but the installer for the server tools
Sqlce30setupen.msi just goes straight to the last page of the wizard and says
the install was interrupted.

I've run the install with logging turned on and this is the last portion of
the trace. Can anyone shed any light on whats going wrong.

-><-

MSI (c) (9C:14) [14:12:35:912]: Doing action: FindRelatedProducts
Action start 14:12:35: FindRelatedProducts.
Action ended 14:12:35: FindRelatedProducts. Return value 1.
MSI (c) (9C:14) [14:12:35:912]: Doing action: AppSearch
Action start 14:12:35: AppSearch.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding IISROOTFOLDER
property. Its value is 'C:\Inetpub\wwwroot\'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\90\Tools\Shell\Services\{CA8A686A-0882-4e79-BCA3-AF3F3AB3EB8A} 3: 2
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding MDACFOUND property.
Its value is '2.80.1022.0'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding ISIISINSTALLED
property. Its value is 'LocalSystem'.
MSI (c) (9C:14) [14:12:35:912]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:912]: PROPERTY CHANGE: Adding SQL2KREPLCLIENT
property. Its value is '{2FAD19D0-E309-11D2-B6E5-00C04F688E8F}'.
MSI (c) (9C:14) [14:12:35:928]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (9C:14) [14:12:35:928]: Note: 1: 2262 2: Signature 3: -2147287038
Action ended 14:12:35: AppSearch. Return value 1.
MSI (c) (9C:14) [14:12:35:928]: Skipping action: CheckOSVersion (condition
is false)
MSI (c) (9C:14) [14:12:35:928]: Doing action: CA_CheckInstalledSQL
Action start 14:12:35: CA_CheckInstalledSQL.
MSI (c) (9C:94) [14:12:35:943]: Invoking remote custom action. DLL:
C:\DOCUME~1\Charlie\LOCALS~1\Temp\1\MSIB.tmp, Entrypoint: CheckInstalledSQL
MSI (c) (9C:88) [14:12:35:943]: Cloaking enabled.
MSI (c) (9C:88) [14:12:35:943]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (9C:88) [14:12:35:943]: Connected to service for CA interface.
Action ended 14:12:36: CA_CheckInstalledSQL. Return value 3.
MSI (c) (9C:14) [14:12:36:005]: Doing action: SetupCompleteError
Action start 14:12:36: SetupCompleteError.
MSI (c) (9C:54) [14:12:36:082]: Note: 1: 2731 2: 0
Action ended 14:13:33: SetupCompleteError. Return value 2.
Action ended 14:12:32: INSTALL. Return value 3.
MSI (c) (EC:00) [14:19:35:619]: Destroying RemoteAPI object.
MSI (c) (EC:0C) [14:19:35:619]: Custom Action Manager thread ending.
=== Logging stopped: 11/01/2006 14:19:35 ===
MSI (c) (EC:34) [14:19:35:619]: Note: 1: 1708
MSI (c) (EC:34) [14:19:35:619]: Product: Microsoft SQL Server 2005 Mobile
[ENU] Server Tools -- Installation operation failed.

-><-

thanks

// charlie

Are you able to repro on any other machine? From log it appears to me that, MDAC, IIS, and SQL 2K are all detected and their properties are changed appropriately. Is that WIN2K3 is upto SP1? If it is so, then only one thing left is .NET FX 2.0. Did you install .NET FX 2.0 after running the MSI and realizing that you need .NET FX 2.0 inorder to proceed?

Try out on a fresh clean PC and let us know how things go there?

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

From your posting http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=202038&SiteID=1, I understand that you were finally able to install the tools. By the way, what was the problem you faced and how did you resolve it?

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

problem installing latest MSDE

I had three problems installing the MSDE.
First, I have SQL Server 7 tools installed and must use Enterprise Manager
to get to an SQL Server 7. When I install MSDE it kills my SQL Server 7
tools. No servers show up anymore and it says I can't add any. Uninstalling
MSDE does not put things back.
Second, no menu is created on the start menu as the instructions say will
happen. I had to look around and find the EXE files.
I am accustomed to doing all my work through Enterprise Manager. I see no
Enterprise Manager facsimile or anything to use for creating a database or
setting up tables in MSDE. ThanksSorry, I don't have a solution, but I can say the reason to why this is happening:
MSDE 2000 installs the DMO dll's. EM uses DMO. And EM7 cannot use the SQL2K DLL's. So, then MSDE
installs the SQL2K DLL's, then the install has to remove EM7 as that wouldn't work anyhow. Perhaps
there's an MSDE install option which doesn't install DMO?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"David McDivitt" <x12code-del@.del-yahoo.com> wrote in message
news:42fkrv0hcr6od8l40qvhli8d2p3j1kr9bb@.4ax.com...
> I had three problems installing the MSDE.
> First, I have SQL Server 7 tools installed and must use Enterprise Manager
> to get to an SQL Server 7. When I install MSDE it kills my SQL Server 7
> tools. No servers show up anymore and it says I can't add any. Uninstalling
> MSDE does not put things back.
> Second, no menu is created on the start menu as the instructions say will
> happen. I had to look around and find the EXE files.
> I am accustomed to doing all my work through Enterprise Manager. I see no
> Enterprise Manager facsimile or anything to use for creating a database or
> setting up tables in MSDE. Thanks
>