About a Free MSDE manager

Hello!!
Can you advice me some free MSDE tools (like database manager, query
interface...) that can be found over web?
Thanks in advance for your help!!
Ambros Moreno
From Almeria (Spain)
http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
"Ambros" <ambros@.sasao.com> wrote in message
news:Obexjnf1EHA.2804@.TK2MSFTNGP15.phx.gbl...
> Hello!!
> Can you advice me some free MSDE tools (like database manager, query
> interface...) that can be found over web?
> Thanks in advance for your help!!
> Ambros Moreno
> From Almeria (Spain)
>
|||Thanks for the link Aaron!! is really usefull.!!
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> escribi en el mensaje
news:eOwVYai1EHA.2156@.TK2MSFTNGP10.phx.gbl...
> http://www.aspfaq.com/2442
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Ambros" <ambros@.sasao.com> wrote in message
> news:Obexjnf1EHA.2804@.TK2MSFTNGP15.phx.gbl...
>

ability to use variables in package configurations and set their values at runtime

Hi,

My scenario:

I am using a FTP Connection Manager and the configuration setting for it is being set in the package configuration xml file. So the xml file contains the Ftpserver, FTp server username and password. The package is picking up the values from the xml file and is executing successfully. I have to do this because I was not able to provide an expression to the Connection Manager Server Password property.

Now, I want to pick up the ftp details from a database table and set it in the xml file during runtime. Is this possible? OR something like using the

<Configuration ConfiguredType="Property" Path="\Package.Connections[FTP Connection Manager].Properties[ServerPassword]" ValueType="Variable"><ConfiguredValue>@.[user::FtpPassword]</ConfiguredValue></Configuration>

Kindly look at the items in bold. Is this possible? Then I can set the value of the variable in the package before the FTP connection manager task is executed.

Thanks for all the help.

$wapnil

You could use a configuration storage as DB.

Or you can use Script task to query the DB and set the FTP connection properties or Variable values at runtime

Or even Execute SQL task to get the variable values from DB|||

Thanks

Reply to the options that you have provided

1) We want to use XML for the configuration. Just something which we want to follow if we could.

2) We are trying to minimuize the script tasks in the package by bringing the configuration details outside of the package and storing it in XML.

3) same as 1

Lets take a FTP connection Manager for example. The details of the FTP server are present in the database and I have also created variables for that but atleast I am not able to set the FTP Server password using a variable so I resorted to using the xml file and putting in the password there.

Now if I want to connect to multiple FTP server using the same package and the connection details are there in the database then I can pull out the connection details using an Execute SQL task but then how to update the xml files with values......knowing that the FTP server password can be only be set dynamically using the xml file.

Correct me if I am wrong. is storing the variable in the DB the only solution.

Thanks,

$wapnil

|||

spattewar wrote:

Now if I want to connect to multiple FTP server using the same package and the connection details

Are you trying to connect multiple FTP servers at the same time or are you trying to run the package in different environments?

For example if I would need to pull info from 3 different FTP servers - I would create 3 different configuration files:
1 for Development
1 for staging
and 1 for Production site|||

I am trying to connect to multiple FTP servers. But it can be at the same time or in sequence. But I am planning to use a single package for this task.

Thanks for your response.

$wapnil

|||Why don't you use Parent Package Configurations instead? A simple 2-package setup could work where:
Your mother package cycles through a list of FTP server configurations or whatever is needed.|||

That looks like a good idea.

But there is one concern. Even though I pass the configuration as a parent package variable to the child package, will I be able to set the FTP ServerPassword property of the FTP connection manager using a variable. I doubt I can do that, then it boils down to the same thing picking up the package configuration from the xml file or a database, here we would prefer xml file.

Maybe we can do this by.

1) Running the master package which will have a script task to update a xml configuration file.

2) Pass that xml file as a configuration parameter to the child package and execute the child package.

Thanks for your response.

$wapnil

|||I don't have any reason to believe that you can't pass the password or even the whole connectionstring as a variable.

However do note that if your variable values refuse to change (although I don't see any reason why they won't) you might have to tweak the ProtectionLevel of the package to DontSaveSensitive or some other value that allows you to modify your connectionstring variable.

HTHsql

a table/column to table/column data check (was "Help Please, SQL something Simpl

Hi all, I am not over familiar with SQL, I am a VB programmer, simply I need to achieve the following within Enterprise Manager.

I have 2 tables, different designs, different number of rows, I simply need to check whether the contents of a column in the first table is in a column in the second table, just simply a table/column to table/column data check for the same data content.

Easy Peasy for you guys, any help would be appreciated.Hi all, I am not over familiar with SQL, I am a VB programmer, simply I need to achieve the following within Enterprise Manager.

I have 2 tables, different designs, different number of rows, I simply need to check whether the contents of a column in the first table is in a column in the second table, just simply a table/column to table/column data check for the same data content.

Easy Peasy for you guys, any help would be appreciated.

Welcome to the forum,ok here is your solution

CREATE TABLE t1(
col1 VARCHAR(20)
,col2 VARCHAR(20)
,col3 VARCHAR(20)
)

CREATE TABLE t2(
col4 VARCHAR(20)
,col5 VARCHAR(20)
)

The sql statement to check content of a col1 is in col4 or not...

SELECT * FROM
t1,t2
WHERE t1.col1=t2.col4|||Many thanks, will give it a try a wee bit later and post result.

Many thanks...|||Hi, this appears to work fine, however if I change the logic to check what is not in table2 it appears to go into a endless loop, any help appreciated.|||Hi, sorry after further testing, I may not have explained myself very well, apologies, I need to access row1 of table1 and then scan column2 in table2, the entire table, for the occurence of the data item in row1 table1.

Many thanks in anticipation.|||Hi, this appears to work fine, however if I change the logic to check what is not in table2 it appears to go into a endless loop, any help appreciated.
Test it ...

insert into t1 values('joy','datta','harry')
insert into t1 values('Pink','datta56','harry2')
insert into t1 values('Sheep','datta5','harry3')
insert into t1 values('Ghree','datta11','harry5')

insert into t2 values('Sheep','datta5')
insert into t2 values('Ghree','datta11')

SELECT * FROM
t1
WHERE t1.col1 NOT IN(SELECT t2.col5 FROM t2)|||Thanks sorted..

A request to establish a connection with transaction manager denie

A user has reported the message "A request to establish a connection with the
transaction manager was denied". The code is at this point attempting to
START a transaction. So far I have been unable to duplicate this, though the
user has been able to get through this code in the past. Of course, no known
changes.
What causes this particular message?
--
Brad AshforthHi Brad
This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
you already have the maximum number of connections.
John
"Brad Ashforth" wrote:
> A user has reported the message "A request to establish a connection with the
> transaction manager was denied". The code is at this point attempting to
> START a transaction. So far I have been unable to duplicate this, though the
> user has been able to get through this code in the past. Of course, no known
> changes.
> What causes this particular message?
> --
> Brad Ashforth|||Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
level? Our application is designed such that we do not make use of nested
transactions. We have a "transaction" routine that is called with either
"Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
(as it was in this case), we first execute a commit (in case a transaction is
pending that was not committed or rolled back) and then do the BEGIN. Of
course, if when we issue the commit if there is no pending transaction, we
get an error ... but that is trapped for and ignored if we are trying to
begin a new transaction.
So, that said ... there should only be one transaction active for the
application at any given time and if by chance we try to start another one
the code automatically commits the first one before starting the 2nd one.
Is there a way to query how many connections there are?
--
Brad Ashforth
"John Bell" wrote:
> Hi Brad
> This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> you already have the maximum number of connections.
> John
> "Brad Ashforth" wrote:
> > A user has reported the message "A request to establish a connection with the
> > transaction manager was denied". The code is at this point attempting to
> > START a transaction. So far I have been unable to duplicate this, though the
> > user has been able to get through this code in the past. Of course, no known
> > changes.
> >
> > What causes this particular message?
> > --
> > Brad Ashforth|||Hi Brad,
Thank you for your posting!
I would like to know some detailed information:
1. Does your customer use Distribute Transaction? If so, does the DTC
services start?
2. Are there any error log in event log? If so, please post it here.
3. What's the SQL Server Version and the Server OS version?
Please let me know the result and so that I can provide further assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei ... thank you.
1). No, the customer does not use Distributed Transactions (at least not to
their knowledge)
2) No errors in any of the event logs on the SQL Server box
3) From SQL Query Analyzer @.@.Version returns 8.00.760, from a cmd shell VER
returns 5.2.3790 (Windows Server 2003 Enterprise Edition)
Please note that this error occurred in an acceptance testing phase, not in
production.
--
Brad Ashforth
"Wei Lu [MSFT]" wrote:
> Hi Brad,
> Thank you for your posting!
> I would like to know some detailed information:
> 1. Does your customer use Distribute Transaction? If so, does the DTC
> services start?
> 2. Are there any error log in event log? If so, please post it here.
> 3. What's the SQL Server Version and the Server OS version?
> Please let me know the result and so that I can provide further assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Brad
Checking @.@.TRANCOUNT will tell you whether a transaction is in progress.
Using a commit that when a transaction has not begun will cause an error:
Server: Msg 3902, Level 16, State 1, Line 1
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
Which you can easily avoid.
I don't think this is the cause of the issue! Do you reference any other
databases either in your stored procedures or triggers? Are you using
multipart naming conventions? Are you enquoting your names using square
braces []?
John
"Brad Ashforth" wrote:
> Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
> level? Our application is designed such that we do not make use of nested
> transactions. We have a "transaction" routine that is called with either
> "Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
> (as it was in this case), we first execute a commit (in case a transaction is
> pending that was not committed or rolled back) and then do the BEGIN. Of
> course, if when we issue the commit if there is no pending transaction, we
> get an error ... but that is trapped for and ignored if we are trying to
> begin a new transaction.
> So, that said ... there should only be one transaction active for the
> application at any given time and if by chance we try to start another one
> the code automatically commits the first one before starting the 2nd one.
> Is there a way to query how many connections there are?
> --
> Brad Ashforth
>
> "John Bell" wrote:
> > Hi Brad
> >
> > This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> > you already have the maximum number of connections.
> >
> > John
> >
> > "Brad Ashforth" wrote:
> >
> > > A user has reported the message "A request to establish a connection with the
> > > transaction manager was denied". The code is at this point attempting to
> > > START a transaction. So far I have been unable to duplicate this, though the
> > > user has been able to get through this code in the past. Of course, no known
> > > changes.
> > >
> > > What causes this particular message?
> > > --
> > > Brad Ashforth|||Hi John. Thank you.
We had not known about @.@.TRANCOUNT and agree that it makes more sense to
check this instead of trapping for a known error that is likely to occur (on
the other hand, isn't that what TRY/CATCH is supposed to do?) Anyway, I also
agree that this is not the likely cause of the error I originally posted a
question about.
We do not reference other databases, and in most (99%?) cases do not use
fully qualified table names. This is because most tables are in the DBO
schema and do not get to the user's own schema ... each user temp table (for
reports, etc) are in their own schema. In most cases the object names follow
standard conventions and should not need braces. This is also not an error
that is easily repeatable. It has been seen before but have had trouble
duplicating it.
Thanks,
Brad
--
Brad Ashforth
"John Bell" wrote:
> Hi Brad
> Checking @.@.TRANCOUNT will tell you whether a transaction is in progress.
> Using a commit that when a transaction has not begun will cause an error:
> Server: Msg 3902, Level 16, State 1, Line 1
> The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
> Which you can easily avoid.
> I don't think this is the cause of the issue! Do you reference any other
> databases either in your stored procedures or triggers? Are you using
> multipart naming conventions? Are you enquoting your names using square
> braces []?
>
> John
> "Brad Ashforth" wrote:
> > Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
> > level? Our application is designed such that we do not make use of nested
> > transactions. We have a "transaction" routine that is called with either
> > "Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
> > (as it was in this case), we first execute a commit (in case a transaction is
> > pending that was not committed or rolled back) and then do the BEGIN. Of
> > course, if when we issue the commit if there is no pending transaction, we
> > get an error ... but that is trapped for and ignored if we are trying to
> > begin a new transaction.
> >
> > So, that said ... there should only be one transaction active for the
> > application at any given time and if by chance we try to start another one
> > the code automatically commits the first one before starting the 2nd one.
> >
> > Is there a way to query how many connections there are?
> > --
> > Brad Ashforth
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Brad
> > >
> > > This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> > > you already have the maximum number of connections.
> > >
> > > John
> > >
> > > "Brad Ashforth" wrote:
> > >
> > > > A user has reported the message "A request to establish a connection with the
> > > > transaction manager was denied". The code is at this point attempting to
> > > > START a transaction. So far I have been unable to duplicate this, though the
> > > > user has been able to get through this code in the past. Of course, no known
> > > > changes.
> > > >
> > > > What causes this particular message?
> > > > --
> > > > Brad Ashforth|||Hi Brad
Prefixing with the schema name should improve performance and caching.
If this problem is periodic you are not going to know for certain that you
have cured it!! How often does it occur? Does it mainly occur after a re-boot
or a high load levels? I know you have checked the Event logs what about the
SQL Server log?
If MSDTC is currently running try switching it off, as this should not
effect your application if it is not being used!!
John
"Brad Ashforth" wrote:
> Hi John. Thank you.
> We had not known about @.@.TRANCOUNT and agree that it makes more sense to
> check this instead of trapping for a known error that is likely to occur (on
> the other hand, isn't that what TRY/CATCH is supposed to do?) Anyway, I also
> agree that this is not the likely cause of the error I originally posted a
> question about.
> We do not reference other databases, and in most (99%?) cases do not use
> fully qualified table names. This is because most tables are in the DBO
> schema and do not get to the user's own schema ... each user temp table (for
> reports, etc) are in their own schema. In most cases the object names follow
> standard conventions and should not need braces. This is also not an error
> that is easily repeatable. It has been seen before but have had trouble
> duplicating it.
> Thanks,
> Brad
> --
> Brad Ashforth
>
> "John Bell" wrote:
> > Hi Brad
> >
> > Checking @.@.TRANCOUNT will tell you whether a transaction is in progress.
> > Using a commit that when a transaction has not begun will cause an error:
> >
> > Server: Msg 3902, Level 16, State 1, Line 1
> > The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
> >
> > Which you can easily avoid.
> >
> > I don't think this is the cause of the issue! Do you reference any other
> > databases either in your stored procedures or triggers? Are you using
> > multipart naming conventions? Are you enquoting your names using square
> > braces []?
> >
> >
> > John
> >
> > "Brad Ashforth" wrote:
> >
> > > Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
> > > level? Our application is designed such that we do not make use of nested
> > > transactions. We have a "transaction" routine that is called with either
> > > "Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
> > > (as it was in this case), we first execute a commit (in case a transaction is
> > > pending that was not committed or rolled back) and then do the BEGIN. Of
> > > course, if when we issue the commit if there is no pending transaction, we
> > > get an error ... but that is trapped for and ignored if we are trying to
> > > begin a new transaction.
> > >
> > > So, that said ... there should only be one transaction active for the
> > > application at any given time and if by chance we try to start another one
> > > the code automatically commits the first one before starting the 2nd one.
> > >
> > > Is there a way to query how many connections there are?
> > > --
> > > Brad Ashforth
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Brad
> > > >
> > > > This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> > > > you already have the maximum number of connections.
> > > >
> > > > John
> > > >
> > > > "Brad Ashforth" wrote:
> > > >
> > > > > A user has reported the message "A request to establish a connection with the
> > > > > transaction manager was denied". The code is at this point attempting to
> > > > > START a transaction. So far I have been unable to duplicate this, though the
> > > > > user has been able to get through this code in the past. Of course, no known
> > > > > changes.
> > > > >
> > > > > What causes this particular message?
> > > > > --
> > > > > Brad Ashforth|||Hi John .. Thank you.
As the application is used in multiple environments, we have no control or
knowledge of the deployment and don't code the fully qualified object name,
currently it would take a LOT of rework to do this. Is the performance
improvement enough to make it worthwhile?
Yes, periodic failures are a pain to diagnose. The problem occurs RARELY (I
think it has only happened once or twice in a deployment. Not all deployments
have seen the problem and the total number of occurrences is certainly less
than 6 or 7. Rebooting does not seem to be the issue, nor does load level (no
reboots either before or after the error). I currently do not have access to
the SQL Server log. Will try to obtain it.
MSDTC is not used by our application, but if a deployment decides to house
multiple databases on the SQLServer, wouldn't it be better to leave it on?
--
Brad Ashforth
"John Bell" wrote:
> Hi Brad
> Prefixing with the schema name should improve performance and caching.
> If this problem is periodic you are not going to know for certain that you
> have cured it!! How often does it occur? Does it mainly occur after a re-boot
> or a high load levels? I know you have checked the Event logs what about the
> SQL Server log?
> If MSDTC is currently running try switching it off, as this should not
> effect your application if it is not being used!!
> John
>
>
> "Brad Ashforth" wrote:
> > Hi John. Thank you.
> >
> > We had not known about @.@.TRANCOUNT and agree that it makes more sense to
> > check this instead of trapping for a known error that is likely to occur (on
> > the other hand, isn't that what TRY/CATCH is supposed to do?) Anyway, I also
> > agree that this is not the likely cause of the error I originally posted a
> > question about.
> >
> > We do not reference other databases, and in most (99%?) cases do not use
> > fully qualified table names. This is because most tables are in the DBO
> > schema and do not get to the user's own schema ... each user temp table (for
> > reports, etc) are in their own schema. In most cases the object names follow
> > standard conventions and should not need braces. This is also not an error
> > that is easily repeatable. It has been seen before but have had trouble
> > duplicating it.
> >
> > Thanks,
> > Brad
> > --
> > Brad Ashforth
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Brad
> > >
> > > Checking @.@.TRANCOUNT will tell you whether a transaction is in progress.
> > > Using a commit that when a transaction has not begun will cause an error:
> > >
> > > Server: Msg 3902, Level 16, State 1, Line 1
> > > The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
> > >
> > > Which you can easily avoid.
> > >
> > > I don't think this is the cause of the issue! Do you reference any other
> > > databases either in your stored procedures or triggers? Are you using
> > > multipart naming conventions? Are you enquoting your names using square
> > > braces []?
> > >
> > >
> > > John
> > >
> > > "Brad Ashforth" wrote:
> > >
> > > > Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
> > > > level? Our application is designed such that we do not make use of nested
> > > > transactions. We have a "transaction" routine that is called with either
> > > > "Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
> > > > (as it was in this case), we first execute a commit (in case a transaction is
> > > > pending that was not committed or rolled back) and then do the BEGIN. Of
> > > > course, if when we issue the commit if there is no pending transaction, we
> > > > get an error ... but that is trapped for and ignored if we are trying to
> > > > begin a new transaction.
> > > >
> > > > So, that said ... there should only be one transaction active for the
> > > > application at any given time and if by chance we try to start another one
> > > > the code automatically commits the first one before starting the 2nd one.
> > > >
> > > > Is there a way to query how many connections there are?
> > > > --
> > > > Brad Ashforth
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi Brad
> > > > >
> > > > > This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> > > > > you already have the maximum number of connections.
> > > > >
> > > > > John
> > > > >
> > > > > "Brad Ashforth" wrote:
> > > > >
> > > > > > A user has reported the message "A request to establish a connection with the
> > > > > > transaction manager was denied". The code is at this point attempting to
> > > > > > START a transaction. So far I have been unable to duplicate this, though the
> > > > > > user has been able to get through this code in the past. Of course, no known
> > > > > > changes.
> > > > > >
> > > > > > What causes this particular message?
> > > > > > --
> > > > > > Brad Ashforth|||Hi Brad
Using the schema name should not effect the deployments as this should be
constant, two part naming will help to varying degrees, depending on what
specification the server has and the load it takes. In general it is good
practice to do this and is usually easier to implement though of coding
standards and QA than retrospectively.
If you share the server with other applications you would need to make sure
that they don't use MSDTC, but any service on the server that is not being
used should be stopped as they will take up resources. If you stop this
service then it may make it easier to highlight something wrong with your own
application.
John
"Brad Ashforth" wrote:
> Hi John .. Thank you.
> As the application is used in multiple environments, we have no control or
> knowledge of the deployment and don't code the fully qualified object name,
> currently it would take a LOT of rework to do this. Is the performance
> improvement enough to make it worthwhile?
> Yes, periodic failures are a pain to diagnose. The problem occurs RARELY (I
> think it has only happened once or twice in a deployment. Not all deployments
> have seen the problem and the total number of occurrences is certainly less
> than 6 or 7. Rebooting does not seem to be the issue, nor does load level (no
> reboots either before or after the error). I currently do not have access to
> the SQL Server log. Will try to obtain it.
> MSDTC is not used by our application, but if a deployment decides to house
> multiple databases on the SQLServer, wouldn't it be better to leave it on?
> --
> Brad Ashforth
>
> "John Bell" wrote:
> > Hi Brad
> >
> > Prefixing with the schema name should improve performance and caching.
> >
> > If this problem is periodic you are not going to know for certain that you
> > have cured it!! How often does it occur? Does it mainly occur after a re-boot
> > or a high load levels? I know you have checked the Event logs what about the
> > SQL Server log?
> >
> > If MSDTC is currently running try switching it off, as this should not
> > effect your application if it is not being used!!
> >
> > John
> >
> >
> >
> >
> >
> > "Brad Ashforth" wrote:
> >
> > > Hi John. Thank you.
> > >
> > > We had not known about @.@.TRANCOUNT and agree that it makes more sense to
> > > check this instead of trapping for a known error that is likely to occur (on
> > > the other hand, isn't that what TRY/CATCH is supposed to do?) Anyway, I also
> > > agree that this is not the likely cause of the error I originally posted a
> > > question about.
> > >
> > > We do not reference other databases, and in most (99%?) cases do not use
> > > fully qualified table names. This is because most tables are in the DBO
> > > schema and do not get to the user's own schema ... each user temp table (for
> > > reports, etc) are in their own schema. In most cases the object names follow
> > > standard conventions and should not need braces. This is also not an error
> > > that is easily repeatable. It has been seen before but have had trouble
> > > duplicating it.
> > >
> > > Thanks,
> > > Brad
> > > --
> > > Brad Ashforth
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Brad
> > > >
> > > > Checking @.@.TRANCOUNT will tell you whether a transaction is in progress.
> > > > Using a commit that when a transaction has not begun will cause an error:
> > > >
> > > > Server: Msg 3902, Level 16, State 1, Line 1
> > > > The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
> > > >
> > > > Which you can easily avoid.
> > > >
> > > > I don't think this is the cause of the issue! Do you reference any other
> > > > databases either in your stored procedures or triggers? Are you using
> > > > multipart naming conventions? Are you enquoting your names using square
> > > > braces []?
> > > >
> > > >
> > > > John
> > > >
> > > > "Brad Ashforth" wrote:
> > > >
> > > > > Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
> > > > > level? Our application is designed such that we do not make use of nested
> > > > > transactions. We have a "transaction" routine that is called with either
> > > > > "Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
> > > > > (as it was in this case), we first execute a commit (in case a transaction is
> > > > > pending that was not committed or rolled back) and then do the BEGIN. Of
> > > > > course, if when we issue the commit if there is no pending transaction, we
> > > > > get an error ... but that is trapped for and ignored if we are trying to
> > > > > begin a new transaction.
> > > > >
> > > > > So, that said ... there should only be one transaction active for the
> > > > > application at any given time and if by chance we try to start another one
> > > > > the code automatically commits the first one before starting the 2nd one.
> > > > >
> > > > > Is there a way to query how many connections there are?
> > > > > --
> > > > > Brad Ashforth
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi Brad
> > > > > >
> > > > > > This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> > > > > > you already have the maximum number of connections.
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "Brad Ashforth" wrote:
> > > > > >
> > > > > > > A user has reported the message "A request to establish a connection with the
> > > > > > > transaction manager was denied". The code is at this point attempting to
> > > > > > > START a transaction. So far I have been unable to duplicate this, though the
> > > > > > > user has been able to get through this code in the past. Of course, no known
> > > > > > > changes.
> > > > > > >
> > > > > > > What causes this particular message?
> > > > > > > --
> > > > > > > Brad Ashforth|||Hi John, Thank you ... I found that the test server does NOT host other
databases that require MSDTC but the server DID have the service as auto
start. I've set it to manual and stopped the service. We'll keep checking to
see if it happens again.
Thank you,
Brad Ashforth
"John Bell" wrote:
> Hi Brad
> Using the schema name should not effect the deployments as this should be
> constant, two part naming will help to varying degrees, depending on what
> specification the server has and the load it takes. In general it is good
> practice to do this and is usually easier to implement though of coding
> standards and QA than retrospectively.
> If you share the server with other applications you would need to make sure
> that they don't use MSDTC, but any service on the server that is not being
> used should be stopped as they will take up resources. If you stop this
> service then it may make it easier to highlight something wrong with your own
> application.
> John
>
> "Brad Ashforth" wrote:
> > Hi John .. Thank you.
> >
> > As the application is used in multiple environments, we have no control or
> > knowledge of the deployment and don't code the fully qualified object name,
> > currently it would take a LOT of rework to do this. Is the performance
> > improvement enough to make it worthwhile?
> >
> > Yes, periodic failures are a pain to diagnose. The problem occurs RARELY (I
> > think it has only happened once or twice in a deployment. Not all deployments
> > have seen the problem and the total number of occurrences is certainly less
> > than 6 or 7. Rebooting does not seem to be the issue, nor does load level (no
> > reboots either before or after the error). I currently do not have access to
> > the SQL Server log. Will try to obtain it.
> >
> > MSDTC is not used by our application, but if a deployment decides to house
> > multiple databases on the SQLServer, wouldn't it be better to leave it on?
> >
> > --
> > Brad Ashforth
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Brad
> > >
> > > Prefixing with the schema name should improve performance and caching.
> > >
> > > If this problem is periodic you are not going to know for certain that you
> > > have cured it!! How often does it occur? Does it mainly occur after a re-boot
> > > or a high load levels? I know you have checked the Event logs what about the
> > > SQL Server log?
> > >
> > > If MSDTC is currently running try switching it off, as this should not
> > > effect your application if it is not being used!!
> > >
> > > John
> > >
> > >
> > >
> > >
> > >
> > > "Brad Ashforth" wrote:
> > >
> > > > Hi John. Thank you.
> > > >
> > > > We had not known about @.@.TRANCOUNT and agree that it makes more sense to
> > > > check this instead of trapping for a known error that is likely to occur (on
> > > > the other hand, isn't that what TRY/CATCH is supposed to do?) Anyway, I also
> > > > agree that this is not the likely cause of the error I originally posted a
> > > > question about.
> > > >
> > > > We do not reference other databases, and in most (99%?) cases do not use
> > > > fully qualified table names. This is because most tables are in the DBO
> > > > schema and do not get to the user's own schema ... each user temp table (for
> > > > reports, etc) are in their own schema. In most cases the object names follow
> > > > standard conventions and should not need braces. This is also not an error
> > > > that is easily repeatable. It has been seen before but have had trouble
> > > > duplicating it.
> > > >
> > > > Thanks,
> > > > Brad
> > > > --
> > > > Brad Ashforth
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi Brad
> > > > >
> > > > > Checking @.@.TRANCOUNT will tell you whether a transaction is in progress.
> > > > > Using a commit that when a transaction has not begun will cause an error:
> > > > >
> > > > > Server: Msg 3902, Level 16, State 1, Line 1
> > > > > The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
> > > > >
> > > > > Which you can easily avoid.
> > > > >
> > > > > I don't think this is the cause of the issue! Do you reference any other
> > > > > databases either in your stored procedures or triggers? Are you using
> > > > > multipart naming conventions? Are you enquoting your names using square
> > > > > braces []?
> > > > >
> > > > >
> > > > > John
> > > > >
> > > > > "Brad Ashforth" wrote:
> > > > >
> > > > > > Hi John ... by "maximum # of connections", is this at the SERVER or CLIENT
> > > > > > level? Our application is designed such that we do not make use of nested
> > > > > > transactions. We have a "transaction" routine that is called with either
> > > > > > "Begin", "Commit" or "Rollback", and if the routine is called with "Begin"
> > > > > > (as it was in this case), we first execute a commit (in case a transaction is
> > > > > > pending that was not committed or rolled back) and then do the BEGIN. Of
> > > > > > course, if when we issue the commit if there is no pending transaction, we
> > > > > > get an error ... but that is trapped for and ignored if we are trying to
> > > > > > begin a new transaction.
> > > > > >
> > > > > > So, that said ... there should only be one transaction active for the
> > > > > > application at any given time and if by chance we try to start another one
> > > > > > the code automatically commits the first one before starting the 2nd one.
> > > > > >
> > > > > > Is there a way to query how many connections there are?
> > > > > > --
> > > > > > Brad Ashforth
> > > > > >
> > > > > >
> > > > > > "John Bell" wrote:
> > > > > >
> > > > > > > Hi Brad
> > > > > > >
> > > > > > > This looks like a XACT_E_CONNECTION_DENIED error, which might be thrown if
> > > > > > > you already have the maximum number of connections.
> > > > > > >
> > > > > > > John
> > > > > > >
> > > > > > > "Brad Ashforth" wrote:
> > > > > > >
> > > > > > > > A user has reported the message "A request to establish a connection with the
> > > > > > > > transaction manager was denied". The code is at this point attempting to
> > > > > > > > START a transaction. So far I have been unable to duplicate this, though the
> > > > > > > > user has been able to get through this code in the past. Of course, no known
> > > > > > > > changes.
> > > > > > > >
> > > > > > > > What causes this particular message?
> > > > > > > > --
> > > > > > > > Brad Ashforth

A red X appears over the 'replicator monitor'

Using the 'SQL Server Enterprise Manager' before selecting 'push new
subsription' a red X appears over the 'replicator monitor'. I noted the red
cross appears over the folder 'merge agents'. If I look at the 'error
details of the merge agent' it says 'The process could not drop one or more
tables because the tables are being used by other publications.'. The thing
is, I'm not dropping any table, just trying to replicate a table between 3
databases. Why does this error happen?
Thnx for your time
Martin
Martin,
have a look at the tables on the subscriber. It is possible that you are
publishing an article to a subscriber that is itself publishing the article.
By default, replication will try to drop the tabl;e on the subscriber but
will be prevented from doing so. If the error message doesn't mention the
tablename, have a look at: http://support.microsoft.com/?id=312292
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||If Paul's suggestion does not help, it could be that the tables on the
subsciber are inadvertly makrked as replicated. IF the subscribing database
had at one time set up for replication or if the database has been restored
from another server where the database was published, this can happen.
If this is the case then you can use the steps in the following article to
resolve the problem:
PRB: You receive error 3724 when you drop a non-replicated object
http://support.microsoft.com/default.aspx?scid=KB;[LN];326352
Rand
This posting is provided "as is" with no warranties and confers no rights.

a quick question about subscription

when I create a subscription through report manager it work ,but if I create
the subscription through my application (I'm using my own domain credentials
to authenticate to the server).It dosen't work.
Any idea?
ThanksHow does it fail? Does the create fail or the subscription fail when it
runs?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-R" <RayAll@.microsft.com> wrote in message
news:uLFwfi1VFHA.2128@.TK2MSFTNGP15.phx.gbl...
> when I create a subscription through report manager it work ,but if I
> create the subscription through my application (I'm using my own domain
> credentials to authenticate to the server).It dosen't work.
> Any idea?
> Thanks
>|||No it create the subscription,but it necer run the subscrition.My ASP.NET
application is in different box than Reporting Services and they both using
NTLM.
Thanks
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:uAt65%232VFHA.1452@.TK2MSFTNGP14.phx.gbl...
> How does it fail? Does the create fail or the subscription fail when it
> runs?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "J-R" <RayAll@.microsft.com> wrote in message
> news:uLFwfi1VFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> when I create a subscription through report manager it work ,but if I
>> create the subscription through my application (I'm using my own domain
>> credentials to authenticate to the server).It dosen't work.
>> Any idea?
>> Thanks
>|||Is there any status shown after the subscription fires? After you create
the subscription through your app, can you view it through Report Manager?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"J-R" <RayAll@.microsft.com> wrote in message
news:OtgYYP9VFHA.2960@.TK2MSFTNGP15.phx.gbl...
> No it create the subscription,but it necer run the subscrition.My ASP.NET
> application is in different box than Reporting Services and they both
> using NTLM.
> Thanks
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:uAt65%232VFHA.1452@.TK2MSFTNGP14.phx.gbl...
>> How does it fail? Does the create fail or the subscription fail when it
>> runs?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "J-R" <RayAll@.microsft.com> wrote in message
>> news:uLFwfi1VFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> when I create a subscription through report manager it work ,but if I
>> create the subscription through my application (I'm using my own domain
>> credentials to authenticate to the server).It dosen't work.
>> Any idea?
>> Thanks
>>
>|||I think I solved the problem,it was the problem of the user account we
create the suscription uder.That guy did not have enough previlliage to
execute a subscription.
Thanks for your help
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:%230vs3rDWFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Is there any status shown after the subscription fires? After you create
> the subscription through your app, can you view it through Report Manager?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "J-R" <RayAll@.microsft.com> wrote in message
> news:OtgYYP9VFHA.2960@.TK2MSFTNGP15.phx.gbl...
>> No it create the subscription,but it necer run the subscrition.My ASP.NET
>> application is in different box than Reporting Services and they both
>> using NTLM.
>> Thanks
>> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
>> news:uAt65%232VFHA.1452@.TK2MSFTNGP14.phx.gbl...
>> How does it fail? Does the create fail or the subscription fail when it
>> runs?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "J-R" <RayAll@.microsft.com> wrote in message
>> news:uLFwfi1VFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> when I create a subscription through report manager it work ,but if I
>> create the subscription through my application (I'm using my own domain
>> credentials to authenticate to the server).It dosen't work.
>> Any idea?
>> Thanks
>>
>>
>

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
etc).
> server,
that
> i
webpages
use
>|||http://www.microsoft.com/sql/techin...eskChooseEd.asp
http://www.microsoft.com/sql/msde/
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>|||If you still have questions about licensing, there are some useful links
here:
317428 INF: Where to Find Information About SQL Server Licensing
http://support.microsoft.com/?id=317428
Keep in mind that you can buy a developer edition of SQL Server for $49 to
develop your application. If the SQL Server edition you already have is
either Standard or Enterprise you could move that edition to your web
server and use the developer edition on your client. But you cannot use the
developer edition on your website.
MSDE might be legal for your web server if you have the appropriate
redistribution rights. MSDE also has some limitations on size and number of
concurrently executing queries. Check out the MSDE roadmap on MSDN as well
as the links from the KB above.
http://msdn.microsoft.com/library/d...-us/dnmsde/html
/msderoadmap.asp
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > hello,
> >
> > i have sql server 2000 on my local machine (with enterprise manager
etc).
> >
> > i want to host a website (on a dedicated server) which talks to sql
> server,
> > but i dont want to buy another license for the server machine that i am
> > going to host on (too much money!).
> >
> > my question is:
> > is there a way around this? ie: is there a free engine or something
that
> i
> > can install on my webserver which just stores the datafiles so my
webpages
> > will work.
> >
> > ideally i would like to DTS data to and from the live server, and also
use
> > my local enterprise manager to view/update data on the live server?
> >
> > is this possible?
> >
> > thanks
> >
> >
>|||http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
http://www.microsoft.com/sql/msde/
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
etc).
> server,
that
> i
webpages
use
>|||http://www.microsoft.com/sql/techin...eskChooseEd.asp
http://www.microsoft.com/sql/msde/
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>

A point in time backup with SQL Server 2000 Enterprise Manager

I'm having a problem testing a point in time backup. Here
is what I was trying:
1) I created a complete database backup to a file
D:\TEMP.DAT (of a database named
PHCS) (Time - 10:45)
2) I went and made some changes to the PHCS database at
10:49:10
3) I went and made some more changes to the PHCS database
at 10:50:50
4) I backed up the transaction log database (also into
D:\TEMP.DAT, appending).
(Time - 10:52)
5) I went to restore the database backed up at 10:45 and
left it unoperational
6) I went to restore the transaction log created at 10:52
and tried to specify a time
of 10:50:00. I wanted to restore the changes made in step
2, but not step 3.
He restore me the hole last transaction log i selected
an don't stop between step 2 and 3 !!
Many thanks for your help
DanielDid you use STOPAT..?
Here's the example from SQL BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
HTH
Ryan Waight, MCDBA, MCSE
"Ischi" <daniel_ischi@.hotmail.com> wrote in message
news:0def01c38d87$06a78890$a101280a@.phx.gbl...
> I'm having a problem testing a point in time backup. Here
> is what I was trying:
> 1) I created a complete database backup to a file
> D:\TEMP.DAT (of a database named
> PHCS) (Time - 10:45)
> 2) I went and made some changes to the PHCS database at
> 10:49:10
> 3) I went and made some more changes to the PHCS database
> at 10:50:50
> 4) I backed up the transaction log database (also into
> D:\TEMP.DAT, appending).
> (Time - 10:52)
> 5) I went to restore the database backed up at 10:45 and
> left it unoperational
> 6) I went to restore the transaction log created at 10:52
> and tried to specify a time
> of 10:50:00. I wanted to restore the changes made in step
> 2, but not step 3.
> He restore me the hole last transaction log i selected
> an don't stop between step 2 and 3 !!
> Many thanks for your help
> Daniel
>|||Hello
No i use the SQL Enterprise Manager not the Query
Analycer. I know the statement in Qury Analycer.
Thaks and best regards.
Daniel
>--Original Message--
>Did you use STOPAT..?
>Here's the example from SQL BOL
>-- Restore the database backup.
>RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
>GO
>RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
>GO
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Ischi" <daniel_ischi@.hotmail.com> wrote in message
>news:0def01c38d87$06a78890$a101280a@.phx.gbl...
>> I'm having a problem testing a point in time backup.
Here
>> is what I was trying:
>> 1) I created a complete database backup to a file
>> D:\TEMP.DAT (of a database named
>> PHCS) (Time - 10:45)
>> 2) I went and made some changes to the PHCS database at
>> 10:49:10
>> 3) I went and made some more changes to the PHCS
database
>> at 10:50:50
>> 4) I backed up the transaction log database (also into
>> D:\TEMP.DAT, appending).
>> (Time - 10:52)
>> 5) I went to restore the database backed up at 10:45
and
>> left it unoperational
>> 6) I went to restore the transaction log created at
10:52
>> and tried to specify a time
>> of 10:50:00. I wanted to restore the changes made in
step
>> 2, but not step 3.
>> He restore me the hole last transaction log i selected
>> an don't stop between step 2 and 3 !!
>> Many thanks for your help
>> Daniel
>
>.
>|||To do it within Enterprise Manager :-
Right Click DB
All Tasks
Restore DataBase
Tick the Box "Point in Time Restore"
Specify the time you wish to stop at.
--
HTH
Ryan Waight, MCDBA, MCSE
"Ischi" <daniel_ischi@.hotmail.com> wrote in message
news:0cde01c38d90$dcd9bc90$a301280a@.phx.gbl...
> Hello
> No i use the SQL Enterprise Manager not the Query
> Analycer. I know the statement in Qury Analycer.
> Thaks and best regards.
> Daniel
> >--Original Message--
> >Did you use STOPAT..?
> >
> >Here's the example from SQL BOL
> >
> >-- Restore the database backup.
> >RESTORE DATABASE MyNwind
> > FROM MyNwind_1, MyNwind_2
> > WITH NORECOVERY
> >GO
> >RESTORE LOG MyNwind
> > FROM MyNwind_log1
> > WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> >GO
> >
> >
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"Ischi" <daniel_ischi@.hotmail.com> wrote in message
> >news:0def01c38d87$06a78890$a101280a@.phx.gbl...
> >> I'm having a problem testing a point in time backup.
> Here
> >> is what I was trying:
> >>
> >> 1) I created a complete database backup to a file
> >> D:\TEMP.DAT (of a database named
> >> PHCS) (Time - 10:45)
> >> 2) I went and made some changes to the PHCS database at
> >> 10:49:10
> >> 3) I went and made some more changes to the PHCS
> database
> >> at 10:50:50
> >> 4) I backed up the transaction log database (also into
> >> D:\TEMP.DAT, appending).
> >> (Time - 10:52)
> >> 5) I went to restore the database backed up at 10:45
> and
> >> left it unoperational
> >> 6) I went to restore the transaction log created at
> 10:52
> >> and tried to specify a time
> >> of 10:50:00. I wanted to restore the changes made in
> step
> >> 2, but not step 3.
> >>
> >> He restore me the hole last transaction log i selected
> >> an don't stop between step 2 and 3 !!
> >>
> >> Many thanks for your help
> >>
> >> Daniel
> >>
> >
> >
> >.
> >

A or B

There is a scanario like there are two tables name department and other is
Employee. Each department manager has been added to the managers database
role. You need to allow members of this database role to view all of the
data in the department table. Members of this role should be able to insert
or update only the row that pertains to their department. You grant the
managers database role SELECT permissions on the department table.
What should you do next?
A. Create a trigger on the department table that checks whether the database
login of the user performing the insert or update operation belongs to a
member of that department.
B. Create a view that includes all columns in the department table and the
SQLLogin column from the employees table.include the WITH CHECK OPTION
clause in the view definition.
Thanks
NOOR
Easy choice as I don't like updateable views at all. Seriously though, I'd
suggest:
C. Create an update stored proc that implements the appropriate logic.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Noor" <noor@.ngsol.com> wrote in message
news:%233IJ5ZZkEHA.3724@.TK2MSFTNGP11.phx.gbl...
> There is a scanario like there are two tables name department and other is
> Employee. Each department manager has been added to the managers database
> role. You need to allow members of this database role to view all of the
> data in the department table. Members of this role should be able to
insert
> or update only the row that pertains to their department. You grant the
> managers database role SELECT permissions on the department table.
> What should you do next?
> A. Create a trigger on the department table that checks whether the
database
> login of the user performing the insert or update operation belongs to a
> member of that department.
> B. Create a view that includes all columns in the department table and the
> SQLLogin column from the employees table.include the WITH CHECK OPTION
> clause in the view definition.
> Thanks
> NOOR
>
|||Between the given two options, I would go with the second one, as SQL Server
will do the checking for you, instead of you creating a trigger and writing
code for it.
You might find this article somewhat related:
Implementing Row Level Security in SQL Server
http://vyaskn.tripod.com/row_level_s..._databases.htm
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Noor" <noor@.ngsol.com> wrote in message
news:%233IJ5ZZkEHA.3724@.TK2MSFTNGP11.phx.gbl...
> There is a scanario like there are two tables name department and other is
> Employee. Each department manager has been added to the managers database
> role. You need to allow members of this database role to view all of the
> data in the department table. Members of this role should be able to
insert
> or update only the row that pertains to their department. You grant the
> managers database role SELECT permissions on the department table.
> What should you do next?
> A. Create a trigger on the department table that checks whether the
database
> login of the user performing the insert or update operation belongs to a
> member of that department.
> B. Create a view that includes all columns in the department table and the
> SQLLogin column from the employees table.include the WITH CHECK OPTION
> clause in the view definition.
> Thanks
> NOOR
>

A lil help with DB design

I have a table to store members. For each member, I have flags like manager, verified, etc. How should I be storing the flags? As individual columns in the same table and using bit datatype or creating a new table called MemberStatus and creating 1 row for each flag?

Thanx in advance.

Premal.One table.|||no flags, no bit data

just more to interprete|||Option 1. Flags, bits.
1 = true, 0 = false. Not much to interpret.|||1 = true, 0 = false, Null = unknown ;)|||1 = true
0 = false
6 = not sure
9 = not applicable
NULL = unknown|||10 = drop dead gorgeous.|||7 = very fluffy.

-PatP|||to properly account for shades of gray, you should use a decimal.

.983 = high degree of truthiness
.015 = minor fib, won't hurt anyone|||"truthiness" heh

somebody is a big fan of TheDailyWTF

:)|||nah, i got it from Colbert. He invented that word.|||1 = true, 0 = false, Null = unknown ;)

Null does not mean unknown, it means the absence of any value, or non existence|||ah, i see, thanks brett

but ontologically speaking, "absence of any value, or non existence" includes unknown

it also includes not applicable, out of range, optional, forgot, maybe, and WTF!|||ah, i see, thanks brett

but ontologically speaking, "absence of any value, or non existence" includes unknown

it also includes not applicable, out of range, optional, forgot, maybe, and WTF!

Ummm no, unkown mean there's a quanity, but who knows.

Null means there's not even the understanding of any quantity

And I like the words you keep throwing out there

But shouldn't it be anti-ontologically

http://www.allwords.com/word-ontologically.html|||Ooh! NULL FIGHT! NULL FIGHT!|||Is that where you throw null pointer exceptions?

Sorry. Couldn't resist.|||Null fights usually turn out to be "Much Ado About Nothing".|||Ooh! NULL FIGHT! NULL FIGHT!

LOL

This message is too short