Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Request for feedback - Aliases have been deprecated for some time and will be removed soon

As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.

We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

We are also planning on removing the following stored procedures in the next release:

sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup

Thanks,
Jack Richins
SDE
SQL Server Engine

|||Removing entirely from the SQL server may not be an option, will there be any documentation or MS article released to enable the new users to understand the 'new' concept in addition to BOL .|||

Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:

· Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx

· Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx

· Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx

Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server.Thanks a lot, for your feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Raul
Appreciate your links in this case, I will ask my users to understand to have more information and post back if any further details are required.

Thanks.|||

Raul

Have you had any feedback in this regard, would like to know more about it.

|||We have not recieved any additional comments with regard to the removal of aliases.|||I haven't run across a customer using aliases for a VERY long time. I don't see any issues with removing them as far as any of my customers are concerned.|||

I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.

|||

I haven't seen them at any site in the past few years at least.

-Sue

|||So they will be removed in next release of SQL or service pack?|||

They will be removed on the next release.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.

|||I am fine with the change|||Agreed. No issues here with removing them from Katmai.

Reposting: How to extract (and email) only 1 client's data from th

Hi,
My vb.net app will use msde for database needs. The app is a tool in which the app user (companyA) will do some planning for their clients. So basically, the database will have information about all the clients (Sam, Julia, Peter, Nancy etc) of our cust
omer (companyA). Now suppose there is some error happening in the application for user Nancy, and we want the companyA to send us only Nancy's data so that we can duplicate the error and debug it. How do we do that...
In previous versions of our app where we used the flat files for data storage, we will just tell the companyA to email us Nancy.ourFile so that we can have a look at the data which is causing the problem. How to extract only Nancy's data from the whole d
atabase...
Thanks
dev
hi,
"dev_kh" <devkh@.discussions.microsoft.com> ha scritto nel messaggio
news:782E4169-30DB-4AEF-B7BC-CC375DABE132@.microsoft.com...
> Hi,
> My vb.net app will use msde for database needs. The app is a tool in
which the app user
>(companyA) will do some planning for their clients. So basically, the
database will have
>information about all the clients (Sam, Julia, Peter, Nancy etc) of our
customer (companyA).
> Now suppose there is some error happening in the application for user
Nancy, and we want
> the companyA to send us only Nancy's data so that we can duplicate the
error and debug it.
> How do we do that...
> In previous versions of our app where we used the flat files for data
storage, we will just tell the
> companyA to email us Nancy.ourFile so that we can have a look at the data
which is causing
>the problem. How to extract only Nancy's data from the whole database...
> Thanks
> dev
>
it depends how you can identify Nancys' data...
if it's a complete database, than detach it, zip it and mail it...
if data is shared with other user's data, than you have to filter on perhaps
owner.tableName.col_User = 'Nancy' and export it to a flat file, probably
using BCP, something like
c:\>BCP "SELECT * FROM [db_name].[owner].[table/view name] WHERE colUser =
'Nancy'" queryout c:\NacyData_objName.txt -c -S(local) -T
make a batch file with all the queryout BCP commands...
or provide a DTS to be executed locally to equally export to file
those file will be then BCP in on testing server for toubleshouting...
good idea? =;-)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply