Environment Variables

Hi everyone...

I'm trying to create a database with the parent directory being a environment variable,

something like this:

Code Snippet

CREATE DATABASE mydatabase
ON
PRIMARY(NAME = myDataBase,
FILENAME = '%PARENTDIRECTORY%\mydatabase.mdf',

the problem is I don't know to get an environment variable in transact SQL...

I know that in C# we can get it with %PARENTDIRECTORY%...

Thanx in advance

The following batch may help you...

Code Snippet

Create Table #Result

(

Data varchar(8000)

);

Insert Into #Result

Exec master..xp_cmdshell 'echo %TEMP%';

Declare @.ParentDirectory as nvarchar(256);

Select Top 1 @.ParentDirectory = Data From #result;

Select @.ParentDirectory = @.ParentDirectory + '\mydatabase.mdf'

Exec ('CREATE DATABASE mydatabase

ON

PRIMARY(NAME = myDataBase,

FILENAME = ''' + @.ParentDirectory + ''')')

Drop table #result

|||Thanx Manivannan the code above does the job, but doesn't the xp_cmdshell work only for XP users?

|||

sqlclr's udf can imprement below,

This assembly's permission need to 'EXTERNAL_ACCESS'.

Usage:

Code Snippet

select dbo.GetEnvironmentVariable('temp');

C# Source file:

Code Snippet

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction(DataAccess=DataAccessKind.None)]
public static SqlString GetEnvironmentVariable(string variable)
{
string value = Environment.GetEnvironmentVariable(variable);
return new SqlString(value);
}
};

Enumeration variables??

Is it possible to create variables of type enum in PL/SQL?
In VB.NET it would be something like e.g.: enum seasons {Spring, Summer, Autumn, Winter}
Thx.Originally posted by OracleDev
Is it possible to create variables of type enum in PL/SQL?
In VB.NET it would be something like e.g.: enum seasons {Spring, Summer, Autumn, Winter}

Thx.
No, PL/SQL does not have such a type.|||I feared this, because I couldn't find info about it.

Thx anyway.

Enterprise Manager problem with views

We have a user who is a db_owner on a database that he can't create a view using Enterprise Manager. When he tries to create a view it returns: "ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '240'." His NT Domain username is 240DBH.

We've tried it on my computer with him logging on and get the same result. He can create views just fine using query analyzer. Does anybody know what's wrong with doing this in Enterprise Manager? By the way, I can create views in the db using Enterprise Manager just fine.

Thanks for your help!Turn Profiler on and see what commands Enterprise is sending to the server to create this view. It may shed some light.|||Thanks for the suggestion! I hadn't used the profiler before. It is trying to execute the following:

CREATE VIEW 240dbh.VIEW1
AS
SELECT ID, [Start Date]
FROM T_DATA

Now, when I run this in query analyzer, I get the same error. It seems like that should work to me.:confused:|||Now I think I have it narrowed down. His username starts with numbers. If you can't have a username that starts with numbers, that is pretty lame.

Does anyone know if there is a better front-end than enterprise manager for creating tables/views/stored procedures?

Thanks!|||User names with numbers are not a problem. Does the user have ddladmin rights?

If you are using SS2K than use the Query Analyzer! Much better for users than the EM!|||I set up a user under sql server 7 with a username that has no numbers with the exact same permissions as that user who can't create a view.

That new user with no numbers can create views just fine.

So, the only difference between the two users is that one is a sql server logon and one uses NT domain authentication, and the fact that one has numbers in the username.

What I'm finding is that if enterprise manager would do something like:
CREATE VIEW [240dbh].VIEW1

instead of:
CREATE VIEW 240dbh.VIEW1

it would work.

Enterprise Manager for SQL2000

Hi everyone:)
would someone know where I can download "enterprise Manager"
( I have to create DB for SQL 2000)
do not know what else to use (do not want Ms access :)
unless is there a way ro convert access in sql?
Thanks in advance
quinyIt should be on the installation CD as part of the client tools if you have bought it.

Enterprise Manager for SQL server 2005

Hi,

i just installed sql 2k5 server and client tools.

When i run SQL ServerManagment Studio i dont find a way to create database.

Sajajd

Right click Databases. It will give you the option to create a new database.

Adamus

|||

First thing you have to do is to connect to the server so that you can view the system in the object explorer... once there expand the server so that you can view the database tab and as above right click and select create database or new database.

enterprise manager entries

I create SQL Server Groups in Enterprise manager and for
some reason and at what seems like random times they all
go away. I see a blank list under SQL Server Groups.
I checked the registry entry below and all SQL Server
Groups that I created are there.
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X\SQL Server
Group
With that information, is there a way to hook it back
together so what is in the registry is what is displayed
in enterprise manager for SQL Server?
Thanks
RickRick,
Strange!What service pack and OS are you on?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rick Allison" <allisonrja@.hotmail.com> wrote in message
news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> I create SQL Server Groups in Enterprise manager and for
> some reason and at what seems like random times they all
> go away. I see a blank list under SQL Server Groups.
> I checked the registry entry below and all SQL Server
> Groups that I created are there.
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group
> With that information, is there a way to hook it back
> together so what is in the registry is what is displayed
> in enterprise manager for SQL Server?
> Thanks
> Rick
>|||Dinesh,
I am running Windows XP and enterprise manager version 8.0. (at least
that's what is says in help about)
Does that help?
Rick
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> Rick,
> Strange!What service pack and OS are you on?
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > I create SQL Server Groups in Enterprise manager and for
> > some reason and at what seems like random times they all
> > go away. I see a blank list under SQL Server Groups.
> >
> > I checked the registry entry below and all SQL Server
> > Groups that I created are there.
> > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > Group
> >
> > With that information, is there a way to hook it back
> > together so what is in the registry is what is displayed
> > in enterprise manager for SQL Server?
> >
> > Thanks
> >
> > Rick
> >
> >
>|||Rick,
Thanks but I need the service pack(sp) info. too to report this case in mvp
newsgroup.You can find the sp info by executing the below command in Query
Analyzer
SELECT SERVERPROPERTY('PRODUCTLEVEL')
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rick Allison" <allisonrja@.hotmail.com> wrote in message
news:%23umCGTpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> Dinesh,
> I am running Windows XP and enterprise manager version 8.0. (at least
> that's what is says in help about)
> Does that help?
> Rick
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > Rick,
> >
> > Strange!What service pack and OS are you on?
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > > I create SQL Server Groups in Enterprise manager and for
> > > some reason and at what seems like random times they all
> > > go away. I see a blank list under SQL Server Groups.
> > >
> > > I checked the registry entry below and all SQL Server
> > > Groups that I created are there.
> > > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > > Group
> > >
> > > With that information, is there a way to hook it back
> > > together so what is in the registry is what is displayed
> > > in enterprise manager for SQL Server?
> > >
> > > Thanks
> > >
> > > Rick
> > >
> > >
> >
> >
>|||Rick,
Thanks.Can you try upgrading to SP3 or latest SP3a?the download is available
at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
The reason for my advice is , may be, its due to the slammer worm.More
details
http://www.microsoft.com/sql/techinfo/administration/2000/security/slammer.asp
Even if you report this error(or bug), the first suggestion would be to go
in for the latest service pack.So do a test of your app. in a test env. with
SP3(a) and if okay, then go for the same with prod.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rick Allison" <allisonrja@.hotmail.com> wrote in message
news:ObqkmvpWDHA.1872@.TK2MSFTNGP12.phx.gbl...
> Dinesh,
> The query returned - SP2
> Rick
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:OANx1WpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > Rick,
> >
> > Thanks but I need the service pack(sp) info. too to report this case in
> mvp
> > newsgroup.You can find the sp info by executing the below command in
Query
> > Analyzer
> >
> > SELECT SERVERPROPERTY('PRODUCTLEVEL')
> >
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > news:%23umCGTpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > > Dinesh,
> > >
> > > I am running Windows XP and enterprise manager version 8.0. (at least
> > > that's what is says in help about)
> > >
> > > Does that help?
> > >
> > > Rick
> > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > > > Rick,
> > > >
> > > > Strange!What service pack and OS are you on?
> > > >
> > > > --
> > > > Dinesh.
> > > > SQL Server FAQ at
> > > > http://www.tkdinesh.com
> > > >
> > > > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > > > news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > > > > I create SQL Server Groups in Enterprise manager and for
> > > > > some reason and at what seems like random times they all
> > > > > go away. I see a blank list under SQL Server Groups.
> > > > >
> > > > > I checked the registry entry below and all SQL Server
> > > > > Groups that I created are there.
> > > > > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > > > > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > > > > Group
> > > > >
> > > > > With that information, is there a way to hook it back
> > > > > together so what is in the registry is what is displayed
> > > > > in enterprise manager for SQL Server?
> > > > >
> > > > > Thanks
> > > > >
> > > > > Rick
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Dinesh,
Okay - I'll go try.
I am, however, a developer in a large corporation and I use enterprise
manager to point to many different SQL Server databases, test and
production. Do I need to have each database updated or can I just update
enterprise manager that is loaded on my computer?
If I need to do each database, that is not a simple task. (sigh)
Thanks for all your help.
Rick
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:O%23FGn4pWDHA.3404@.tk2msftngp13.phx.gbl...
> Rick,
> Thanks.Can you try upgrading to SP3 or latest SP3a?the download is
available
> at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
> The reason for my advice is , may be, its due to the slammer worm.More
> details
>
http://www.microsoft.com/sql/techinfo/administration/2000/security/slammer.asp
> Even if you report this error(or bug), the first suggestion would be to go
> in for the latest service pack.So do a test of your app. in a test env.
with
> SP3(a) and if okay, then go for the same with prod.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> news:ObqkmvpWDHA.1872@.TK2MSFTNGP12.phx.gbl...
> > Dinesh,
> >
> > The query returned - SP2
> >
> > Rick
> >
> > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > news:OANx1WpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > > Rick,
> > >
> > > Thanks but I need the service pack(sp) info. too to report this case
in
> > mvp
> > > newsgroup.You can find the sp info by executing the below command in
> Query
> > > Analyzer
> > >
> > > SELECT SERVERPROPERTY('PRODUCTLEVEL')
> > >
> > >
> > > --
> > > Dinesh.
> > > SQL Server FAQ at
> > > http://www.tkdinesh.com
> > >
> > > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > > news:%23umCGTpWDHA.1900@.TK2MSFTNGP10.phx.gbl...
> > > > Dinesh,
> > > >
> > > > I am running Windows XP and enterprise manager version 8.0. (at
least
> > > > that's what is says in help about)
> > > >
> > > > Does that help?
> > > >
> > > > Rick
> > > > "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> > > > news:uZ6mdGpWDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > > > > Rick,
> > > > >
> > > > > Strange!What service pack and OS are you on?
> > > > >
> > > > > --
> > > > > Dinesh.
> > > > > SQL Server FAQ at
> > > > > http://www.tkdinesh.com
> > > > >
> > > > > "Rick Allison" <allisonrja@.hotmail.com> wrote in message
> > > > > news:edc3f8oWDHA.2056@.TK2MSFTNGP11.phx.gbl...
> > > > > > I create SQL Server Groups in Enterprise manager and for
> > > > > > some reason and at what seems like random times they all
> > > > > > go away. I see a blank list under SQL Server Groups.
> > > > > >
> > > > > > I checked the registry entry below and all SQL Server
> > > > > > Groups that I created are there.
> > > > > > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > > > > > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > > > > > Group
> > > > > >
> > > > > > With that information, is there a way to hook it back
> > > > > > together so what is in the registry is what is displayed
> > > > > > in enterprise manager for SQL Server?
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > Rick
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Enterprise Manager data entry limit

I have a table that has several fields of data type varchar
(4000). I cannot enter more that 1024 characters using
Enterprise Manager. I can create a table in Access and
import it or use VB to populate the table without any
problem. Why doesn't EM allow data to be entered up to the
field length in the table design?
Hi,
Sorry to tell this.
Enterprise manager is a GUI tool to do database administration, it is not a
tool to do data entry. You can very well
use Query Analyzer to insert the text data into a table using INSERT
statement.
Insert into table_name values('jhsajdhaskdlksadhsalkdjsaldjlsadjlsajdjl.. .n
characters)
Thanks
Hari
MCDBA
"Colin" <anonymous@.discussions.microsoft.com> wrote in message
news:1db6a01c4546c$17824130$a101280a@.phx.gbl...
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?
|||Colin,
I don't know the answer to your question, perhaps its a limit of the
grid control that is used? I have a question for you. Why do you want to
insert such huge values through Enterprise Manager? Why not just write a
quick script in Query Analyzer to insert the data?
Also beware that you could run into problems if all your field lengths
exceed the size of a data page (8k).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Colin wrote:
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?
|||Thanks for the replies.
I understand EM is not the tool to use for data
entry...just curious why it limited data entry in this
way.
|||Hi Colin,
I've been chatting with the SQL MVPs and some people at Microsoft about
this issue on your behalf, and I was told to RTFM. :-) SQL MVP, Steve
Kass pointed this out to me:
"Some of the limitations of Enterprise Manager are documented in the
following Books Online article:
Editing Rows in the Results Pane
In particular, that article says:
You can edit a memo-type column (such as a text, memo, or long character
column) if the column does not display <Long Text>. The Results pane can
accept up to 900 characters of text in memo-type columns. If you are
typing in a cell and exceed the amount of text that the Results pane can
accept, the Query Designer will beep to indicate that you have exceeded
this limit."
I hope this helps further.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Colin wrote:
> Thanks for the replies.
> I understand EM is not the tool to use for data
> entry...just curious why it limited data entry in this
> way.

Enterprise Manager data entry limit

I have a table that has several fields of data type varchar
(4000). I cannot enter more that 1024 characters using
Enterprise Manager. I can create a table in Access and
import it or use VB to populate the table without any
problem. Why doesn't EM allow data to be entered up to the
field length in the table design?Hi,
Sorry to tell this.
Enterprise manager is a GUI tool to do database administration, it is not a
tool to do data entry. You can very well
use Query Analyzer to insert the text data into a table using INSERT
statement.
Insert into table_name values('jhsajdhaskdlksadhsalkdjsaldjlsad
jlsajdjl...n
characters)
Thanks
Hari
MCDBA
"Colin" <anonymous@.discussions.microsoft.com> wrote in message
news:1db6a01c4546c$17824130$a101280a@.phx
.gbl...
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?|||Colin,
I don't know the answer to your question, perhaps its a limit of the
grid control that is used? I have a question for you. Why do you want to
insert such huge values through Enterprise Manager? Why not just write a
quick script in Query Analyzer to insert the data?
Also beware that you could run into problems if all your field lengths
exceed the size of a data page (8k).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Colin wrote:
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?|||Thanks for the replies.
I understand EM is not the tool to use for data
entry...just curious why it limited data entry in this
way.|||Hi Colin,
I've been chatting with the SQL MVPs and some people at Microsoft about
this issue on your behalf, and I was told to RTFM. :-) SQL MVP, Steve
Kass pointed this out to me:
"Some of the limitations of Enterprise Manager are documented in the
following Books Online article:
Editing Rows in the Results Pane
In particular, that article says:
You can edit a memo-type column (such as a text, memo, or long character
column) if the column does not display <Long Text>. The Results pane can
accept up to 900 characters of text in memo-type columns. If you are
typing in a cell and exceed the amount of text that the Results pane can
accept, the Query Designer will beep to indicate that you have exceeded
this limit."
I hope this helps further.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Colin wrote:
> Thanks for the replies.
> I understand EM is not the tool to use for data
> entry...just curious why it limited data entry in this
> way.

Enterprise Manager data entry limit

I have a table that has several fields of data type varchar
(4000). I cannot enter more that 1024 characters using
Enterprise Manager. I can create a table in Access and
import it or use VB to populate the table without any
problem. Why doesn't EM allow data to be entered up to the
field length in the table design?Hi,
Sorry to tell this.
Enterprise manager is a GUI tool to do database administration, it is not a
tool to do data entry. You can very well
use Query Analyzer to insert the text data into a table using INSERT
statement.
Insert into table_name values('jhsajdhaskdlksadhsalkdjsaldjlsadjlsajdjl...n
characters)
Thanks
Hari
MCDBA
"Colin" <anonymous@.discussions.microsoft.com> wrote in message
news:1db6a01c4546c$17824130$a101280a@.phx.gbl...
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?|||Colin,
I don't know the answer to your question, perhaps its a limit of the
grid control that is used? I have a question for you. Why do you want to
insert such huge values through Enterprise Manager? Why not just write a
quick script in Query Analyzer to insert the data?
Also beware that you could run into problems if all your field lengths
exceed the size of a data page (8k).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Colin wrote:
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?|||Thanks for the replies.
I understand EM is not the tool to use for data
entry...just curious why it limited data entry in this
way.|||Hi Colin,
I've been chatting with the SQL MVPs and some people at Microsoft about
this issue on your behalf, and I was told to RTFM. :-) SQL MVP, Steve
Kass pointed this out to me:
"Some of the limitations of Enterprise Manager are documented in the
following Books Online article:
Editing Rows in the Results Pane
In particular, that article says:
You can edit a memo-type column (such as a text, memo, or long character
column) if the column does not display <Long Text>. The Results pane can
accept up to 900 characters of text in memo-type columns. If you are
typing in a cell and exceed the amount of text that the Results pane can
accept, the Query Designer will beep to indicate that you have exceeded
this limit."
I hope this helps further.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Colin wrote:
> Thanks for the replies.
> I understand EM is not the tool to use for data
> entry...just curious why it limited data entry in this
> way.|||Can one of you experts give me some solutions?
We have small web-based sale order system linked to SQL server. One of the web page fields: "Remark" field only accepts 250 characters.
On the web page, the Remark field will let you type more than 250 characters. However, it only display maximum 250 characters in print preview. Any solutions?
Thank you in advance for any sugguestions.
"Colin" wrote:
> I have a table that has several fields of data type varchar
> (4000). I cannot enter more that 1024 characters using
> Enterprise Manager. I can create a table in Access and
> import it or use VB to populate the table without any
> problem. Why doesn't EM allow data to be entered up to the
> field length in the table design?
>

Enterprise Manager Create Date

Folks,
When viewing the tables of the databases we have on our Server, the
values in the "Create Date" column are generally of the format
"DD/MM/YYYY HH:MM:SS". Curiously however, I just had to recreate one
of the tables, and on that table alone the create date displayed is
"YYYY-MM-DD HH:MM:SS.FFF" (FFF = fractions of a second I assume?)
Anyone know why this has changed? Could it be some kind of change of
regional settings on the Server?
Suggestions invited
Thanks
SteveSteve Hall wrote:
> Folks,
> When viewing the tables of the databases we have on our Server, the
> values in the "Create Date" column are generally of the format
> "DD/MM/YYYY HH:MM:SS". Curiously however, I just had to recreate one
> of the tables, and on that table alone the create date displayed is
> "YYYY-MM-DD HH:MM:SS.FFF" (FFF = fractions of a second I assume?)
> Anyone know why this has changed? Could it be some kind of change of
> regional settings on the Server?
See if it helps you:
Solving the Datetime Mystery (SQL Server Magazine)
http://www.winnetmag.com/SQLServer/.../9147/9147.html
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote in message news:
<OoKQfbfBEHA.2804@.tk2msftngp13.phx.gbl>...
> Steve Hall wrote:
> See if it helps you:
> Solving the Datetime Mystery (SQL Server Magazine)
> http://www.winnetmag.com/SQLServer/.../9147/9147.html
> sincerely,
Sebastian,
Thanks for that... but I think I may be missing something still - that
information suggests how I can format dates returned from queries...
But this is the table's create date property - internal to SQL - where
is that format defined?
Forgive me if I am still missing your point!
Steve

Enterprise Manager Corrupted?

We create a simple maintenance plan with no error. When we go back to edit the settings, many have defaulted.
In particular, the backup definition loses the definition of where to backup files to on the disk is cleared, and the Device option is checked.
Further, in delete files older than, the selector will not populate (although we can manually enter a number), and the drop-down that should show "hours", "Days" etc, is completely empty, and we cannot enter anything.
Suggestions?
Have your client tools been updated with SP3?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"jnorman" <anonymous@.discussions.microsoft.com> wrote in message
news:ADE1F886-6641-4741-ABD4-BFED23FD7AED@.microsoft.com...
> We create a simple maintenance plan with no error. When we go back to edit
> the settings, many have defaulted.
> In particular, the backup definition loses the definition of where to
> backup files to on the disk is cleared, and the Device option is checked.
> Further, in delete files older than, the selector will not populate
> (although we can manually enter a number), and the drop-down that should
> show "hours", "Days" etc, is completely empty, and we cannot enter
> anything.
> Suggestions?
>
|||Good idea. In fact it turns out that, despite assurances
to the contrary, our new client had NOT upgraded to sp3.
So we installed it.
Unfortunately, We still have the same problem. We can
still save an original maintenance plan, although the drop-
down list for the number of time units to delete after is
still blank (it apparently defaults to "weeks," though).
The original save is error-free, but to save any mods
generates this error:
error 8114: error converting data type int to tinyint
We still have no way to simply modify a maintenance plan.
More suggestions?
>--Original Message--
>Have your client tools been updated with SP3?
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>"jnorman" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ADE1F886-6641-4741-ABD4-BFED23FD7AED@.microsoft.com...
we go back to edit
definition of where to
option is checked.
not populate
down that should
cannot enter
>
>.
>
|||What is the database compatibility? What hotfixes have been applied? Have
you restored master or msdb from another place or another version?
I'm just trying to think of things which would make a system-used datatype
change, and usually these are restricted to service pack/version releases.
A
<anonymous@.discussions.microsoft.com> wrote in message
news:153c901c41a8d$122349f0$a601280a@.phx.gbl...
> Good idea. In fact it turns out that, despite assurances
> to the contrary, our new client had NOT upgraded to sp3.
> So we installed it.
> Unfortunately, We still have the same problem. We can
> still save an original maintenance plan, although the drop-
> down list for the number of time units to delete after is
> still blank (it apparently defaults to "weeks," though).
> The original save is error-free, but to save any mods
> generates this error:
> error 8114: error converting data type int to tinyint
> We still have no way to simply modify a maintenance plan.
> More suggestions?
> message
> we go back to edit
> definition of where to
> option is checked.
> not populate
> down that should
> cannot enter

Enterprise Manager Corrupted?

We create a simple maintenance plan with no error. When we go back to edit t
he settings, many have defaulted.
In particular, the backup definition loses the definition of where to backup
files to on the disk is cleared, and the Device option is checked.
Further, in delete files older than, the selector will not populate (althoug
h we can manually enter a number), and the drop-down that should show "hours
", "Days" etc, is completely empty, and we cannot enter anything.
Suggestions?Have your client tools been updated with SP3?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"jnorman" <anonymous@.discussions.microsoft.com> wrote in message
news:ADE1F886-6641-4741-ABD4-BFED23FD7AED@.microsoft.com...
> We create a simple maintenance plan with no error. When we go back to edit
> the settings, many have defaulted.
> In particular, the backup definition loses the definition of where to
> backup files to on the disk is cleared, and the Device option is checked.
> Further, in delete files older than, the selector will not populate
> (although we can manually enter a number), and the drop-down that should
> show "hours", "Days" etc, is completely empty, and we cannot enter
> anything.
> Suggestions?
>|||Good idea. In fact it turns out that, despite assurances
to the contrary, our new client had NOT upgraded to sp3.
So we installed it.
Unfortunately, We still have the same problem. We can
still save an original maintenance plan, although the drop-
down list for the number of time units to delete after is
still blank (it apparently defaults to "weeks," though).
The original save is error-free, but to save any mods
generates this error:
error 8114: error converting data type int to tinyint
We still have no way to simply modify a maintenance plan.
More suggestions?
>--Original Message--
>Have your client tools been updated with SP3?
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>"jnorman" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ADE1F886-6641-4741-ABD4-BFED23FD7AED@.microsoft.com...
we go back to edit
definition of where to
option is checked.
not populate
down that should
cannot enter
>
>.
>|||What is the database compatibility? What hotfixes have been applied? Have
you restored master or msdb from another place or another version?
I'm just trying to think of things which would make a system-used datatype
change, and usually these are restricted to service pack/version releases.
A
<anonymous@.discussions.microsoft.com> wrote in message
news:153c901c41a8d$122349f0$a601280a@.phx
.gbl...
> Good idea. In fact it turns out that, despite assurances
> to the contrary, our new client had NOT upgraded to sp3.
> So we installed it.
> Unfortunately, We still have the same problem. We can
> still save an original maintenance plan, although the drop-
> down list for the number of time units to delete after is
> still blank (it apparently defaults to "weeks," though).
> The original save is error-free, but to save any mods
> generates this error:
> error 8114: error converting data type int to tinyint
> We still have no way to simply modify a maintenance plan.
> More suggestions?
> message
> we go back to edit
> definition of where to
> option is checked.
> not populate
> down that should
> cannot enter|||The SQL Server 2000 instance was originally installed (by another
consultant) last summer. I doubt that any hot fixes were applied before we
came onto the scene in December, since, as you saw, they never got around to
applying SP3.
The master/msdb were installed fresh, I'm sure (the other vendor wasn't
sophisticated enough to know how to do any of that.
Any other thoughts? I'm sort of getting the idea that we probably have no
choice but to rip it out and reinstall?
J
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OHyiE7oGEHA.2052@.TK2MSFTNGP11.phx.gbl...
> What is the database compatibility? What hotfixes have been applied?
Have
> you restored master or msdb from another place or another version?
> I'm just trying to think of things which would make a system-used datatype
> change, and usually these are restricted to service pack/version releases.
> A
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:153c901c41a8d$122349f0$a601280a@.phx
.gbl...
>

Enterprise Manager and its particularities

Dear all,
I'm fed up with this problem. I hate that behaviour.
When I create objects from a query analyser session in my own workstation,
then these objects doesn't visible from my MMC. A lot of times I am obligate
d
to close and open again.
I've got a MMC with 13 Sql Server and some of them are remote but I don't
think that that aspect could to interfere in the response for do a refresh.
In a fact I do highest level refresh but nothing happens, objects such as
views, sp or tables are missing.
It's a waste time. Why on earth is happening this?
Thanks a lot and regards,Enric wrote:
> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own
> workstation, then these objects doesn't visible from my MMC. A lot of
> times I am obligated to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I
> don't think that that aspect could to interfere in the response for
> do a refresh. In a fact I do highest level refresh but nothing
> happens, objects such as views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,
I've seen a few others post this issue on SQL EM, but most of us here
have not experienced the problem. With me, anyway, a selecting the
Refresh context menu option performs the necessary refresh and the new
objects appear.
Can you document the steps to consistently reproduce the refresh issue
or is this something that does not occur with any consistency?
Also, what version of SQL EM are you using? Check Help | About and post
the full version.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Enric wrote:
> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own
> workstation, then these objects doesn't visible from my MMC. A lot of
> times I am obligated to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I
> don't think that that aspect could to interfere in the response for
> do a refresh. In a fact I do highest level refresh but nothing
> happens, objects such as views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,
Clarification: For the version, just let us know what SQL Server service
pack you've installed on your client. The version appears to only show
the major version, not the SP level.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||What happend if instead closing, you just disconnect and connect agaiin to
the server?
AMB
"Enric" wrote:

> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own workstation,
> then these objects doesn't visible from my MMC. A lot of times I am obliga
ted
> to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I don't
> think that that aspect could to interfere in the response for do a refresh
.
> In a fact I do highest level refresh but nothing happens, objects such as
> views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,|||You need to refresh at the right level. Don't do the highest level. Refresh
doesn't work "all the
way down". Do refresh on the right container.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:259BA9D3-01BE-4962-8F1F-86EB413D4C32@.microsoft.com...
> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own workstation,
> then these objects doesn't visible from my MMC. A lot of times I am obliga
ted
> to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I don't
> think that that aspect could to interfere in the response for do a refresh
.
> In a fact I do highest level refresh but nothing happens, objects such as
> views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,|||EM is not "active" in the sense that it does not sense changes it does not
make. It is an application that initializes iteslf with data, and knows wha
t
IT does, but not what others (Query Analyzer) do until it re-selects data.
If you want to see new tables, right-click on the "tables" tree in the left
pane and select "refresh". Your new tables will now appear. You can refres
h
at various levels, but the higher-up you go, the longer it will take.
"David Gugick" wrote:

> Enric wrote:
> Clarification: For the version, just let us know what SQL Server service
> pack you've installed on your client. The version appears to only show
> the major version, not the SP level.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Thanks to all for response.
Tibor,
Your fix not always works.
David,
All the SQL SERVERS (2000) own sp3 and sp3a for olap services.
I think that it could be a network problem between domains or something like
that. There are two sql server which are living in an AD environment, the
rest one running under NT Domains.
Well, I also want understand that maybe to have so many servers at the same
time...
"Tibor Karaszi" wrote:

> You need to refresh at the right level. Don't do the highest level. Refres
h doesn't work "all the
> way down". Do refresh on the right container.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:259BA9D3-01BE-4962-8F1F-86EB413D4C32@.microsoft.com...
>|||Enric wrote:
> Thanks to all for response.
> Tibor,
> Your fix not always works.
> David,
> All the SQL SERVERS (2000) own sp3 and sp3a for olap services.
> I think that it could be a network problem between domains or
> something like that. There are two sql server which are living in an
> AD environment, the rest one running under NT Domains.
>
Service Packs should be applied to the client as well as the server.
That's why I asked what version you have on the client. You can check
this from Query Analyzer on the client. You should be running 8.00.760
for SP3/SP3a.
It's possible the RTM release of SQL EM had refresh problems.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Hi
We have in excess of 95 servers in our EM at work, across multiple domains.
The SP is applied to both the servers and client workstations with EM
installed.
Right clicking as described by other posts in this thread works for us 100%
If you have networking problems between domains, you would get errors as the
objects are refreshed out of sysobjects in each database. It either works or
it gives you an error.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:CFD1B642-341C-4A97-8D0B-DFDBF16C15FF@.microsoft.com...
> Thanks to all for response.
> Tibor,
> Your fix not always works.
> David,
> All the SQL SERVERS (2000) own sp3 and sp3a for olap services.
> I think that it could be a network problem between domains or something
> like
> that. There are two sql server which are living in an AD environment, the
> rest one running under NT Domains.
> Well, I also want understand that maybe to have so many servers at the
> same
> time...
> "Tibor Karaszi" wrote:
>

Enterprise Manager - create table/column

I'm sorry, I've been searching for information that I need but I was in the
middle of the sea. Please point me to the right direction of where should I
post my question. Sorry.....
We are using SQL Server 2000. At design table view at SQL Server Enterprise
Manager, it has "Description", "Identity", "Identity Seed", "Formula" etc
fields at the bottom of the screen, and I would like to know what those are
for and their funtionalities.
Vanessa
Vanessa,
You might find it helpful to read the CREATE TABLE and CREATE VIEW articles
in the BOL, since the GUI is just creating these statements. Also, look up
"identity columns", "computed columns", and "extended properties".
RLF
"Vanessa" <Vanessa@.discussions.microsoft.com> wrote in message
news:073D607F-3087-47E4-ACE8-1BA0EA4ADD3B@.microsoft.com...
> I'm sorry, I've been searching for information that I need but I was in
> the
> middle of the sea. Please point me to the right direction of where should
> I
> post my question. Sorry.....
> We are using SQL Server 2000. At design table view at SQL Server
> Enterprise
> Manager, it has "Description", "Identity", "Identity Seed", "Formula" etc
> fields at the bottom of the screen, and I would like to know what those
> are
> for and their funtionalities.
> Vanessa
>

Enterprise Manage Diagram Error

I have sql 2000 developer edition runing on Xp professional. I down loaded
sp4 and installed it without error. I can open the create new diagram window,
select a table to add and when I press OK I get an error 'Invalid Class
String' and then nothing gets
saved.
Any constructinve help is appreciated.
Gary
I have EXACTLY the same problem.
If you find the solution please let me know.
Regards
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Have the same situation. Would appreciate any help. Thanks in advance,
Farid
"Gary" wrote:

> I have sql 2000 developer edition runing on Xp professional. I down loaded
> sp4 and installed it without error. I can open the create new diagram window,
> select a table to add and when I press OK I get an error 'Invalid Class
> String' and then nothing gets
> saved.
> Any constructinve help is appreciated.
>
> Gary
>

Entering Notes/Comments/Remarks to Report

Hi, there,

We intended to create a report that allows users to enter remarks, comments or additional notes in supporting the report.

Can it be done in SSRS? FYI, we are using SQL Server 2005 Enterprise.

Thank you.

Regards,

Yong Hwee

You want to annotate within the report, or you want to add extended properties to the report? If it is the first, then there is no way without changing the RDL or annotating the exported format. If it is the second, then you can use SetProperties/GetProperties to write/retrieve extended properties (including your annotations) programmatically.|||

Hi, John,

Thank you for your reply. Sorry for my ignorance. In fact, we are still thinking the way to cater this requirement. Currently, the report is in Excel workbook. Annotations are entered directly to the workbook. Users are producing this report every mth. If possible, we would like users to enter the annotations to the report and saved. It seems like the second method using SetProperties/GetProperties is the better choice but what are the possible ways of implemeting it?

We are looking for a intuitive solution that allows monthly reports to be saved and retrieved later. The results in the saved reports should not change irregardless of the underlying source. I think this is just like the 'report snapshot' in SSRS.

Thank you.

Regards,

Yong Hwee

|||You can use history snapshots for archiving previously generated reports, but we don't support setting/getting properties on individual snapshots, only the report item itself.|||

Hi, John,

Thank you for the reply.

Regards,

Yong Hwee

Entering Notes/Comments/Remarks to Report

Hi, there,

We intended to create a report that allows users to enter remarks, comments or additional notes in supporting the report.

Can it be done in SSRS? FYI, we are using SQL Server 2005 Enterprise.

Thank you.

Regards,

Yong Hwee

You want to annotate within the report, or you want to add extended properties to the report? If it is the first, then there is no way without changing the RDL or annotating the exported format. If it is the second, then you can use SetProperties/GetProperties to write/retrieve extended properties (including your annotations) programmatically.|||

Hi, John,

Thank you for your reply. Sorry for my ignorance. In fact, we are still thinking the way to cater this requirement. Currently, the report is in Excel workbook. Annotations are entered directly to the workbook. Users are producing this report every mth. If possible, we would like users to enter the annotations to the report and saved. It seems like the second method using SetProperties/GetProperties is the better choice but what are the possible ways of implemeting it?

We are looking for a intuitive solution that allows monthly reports to be saved and retrieved later. The results in the saved reports should not change irregardless of the underlying source. I think this is just like the 'report snapshot' in SSRS.

Thank you.

Regards,

Yong Hwee

|||You can use history snapshots for archiving previously generated reports, but we don't support setting/getting properties on individual snapshots, only the report item itself.|||

Hi, John,

Thank you for the reply.

Regards,

Yong Hwee

Entering Empty Node Using An Updategram

Hi there,
I was wondering if anyone has found how to add an empty (not NULL) node
to an update. I found if you create a node you can get it to enter an
empty space by setting the default value to ('') on the database so
that when you query the data you have an empty node returned. The
problem I'm having is when I want to "blank" a node so I have something
like:
<before>
<node>Some text</node>
</before>
<after>
<node/>
</after>
which will result in a NULL value. Is there something I can put in the
after node that will result in it producing the same as ('') or
something to that effect?
Thanks,
GaryGary,
I'm assuming you are using the XML datatype and want to perform this DML via
the .modify() method.
In that case, you can use the replace value of DML statement. The new value
you want is "empty" or (). Here is an example:
declare @.x xml
set @.x = '<foo>bar</foo>'
set @.x.modify('replace value of /foo[1]/text()[1] with ()')
select @.x
You will most likely need to modify this DML if you are using a typed xml
column.
Regards,
Galex Yen
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>|||you need to use xsi:nil. Here is the documentation and an example:
http://msdn2.microsoft.com/en-us/library/ms171764.aspx
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql"
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<updg:sync mapping-schema='StudentSchema.xml'>
<updg:before/>
<updg:after>
<Student SID="S00004" lname="Elmaci" minitial="" years="2">
<fname xsi:nil="true">
</fname>
</Student>
</updg:after>
</updg:sync>
</ROOT>
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>

Entering Empty Node Using An Updategram

Hi there,
I was wondering if anyone has found how to add an empty (not NULL) node
to an update. I found if you create a node you can get it to enter an
empty space by setting the default value to ('') on the database so
that when you query the data you have an empty node returned. The
problem I'm having is when I want to "blank" a node so I have something
like:
<before>
<node>Some text</node>
</before>
<after>
<node/>
</after>
which will result in a NULL value. Is there something I can put in the
after node that will result in it producing the same as ('') or
something to that effect?
Thanks,
Gary
Gary,
I'm assuming you are using the XML datatype and want to perform this DML via
the .modify() method.
In that case, you can use the replace value of DML statement. The new value
you want is "empty" or (). Here is an example:
declare @.x xml
set @.x = '<foo>bar</foo>'
set @.x.modify('replace value of /foo[1]/text()[1] with ()')
select @.x
You will most likely need to modify this DML if you are using a typed xml
column.
Regards,
Galex Yen
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>
|||you need to use xsi:nil. Here is the documentation and an example:
http://msdn2.microsoft.com/en-us/library/ms171764.aspx
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql"
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<updg:sync mapping-schema='StudentSchema.xml'>
<updg:before/>
<updg:after>
<Student SID="S00004" lname="Elmaci" minitial="" years="2">
<fname xsi:nil="true">
</fname>
</Student>
</updg:after>
</updg:sync>
</ROOT>
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>

Enter Parameter Value

Hey in Access MDB you can create a query that when you run it, it will ask you to Enter the Paramer Value, User could enter in a year or Team Member Number or however you have the query set up. is this possible in SQL ADP?No, not in SQL. Prompting the user for input is the responsibility of the interface, not the database engine. Access has an interface packaged with the engine. SQL Server is purely a database engine.

Your ASP page will need to check the stored procedure to determine which parameters are required and provide a means for the user to enter them.|||Thank you Blindman, wasnt sure|||How have you been??|||I actually think that an ADP (Access Data Project) can do interactive prompting, but I'm not sure how to make that happen. Since all of the ADP code actually runs on the client (either via the web page or within the project itself), I don't see any problem...

I'll have to experiment and see if I can finger out how to make this fly, but it won't be today.

-PatP|||Yeah I was hoping there would be a way of doing that, I'll have to do some investigating. It would make things a little easier for me though|||Even if you could find a way to automate this at the ASP layer, wouldn't it be limited to prompting for the often cryptic parameter names specified by the procedure developer?

Not very user friendly...|||I'm not sure what ADP projects to ASP. I think that Desiree is looking for a pure ADP configuration at least for now. I'll investigate both ADP and how it projects into ASP though.

-PatP|||ADP ASP ADP ASP ADP ASP ADP ASP...

Oh. aDp!

<Mild embarrasment./>|||I've never had that happen, but I read about it in this book once... ;)

-PatP|||When I open up a stored procedure in an Access Data Project it does prompt me for the parameter.