Auto Change Script

In Enterprise Manager (SQL2K) the Save Change Script
prompt that appears when you save the design of a table
has stopped appearing. Any ideas how to turn it back on
again?Click the "Save change script" button (third from the left), then check the
checkbox at the bottom of the dialog.
--
Jacco Schalkwijk
SQL Server MVP
"Mark Stipetic" <anonymous@.discussions.microsoft.com> wrote in message
news:0a3f01c39897$01cfb8e0$a501280a@.phx.gbl...
> In Enterprise Manager (SQL2K) the Save Change Script
> prompt that appears when you save the design of a table
> has stopped appearing. Any ideas how to turn it back on
> again?|||If you press the "Save change script" button on the toolbar, is the checkbox to auto-save enabled?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mark Stipetic" <anonymous@.discussions.microsoft.com> wrote in message
news:0a3f01c39897$01cfb8e0$a501280a@.phx.gbl...
> In Enterprise Manager (SQL2K) the Save Change Script
> prompt that appears when you save the design of a table
> has stopped appearing. Any ideas how to turn it back on
> again?|||Sorted. Many Thanks
>--Original Message--
>Click the "Save change script" button (third from the
left), then check the
>checkbox at the bottom of the dialog.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Mark Stipetic" <anonymous@.discussions.microsoft.com>
wrote in message
>news:0a3f01c39897$01cfb8e0$a501280a@.phx.gbl...
>> In Enterprise Manager (SQL2K) the Save Change Script
>> prompt that appears when you save the design of a table
>> has stopped appearing. Any ideas how to turn it back on
>> again?
>
>.
>

Audit Logins

We are having an issue with an application connecting to
our database. In order to capture the login failures, I
went into Enterprise Manager properties and went to the
security tab. I then selected that audit level = all,
which to me means it audits all logins. However, when I
connect either correctly or with erros, there is nothing
written to the SQL Server Logs.
I tried to find more info in BOL's but couldn't. Where is
the audit info logged?
I now have a trace set up via profiler, but would still
like to understand why the 'audit level' via enterprise
manager didn't work. (I even ran a reconfig)
Thanks
SusanYou have to stop/restart the sql server service for this to take effect, and
the login failures will be in the SQL Server log.
"Susan" <anonymous@.discussions.microsoft.com> wrote in message
news:8efc01c3e9b9$663bc300$a601280a@.phx.gbl...
> We are having an issue with an application connecting to
> our database. In order to capture the login failures, I
> went into Enterprise Manager properties and went to the
> security tab. I then selected that audit level = all,
> which to me means it audits all logins. However, when I
> connect either correctly or with erros, there is nothing
> written to the SQL Server Logs.
> I tried to find more info in BOL's but couldn't. Where is
> the audit info logged?
> I now have a trace set up via profiler, but would still
> like to understand why the 'audit level' via enterprise
> manager didn't work. (I even ran a reconfig)
> Thanks
> Susan
>

Audit Logins

We are having an issue with an application connecting to
our database. In order to capture the login failures, I
went into Enterprise Manager properties and went to the
security tab. I then selected that audit level = all,
which to me means it audits all logins. However, when I
connect either correctly or with erros, there is nothing
written to the SQL Server Logs.
I tried to find more info in BOL's but couldn't. Where is
the audit info logged?
I now have a trace set up via profiler, but would still
like to understand why the 'audit level' via enterprise
manager didn't work. (I even ran a reconfig)
Thanks
SusanYou have to stop/restart the sql server service for this to take effect, and
the login failures will be in the SQL Server log.
"Susan" <anonymous@.discussions.microsoft.com> wrote in message
news:8efc01c3e9b9$663bc300$a601280a@.phx.gbl...

quote:

---

> We are having an issue with an application connecting to
> our database. In order to capture the login failures, I
> went into Enterprise Manager properties and went to the
> security tab. I then selected that audit level = all,
> which to me means it audits all logins. However, when I
> connect either correctly or with erros, there is nothing
> written to the SQL Server Logs.
> I tried to find more info in BOL's but couldn't. Where is
> the audit info logged?
> I now have a trace set up via profiler, but would still
> like to understand why the 'audit level' via enterprise
> manager didn't work. (I even ran a reconfig)
> Thanks
> Susan
>

---

Audit Failures whenever I start the SQL Enterprise Manager

Hi,
When ever I start the Enterprise manger client from my laptop(Client), I see
the Failure Audit in the Security Eventlog. I registered all the servers
using sql authentication. I am running SQL Enterprisemanger on Windows Xp.
Here is one of the error:
Unprotection of auditable protected data.
Data Description: SQL Server Registration
Key Identifier: 1f3ba71a-6f52-4e58-8007-43ced74242b4
Protected Data Flags: 0x0
Protection Algorithms: 3DES-168 , SHA1-160
Failure Reason: 0x8009000B
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Can anybody having the fix for this, because my securtiy Auditing team
questioning these failures.
Thanks
rb
1. Do you have encryption enabled on the client or server?
2. When this happens is the laptop connected to the network?
3. Do you have any IPSec rules setup for the SQL Server?
"rb" <srbssr@.yahoo.com> wrote in message
news:efxp4cN9EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When ever I start the Enterprise manger client from my laptop(Client), I
see
> the Failure Audit in the Security Eventlog. I registered all the servers
> using sql authentication. I am running SQL Enterprisemanger on Windows Xp.
> Here is one of the error:
> Unprotection of auditable protected data.
> Data Description: SQL Server Registration
> Key Identifier: 1f3ba71a-6f52-4e58-8007-43ced74242b4
> Protected Data Flags: 0x0
> Protection Algorithms: 3DES-168 , SHA1-160
> Failure Reason: 0x8009000B
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Can anybody having the fix for this, because my securtiy Auditing team
> questioning these failures.
> Thanks
> rb
>

attaching sql 2000 db with enterprse manager

When I upgrade from a sql 7 db to a sql 2000 db, everything goes well. I can also detach the 2000 db with sql 2000 enterprise manager. But when I want to attach the db again to an other sql 2000 server my loginnames disappear when i look at my users. This is because there are not yet any loginnames under the other sql 2000 server. What can I do to get my loginnames also under my usernames at the database to be attached. Else I cannot login in. Tell Me, please!

thanks beforehand.

\greetings ThePercivalYou can use the Transfer Logins DTS function that comes with SQL2K, but that will only transfer the logins and not their associated permissions.

You also have to BCP the syslogins table and then use sp_resolve_logins to restore the associated permissions. See SQL BOL on sp_resolve_logins

Regards,

Hugh Scott

Originally posted by thepercival
When I upgrade from a sql 7 db to a sql 2000 db, everything goes well. I can also detach the 2000 db with sql 2000 enterprise manager. But when I want to attach the db again to an other sql 2000 server my loginnames disappear when i look at my users. This is because there are not yet any loginnames under the other sql 2000 server. What can I do to get my loginnames also under my usernames at the database to be attached. Else I cannot login in. Tell Me, please!

thanks beforehand.

\greetings ThePercival

attaching a link to an email subscription

Our report manager and reports are accessed over a secure conection but the link uses http:// by default. where can i change that to https://?

You can change default report serwer url address in configuration files of your report server (rsreportserver.config or something like that)

Attached DB and SQL Express: Now you see it, Now you don't!!!

After installing SQL Express 2005, I attached a DB of mine, with success.

I can see it from the lagacy enterprise manager, and if I launch the query analyzer fromm within SQL Ent. Manager that DB appear in the DB pane list ans THAT IS FINE.

Now when I launch the Query Analyzer directly from Windows, the attached DB doesn't appear. Same when I try to create an ODBC DataSource pointing to that DB: Is DOESN'T APPEAR and THAT IS NOT FINE!!!

Anybody have a clue?

Thanks in advanceCan you still use the database in Query Analyzer or osql? (What I'm trying to understand if this is a UI issue or something else).

Do you have SQL Server 2000 installed on the same machine (since you have older tools)? While it is a supported scenario (both SQL Server 2000 and 2005 on the same machine), there may be interaction between installed components that affect how the information is displayed in tools.

Boris.|||I have the exact same problem my sqlexpress db shows up in the

Enterprise manager and in the new Management Studio Express. It

does not however show up when I create an ODBC data source. I can

type in the machine name and the server name and it works.|||It sounds like you are using SQL2K tools against SQL 2005 Express edition, try using SQL Server Management Studio and Query Editor instead.

Attached DB and SQL Express: Now you see it, Now you don't!!!

After installing SQL Express 2005, I attached a DB of mine, with success.

I can see it from the lagacy enterprise manager, and if I launch the query analyzer fromm within SQL Ent. Manager that DB appear in the DB pane list ans THAT IS FINE.

Now when I launch the Query Analyzer directly from Windows, the attached DB doesn't appear. Same when I try to create an ODBC DataSource pointing to that DB: Is DOESN'T APPEAR and THAT IS NOT FINE!!!

Anybody have a clue?

Thanks in advanceCan you still use the database in Query Analyzer or osql? (What I'm trying to understand if this is a UI issue or something else).

Do you have SQL Server 2000 installed on the same machine (since you have older tools)? While it is a supported scenario (both SQL Server 2000 and 2005 on the same machine), there may be interaction between installed components that affect how the information is displayed in tools.

Boris.|||I have the exact same problem my sqlexpress db shows up in the Enterprise manager and in the new Management Studio Express. It does not however show up when I create an ODBC data source. I can type in the machine name and the server name and it works.
|||It sounds like you are using SQL2K tools against SQL 2005 Express edition, try using SQL Server Management Studio and Query Editor instead.

Attached DB and SQL Express: Now you see it, Now you don't!!!

After installing SQL Express 2005, I attached a DB of mine, with success.

I can see it from the lagacy enterprise manager, and if I launch the query analyzer fromm within SQL Ent. Manager that DB appear in the DB pane list ans THAT IS FINE.

Now when I launch the Query Analyzer directly from Windows, the attached DB doesn't appear. Same when I try to create an ODBC DataSource pointing to that DB: Is DOESN'T APPEAR and THAT IS NOT FINE!!!

Anybody have a clue?

Thanks in advanceCan you still use the database in Query Analyzer or osql? (What I'm trying to understand if this is a UI issue or something else).

Do you have SQL Server 2000 installed on the same machine (since you have older tools)? While it is a supported scenario (both SQL Server 2000 and 2005 on the same machine), there may be interaction between installed components that affect how the information is displayed in tools.

Boris.|||I have the exact same problem my sqlexpress db shows up in the Enterprise manager and in the new Management Studio Express. It does not however show up when I create an ODBC data source. I can type in the machine name and the server name and it works.
|||It sounds like you are using SQL2K tools against SQL 2005 Express edition, try using SQL Server Management Studio and Query Editor instead.

Attached DB and SQL Express: Now you see it, Now you don't!!!

After installing SQL Express 2005, I attached a DB of mine, with success.

I can see it from the lagacy enterprise manager, and if I launch the query analyzer fromm within SQL Ent. Manager that DB appear in the DB pane list ans THAT IS FINE.

Now when I launch the Query Analyzer directly from Windows, the attached DB doesn't appear. Same when I try to create an ODBC DataSource pointing to that DB: Is DOESN'T APPEAR and THAT IS NOT FINE!!!

Anybody have a clue?

Thanks in advanceCan you still use the database in Query Analyzer or osql? (What I'm trying to understand if this is a UI issue or something else).

Do you have SQL Server 2000 installed on the same machine (since you have older tools)? While it is a supported scenario (both SQL Server 2000 and 2005 on the same machine), there may be interaction between installed components that affect how the information is displayed in tools.

Boris.|||I have the exact same problem my sqlexpress db shows up in the Enterprise manager and in the new Management Studio Express. It does not however show up when I create an ODBC data source. I can type in the machine name and the server name and it works.
|||It sounds like you are using SQL2K tools against SQL 2005 Express edition, try using SQL Server Management Studio and Query Editor instead.

Attach/Detach database

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attach
both databases on both servers back.
Unfortunately my server displays Attach Database entry only in popup menu. I
have nothing to attach yet.
I did this operation several times and had no problem before. Probably I
detached some of the unimportant databases and forgot to attach it back.
How can I refresh (clean up whatever) Enterprise Manager memory about last
operation in order to have the ability to use Detach feature?
Thank you
Al
Hi
I would recommend that you do this from Query Analyser, there is no need to
create the database first.
http://support.microsoft.com/default...en-us%3b224071
John
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
> I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>
|||The detach option is context-sensitive so you need to first select the
desired database in the tree.
You should not create a new database before attaching. Detach the database
and copy the files to the new server. In the Attach database dialog,
specify the mdf file, click Verify and specify the desired database name in
the 'Attach As' box. You can change the locations of the other files in the
list, if needed.
You might also consider using the sp_attach_db and sp_detach_db stored
procedures. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
>I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
> to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
> attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
> I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>

Attach/Detach database

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attach
both databases on both servers back.
Unfortunately my server displays Attach Database entry only in popup menu. I
have nothing to attach yet.
I did this operation several times and had no problem before. Probably I
detached some of the unimportant databases and forgot to attach it back.
How can I refresh (clean up whatever) Enterprise Manager memory about last
operation in order to have the ability to use Detach feature?
Thank you
AlHi
I would recommend that you do this from Query Analyser, there is no need to
create the database first.
http://support.microsoft.com/defaul...ben-us%3b224071
John
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
> I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>|||The detach option is context-sensitive so you need to first select the
desired database in the tree.
You should not create a new database before attaching. Detach the database
and copy the files to the new server. In the Attach database dialog,
specify the mdf file, click Verify and specify the desired database name in
the 'Attach As' box. You can change the locations of the other files in the
list, if needed.
You might also consider using the sp_attach_db and sp_detach_db stored
procedures. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
>I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
> to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
> attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
> I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>

Attach SQL 2005 db to SQL 2000

I need to attach SQL 2005 DB to SQL 2000 server.
I cannot be sure, but I think I did it before in Entreprise Manager. I also
found an answer to my question on Internet
(http://www.thescripts.com/forum/thread648521.html), which says that it can
be done with enterprise tool.
When I'm trying to do it I get an error 602. Could not find row in
sysindexes... Run DBCC CHECKTABLE...
I did it on the source server, detached db, copied and tried to attach again
and got the same error.
Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
2000.
Any advice please
vovan
If you did this before you it was most likely after one too many beers.
You can not go backwards from 2005 to 2000 with a restore or attach. You
must export the data and import it into a schema that you created on 2000.
Andrew J. Kelly SQL MVP
"vovan" <v@.v.com> wrote in message
news:%23Frf9CByHHA.1212@.TK2MSFTNGP05.phx.gbl...
>I need to attach SQL 2005 DB to SQL 2000 server.
> I cannot be sure, but I think I did it before in Entreprise Manager. I
> also found an answer to my question on Internet
> (http://www.thescripts.com/forum/thread648521.html), which says that it
> can be done with enterprise tool.
> When I'm trying to do it I get an error 602. Could not find row in
> sysindexes... Run DBCC CHECKTABLE...
> I did it on the source server, detached db, copied and tried to attach
> again and got the same error.
> Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
> 2000.
> Any advice please
> vovan
>

Attach SQL 2005 db to SQL 2000

I need to attach SQL 2005 DB to SQL 2000 server.
I cannot be sure, but I think I did it before in Entreprise Manager. I also
found an answer to my question on Internet
(http://www.thescripts.com/forum/thread648521.html), which says that it can
be done with enterprise tool.
When I'm trying to do it I get an error 602. Could not find row in
sysindexes... Run DBCC CHECKTABLE...
I did it on the source server, detached db, copied and tried to attach again
and got the same error.
Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
2000.
Any advice please
vovan
If you did this before you it was most likely after one too many beers.
You can not go backwards from 2005 to 2000 with a restore or attach. You
must export the data and import it into a schema that you created on 2000.
Andrew J. Kelly SQL MVP
"vovan" <v@.v.com> wrote in message
news:%23Frf9CByHHA.1212@.TK2MSFTNGP05.phx.gbl...
>I need to attach SQL 2005 DB to SQL 2000 server.
> I cannot be sure, but I think I did it before in Entreprise Manager. I
> also found an answer to my question on Internet
> (http://www.thescripts.com/forum/thread648521.html), which says that it
> can be done with enterprise tool.
> When I'm trying to do it I get an error 602. Could not find row in
> sysindexes... Run DBCC CHECKTABLE...
> I did it on the source server, detached db, copied and tried to attach
> again and got the same error.
> Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
> 2000.
> Any advice please
> vovan
>

Attach SQL 2005 db to SQL 2000

I need to attach SQL 2005 DB to SQL 2000 server.
I cannot be sure, but I think I did it before in Entreprise Manager. I also
found an answer to my question on Internet
(http://www.thescripts.com/forum/thread648521.html), which says that it can
be done with enterprise tool.
When I'm trying to do it I get an error 602. Could not find row in
sysindexes... Run DBCC CHECKTABLE...
I did it on the source server, detached db, copied and tried to attach again
and got the same error.
Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
2000.
Any advice please
vovanIf you did this before you it was most likely after one too many beers:).
You can not go backwards from 2005 to 2000 with a restore or attach. You
must export the data and import it into a schema that you created on 2000.
--
Andrew J. Kelly SQL MVP
"vovan" <v@.v.com> wrote in message
news:%23Frf9CByHHA.1212@.TK2MSFTNGP05.phx.gbl...
>I need to attach SQL 2005 DB to SQL 2000 server.
> I cannot be sure, but I think I did it before in Entreprise Manager. I
> also found an answer to my question on Internet
> (http://www.thescripts.com/forum/thread648521.html), which says that it
> can be done with enterprise tool.
> When I'm trying to do it I get an error 602. Could not find row in
> sysindexes... Run DBCC CHECKTABLE...
> I did it on the source server, detached db, copied and tried to attach
> again and got the same error.
> Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
> 2000.
> Any advice please
> vovan
>

Attach SQL 2005 db to SQL 2000

I need to attach SQL 2005 DB to SQL 2000 server.
I cannot be sure, but I think I did it before in Entreprise Manager. I also
found an answer to my question on Internet
(http://www.thescripts.com/forum/thread648521.html), which says that it can
be done with enterprise tool.
When I'm trying to do it I get an error 602. Could not find row in
sysindexes... Run DBCC CHECKTABLE...
I did it on the source server, detached db, copied and tried to attach again
and got the same error.
Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
2000.
Any advice please
vovanIf you did this before you it was most likely after one too many beers.
You can not go backwards from 2005 to 2000 with a restore or attach. You
must export the data and import it into a schema that you created on 2000.
Andrew J. Kelly SQL MVP
"vovan" <v@.v.com> wrote in message
news:%23Frf9CByHHA.1212@.TK2MSFTNGP05.phx.gbl...
>I need to attach SQL 2005 DB to SQL 2000 server.
> I cannot be sure, but I think I did it before in Entreprise Manager. I
> also found an answer to my question on Internet
> (http://www.thescripts.com/forum/thread648521.html), which says that it
> can be done with enterprise tool.
> When I'm trying to do it I get an error 602. Could not find row in
> sysindexes... Run DBCC CHECKTABLE...
> I did it on the source server, detached db, copied and tried to attach
> again and got the same error.
> Now I'm not sure that SQL 2005 mdf and ldf files are compatible with SQL
> 2000.
> Any advice please
> vovan
>