How to execute

I have a job that requires me to call and execute a SSIS package as the first step in a SQL2k5 Stored Procedure.

Can someone please give me a basic DTEXEC example?

Thanks in advance !Moving to the SSIS forum|||

cheers Louis.

To the OP, perhaps this will help:

Online Beginner Resources
http://blogs.conchango.com/jamiethomson/archive/2007/01/30/SSIS_3A00_-Online-Beginner-Resources.aspx

-Jamie

How to edit a asp.net2.0/C# project in VS2005, Plz HELP

hi all,

I created a new sql server 2005 database name wsat_demo in the

(lESSQL1)\sql2k5 enterprise server

in the default website properties i added a connection string named WSAT1 to wsat_demo database using aspnet_user account with SA priveledge

i modified the machine.config to use WSAT1 connection string

Then i run the WSAT (website admin tools) to create users.

this error appears. "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. "

i've tried attaching the database created by the asp.net project located at app_data folder named it App_data1 database

do the same configuration as stated above. Viola! the WSAT connects to it.

After comprehensive investigation, App_data1 database shows that it contains many security objects builtin to it by asp.net 2 application.

QUESTION: How can I have WSAT_demo database to have the same object as App_data1 given the fact that my connection is enjoying SA priviledge?

thanks,

joeydj

Pareng joey...musta na buhay natin?

Are you creating a database that will store user profiles? If you are, you might wanna start by creating a blank SQL Server database. Then, run the aspnet_regsql.exe and point to this blank database you just created. This is a wizard that creates all these database objects in SQL Server(whether it's 2000 or 2005). Then you can point your ASP.NET 2.0 web app to this database in your web.config. But before you can do this, make sure you override the settings in th machine.config. For a complete step-by-step guide on this, check out Scott Guthrie's blog as this was my guide when I was working on a similar task using the Beta 2 version of Visual Studio 2005

|||

okay lang. sounds like i'm at the

msforums it used to be msdn.ph

running the aspnet_regsql.exe is just like attaching the database

from the app_data on the remote server

|||

Hi,

How can i run or edit my ASP.NET 2.0/C# project in VS2005. I have source code files (including database) but it doesn't have .sln file. Please guide me how can i edit or run this in VS2005

How To Drop _WA Statistics On SQL2K5

It appears that SQL2K5 has removed the ability to drop _WA statistics. It
keeps giving me the error â'Cannot drop the statistics
'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist or
you do not have permission.â' When trying to run â'drop statistics
[tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]â'. In SQL2K this used to work
fineâ?¦.
We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
then now to SQL2K5 and each table originally was not indexed well at all so
we have TONS of these _WA statistics pied up on every table. I want to be
able to remove all _WA stats and allow the SQL Server to regenerate these as
needed now that we are running the new SQL2K5 engine.
Anyone find a way of doing this now? Or will SQL2K5 remove these on its own
if it does not need them any longer? Does not appear it removes them by
itself based on the quantity of these hanging around.
Thx!
Ross NornesHow are you getting the list of statistics and are you sure the account does
have the proper permissions to drop them?
--
Andrew J. Kelly SQL MVP
"Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
> It appears that SQL2K5 has removed the ability to drop _WA statistics. It
> keeps giving me the error "Cannot drop the statistics
> 'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist
> or
> you do not have permission." When trying to run "drop statistics
> [tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]". In SQL2K this used to
> work
> fine..
> We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
> then now to SQL2K5 and each table originally was not indexed well at all
> so
> we have TONS of these _WA statistics pied up on every table. I want to be
> able to remove all _WA stats and allow the SQL Server to regenerate these
> as
> needed now that we are running the new SQL2K5 engine.
> Anyone find a way of doing this now? Or will SQL2K5 remove these on its
> own
> if it does not need them any longer? Does not appear it removes them by
> itself based on the quantity of these hanging around.
> Thx!
> Ross Nornes
>|||We just use a simple query to generate the DROP scripts that we used to use
for SQL2K. I have included it below for review.
And yes, I'm the DBA so I'm logged in as SA on the box. Permissions should
not be an issue.
select
'drop statistics [' + object_name(i.id) + '].['+ i.name + ']'
from sysindexes i join
sysobjects o on i.id = o.id
where
i.name like '_wa%'
order by i.name
Thx!
Ross Nornes
"Andrew J. Kelly" wrote:
> How are you getting the list of statistics and are you sure the account does
> have the proper permissions to drop them?
> --
> Andrew J. Kelly SQL MVP
> "Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
> news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
> > It appears that SQL2K5 has removed the ability to drop _WA statistics. It
> > keeps giving me the error "Cannot drop the statistics
> > 'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist
> > or
> > you do not have permission." When trying to run "drop statistics
> > [tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]". In SQL2K this used to
> > work
> > fine..
> >
> > We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
> > then now to SQL2K5 and each table originally was not indexed well at all
> > so
> > we have TONS of these _WA statistics pied up on every table. I want to be
> > able to remove all _WA stats and allow the SQL Server to regenerate these
> > as
> > needed now that we are running the new SQL2K5 engine.
> >
> > Anyone find a way of doing this now? Or will SQL2K5 remove these on its
> > own
> > if it does not need them any longer? Does not appear it removes them by
> > itself based on the quantity of these hanging around.
> >
> > Thx!
> >
> > Ross Nornes
> >
>
>|||Ross,
I have seen that when the drop scrip was run in the context of master and
not the user db. But in any case you may want to use the new sys.stats view
instead.
SELECT 'drop statistics [' + object_name(i.[object_id]) + '].['+ i.[name] +
']'
FROM sys.stats as i
WHERE OBJECTPROPERTY(i.[object_id],'IsUserTable') = 1 AND i.[name] LIKE
'_WA%'
ORDER BY i.name
Andrew J. Kelly SQL MVP
"Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
news:8F4B7751-D825-47F6-BB7B-A0B0C35D6105@.microsoft.com...
> We just use a simple query to generate the DROP scripts that we used to
> use
> for SQL2K. I have included it below for review.
> And yes, I'm the DBA so I'm logged in as SA on the box. Permissions should
> not be an issue.
> select
> 'drop statistics [' + object_name(i.id) + '].['+ i.name + ']'
> from sysindexes i join
> sysobjects o on i.id = o.id
> where
> i.name like '_wa%'
> order by i.name
> Thx!
> Ross Nornes
> "Andrew J. Kelly" wrote:
>> How are you getting the list of statistics and are you sure the account
>> does
>> have the proper permissions to drop them?
>> --
>> Andrew J. Kelly SQL MVP
>> "Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
>> news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
>> > It appears that SQL2K5 has removed the ability to drop _WA statistics.
>> > It
>> > keeps giving me the error "Cannot drop the statistics
>> > 'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not
>> > exist
>> > or
>> > you do not have permission." When trying to run "drop statistics
>> > [tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]". In SQL2K this used
>> > to
>> > work
>> > fine..
>> >
>> > We have a large legacy DB that we upgraded originally from SQL 7 to
>> > SQL2K,
>> > then now to SQL2K5 and each table originally was not indexed well at
>> > all
>> > so
>> > we have TONS of these _WA statistics pied up on every table. I want to
>> > be
>> > able to remove all _WA stats and allow the SQL Server to regenerate
>> > these
>> > as
>> > needed now that we are running the new SQL2K5 engine.
>> >
>> > Anyone find a way of doing this now? Or will SQL2K5 remove these on its
>> > own
>> > if it does not need them any longer? Does not appear it removes them
>> > by
>> > itself based on the quantity of these hanging around.
>> >
>> > Thx!
>> >
>> > Ross Nornes
>> >
>>

How To Drop _WA Statistics On SQL2K5

It appears that SQL2K5 has removed the ability to drop _WA statistics. It
keeps giving me the error “Cannot drop the statistics
'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist or
you do not have permission.” When trying to run “drop statistics
[tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]”. In SQL2K this used to work
fine….
We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
then now to SQL2K5 and each table originally was not indexed well at all so
we have TONS of these _WA statistics pied up on every table. I want to be
able to remove all _WA stats and allow the SQL Server to regenerate these as
needed now that we are running the new SQL2K5 engine.
Anyone find a way of doing this now? Or will SQL2K5 remove these on its own
if it does not need them any longer? Does not appear it removes them by
itself based on the quantity of these hanging around.
Thx!
Ross Nornes
How are you getting the list of statistics and are you sure the account does
have the proper permissions to drop them?
Andrew J. Kelly SQL MVP
"Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
> It appears that SQL2K5 has removed the ability to drop _WA statistics. It
> keeps giving me the error "Cannot drop the statistics
> 'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist
> or
> you do not have permission." When trying to run "drop statistics
> [tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]". In SQL2K this used to
> work
> fine..
> We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
> then now to SQL2K5 and each table originally was not indexed well at all
> so
> we have TONS of these _WA statistics pied up on every table. I want to be
> able to remove all _WA stats and allow the SQL Server to regenerate these
> as
> needed now that we are running the new SQL2K5 engine.
> Anyone find a way of doing this now? Or will SQL2K5 remove these on its
> own
> if it does not need them any longer? Does not appear it removes them by
> itself based on the quantity of these hanging around.
> Thx!
> Ross Nornes
>
|||We just use a simple query to generate the DROP scripts that we used to use
for SQL2K. I have included it below for review.
And yes, I'm the DBA so I'm logged in as SA on the box. Permissions should
not be an issue.
select
'drop statistics [' + object_name(i.id) + '].['+ i.name + ']'
from sysindexes i join
sysobjects o on i.id = o.id
where
i.name like '_wa%'
order by i.name
Thx!
Ross Nornes
"Andrew J. Kelly" wrote:

> How are you getting the list of statistics and are you sure the account does
> have the proper permissions to drop them?
> --
> Andrew J. Kelly SQL MVP
> "Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
> news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
>
>
|||Ross,
I have seen that when the drop scrip was run in the context of master and
not the user db. But in any case you may want to use the new sys.stats view
instead.
SELECT 'drop statistics [' + object_name(i.[object_id]) + '].['+ i.[name] +
']'
FROM sys.stats as i
WHERE OBJECTPROPERTY(i.[object_id],'IsUserTable') = 1 AND i.[name] LIKE
'_WA%'
ORDER BY i.name
Andrew J. Kelly SQL MVP
"Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
news:8F4B7751-D825-47F6-BB7B-A0B0C35D6105@.microsoft.com...[vbcol=seagreen]
> We just use a simple query to generate the DROP scripts that we used to
> use
> for SQL2K. I have included it below for review.
> And yes, I'm the DBA so I'm logged in as SA on the box. Permissions should
> not be an issue.
> select
> 'drop statistics [' + object_name(i.id) + '].['+ i.name + ']'
> from sysindexes i join
> sysobjects o on i.id = o.id
> where
> i.name like '_wa%'
> order by i.name
> Thx!
> Ross Nornes
> "Andrew J. Kelly" wrote:

How To Drop _WA Statistics On SQL2K5

It appears that SQL2K5 has removed the ability to drop _WA statistics. It
keeps giving me the error “Cannot drop the statistics
'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist or
you do not have permission.” When trying to run “drop statistics
[tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]”. In SQL2K this u
sed to work
fine….
We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
then now to SQL2K5 and each table originally was not indexed well at all so
we have TONS of these _WA statistics pied up on every table. I want to be
able to remove all _WA stats and allow the SQL Server to regenerate these as
needed now that we are running the new SQL2K5 engine.
Anyone find a way of doing this now? Or will SQL2K5 remove these on its own
if it does not need them any longer? Does not appear it removes them by
itself based on the quantity of these hanging around.
Thx!
Ross NornesHow are you getting the list of statistics and are you sure the account does
have the proper permissions to drop them?
Andrew J. Kelly SQL MVP
"Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
> It appears that SQL2K5 has removed the ability to drop _WA statistics. It
> keeps giving me the error "Cannot drop the statistics
> 'tbl_TSDetail_2983._WA_Sys_00000002_0301381D', because it does not exist
> or
> you do not have permission." When trying to run "drop statistics
> [tbl_TSDetail_2983].[_WA_Sys_00000002_0301381D]". In SQL2K this u
sed to
> work
> fine..
> We have a large legacy DB that we upgraded originally from SQL 7 to SQL2K,
> then now to SQL2K5 and each table originally was not indexed well at all
> so
> we have TONS of these _WA statistics pied up on every table. I want to be
> able to remove all _WA stats and allow the SQL Server to regenerate these
> as
> needed now that we are running the new SQL2K5 engine.
> Anyone find a way of doing this now? Or will SQL2K5 remove these on its
> own
> if it does not need them any longer? Does not appear it removes them by
> itself based on the quantity of these hanging around.
> Thx!
> Ross Nornes
>|||We just use a simple query to generate the DROP scripts that we used to use
for SQL2K. I have included it below for review.
And yes, I'm the DBA so I'm logged in as SA on the box. Permissions should
not be an issue.
select
'drop statistics [' + object_name(i.id) + '].['+ i.name + ']'
from sysindexes i join
sysobjects o on i.id = o.id
where
i.name like '_wa%'
order by i.name
Thx!
Ross Nornes
"Andrew J. Kelly" wrote:

> How are you getting the list of statistics and are you sure the account do
es
> have the proper permissions to drop them?
> --
> Andrew J. Kelly SQL MVP
> "Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
> news:6353D60F-3201-492A-94F4-78309078D072@.microsoft.com...
>
>|||Ross,
I have seen that when the drop scrip was run in the context of master and
not the user db. But in any case you may want to use the new sys.stats view
instead.
SELECT 'drop statistics [' + object_name(i.[object_id]) + '].['+
i.[name] +
']'
FROM sys.stats as i
WHERE OBJECTPROPERTY(i.[object_id],'IsUserTable') = 1 AND i.[name] L
IKE
'_WA%'
ORDER BY i.name
Andrew J. Kelly SQL MVP
"Ross Nornes" <RossNornes@.discussions.microsoft.com> wrote in message
news:8F4B7751-D825-47F6-BB7B-A0B0C35D6105@.microsoft.com...[vbcol=seagreen]
> We just use a simple query to generate the DROP scripts that we used to
> use
> for SQL2K. I have included it below for review.
> And yes, I'm the DBA so I'm logged in as SA on the box. Permissions should
> not be an issue.
> select
> 'drop statistics [' + object_name(i.id) + '].['+ i.name + ']'
> from sysindexes i join
> sysobjects o on i.id = o.id
> where
> i.name like '_wa%'
> order by i.name
> Thx!
> Ross Nornes
> "Andrew J. Kelly" wrote:
>