What does it mean when a users is connected but it is a "non-trusted connection". This is showing up in the log file after my users connect. How does this effect the system/user? We have been experiencing speed issues and I was wondering if this might be a possible source of the problem.
Thanks in advance.A "trusted connection" is made using Windoze authentication. A "non-trusted connection" is made using SQL authentication. That is is the only difference that I know of between the two kinds of connections.
-PatP
Showing posts with label showing. Show all posts
Showing posts with label showing. Show all posts
Saturday, February 25, 2012
"Microsoft SQL Servers" not showing in Computer Management.
Hi there,
Got a small tech support problem. We gave our manual writer an installer
that should install SQL Server (MSDE) and our software. Over the phone I've
managed to ascertain that SQL Server is installed (it is running as a
service, along with SQL Server Agent), but it does not show up in "Computer
Management -> Services and Applications". I need to set the permissions for
this user (over the phone!) in order to get our test software to work and
yet it does not show here. What am I doing wrong? (and/or why would the
MSDE instance not show up here?).
Thanks,
RobinI sorted it :)
"Robin Tucker" <idontwanttobespammedanymore@.reallyidont.com> wrote in
message news:cq6ak0$fkg$1$8300dec7@.news.demon.co.uk...
> Hi there,
>
> Got a small tech support problem. We gave our manual writer an installer
> that should install SQL Server (MSDE) and our software. Over the phone
> I've managed to ascertain that SQL Server is installed (it is running as a
> service, along with SQL Server Agent), but it does not show up in
> "Computer Management -> Services and Applications". I need to set the
> permissions for this user (over the phone!) in order to get our test
> software to work and yet it does not show here. What am I doing wrong?
> (and/or why would the MSDE instance not show up here?).
> Thanks,
>
> Robin
Monday, February 13, 2012
"error 5180"
Hello we are running SQL 2000 sp 3 with the hotfixes. One of our server
showing this error and when I run dbcc checkdb I get errors regarding index.
I don't know what to do how to resolve. pls helpWhat is the error?
"Kiran" wrote:
> Hello we are running SQL 2000 sp 3 with the hotfixes. One of our server
> showing this error and when I run dbcc checkdb I get errors regarding index.
> I don't know what to do how to resolve. pls help
showing this error and when I run dbcc checkdb I get errors regarding index.
I don't know what to do how to resolve. pls helpWhat is the error?
"Kiran" wrote:
> Hello we are running SQL 2000 sp 3 with the hotfixes. One of our server
> showing this error and when I run dbcc checkdb I get errors regarding index.
> I don't know what to do how to resolve. pls help
"Display Dependencies" not showing all dependencies
Within Sql Server Enterprise, I click on an object to show dependencies, and
there is something I am not seeing here.
For example, I want to see all dependencies for a given table. It shows a
view and a couple of stored procedures that perform SELECT statements.
However, there is a stored procedure that performs UPDATE and INSERT against
that particular table, but I am not seeing on in the Display Dependencies
screen.
When I attempt to see the Dependencies screen on the stored procedure that
does UPDATE and INSERT, I am not seeing the table listed.
There seems to be a disconnect some place either in my head or in Enterprise
Manager. What am I missing? How can I display, all, I mean ALL
dependencies? For a given table, I want stored procedures listed if they do
ANYTHING on the table. And views. And functions. All dependencies,
period. How can I do that?
Because of deferred name resolution and other factors, then you won't
necessarily see all dependencies (e.g. depending on the order the objects
were created). I think one way to solve would be to recompile the stored
procedures, but I still don't think that will guarantee all dependencies
will show up... there are other things that aren't captured by sp_depends,
e.g. dynamic SQL.
http://www.aspfaq.com/
(Reverse address to reply.)
"David C" <nospam@.nospam.com> wrote in message
news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
> Within Sql Server Enterprise, I click on an object to show dependencies,
and
> there is something I am not seeing here.
> For example, I want to see all dependencies for a given table. It shows a
> view and a couple of stored procedures that perform SELECT statements.
> However, there is a stored procedure that performs UPDATE and INSERT
against
> that particular table, but I am not seeing on in the Display Dependencies
> screen.
> When I attempt to see the Dependencies screen on the stored procedure that
> does UPDATE and INSERT, I am not seeing the table listed.
> There seems to be a disconnect some place either in my head or in
Enterprise
> Manager. What am I missing? How can I display, all, I mean ALL
> dependencies? For a given table, I want stored procedures listed if they
do
> ANYTHING on the table. And views. And functions. All dependencies,
> period. How can I do that?
>
|||So do you have a suggestion?
I would like to re-engineer a table (changing a column type), so I need to
find all objects that talk to this table.
If "Display Dependencies" does not do what it's supposed to, then what
purpose does it serve other than giving partial answers?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uZaO$RYpEHA.1960@.TK2MSFTNGP10.phx.gbl...
> Because of deferred name resolution and other factors, then you won't
> necessarily see all dependencies (e.g. depending on the order the objects
> were created). I think one way to solve would be to recompile the stored
> procedures, but I still don't think that will guarantee all dependencies
> will show up... there are other things that aren't captured by sp_depends,
> e.g. dynamic SQL.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "David C" <nospam@.nospam.com> wrote in message
> news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
> and
> against
> Enterprise
> do
>
|||> If "Display Dependencies" does not do what it's supposed to, then what
> purpose does it serve other than giving partial answers?
In some scenarios, it does give the right answer (e.g. if you compile all of
your stored procedures after all their dependent objects have been created,
don't alter anything, and don't use dynamic SQL).
For all other scenarios, my only suggestion is to parse the text from
syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
And please remember, the people here are merely trying to help you. We did
not design SQL Server, have no control over the dependencies functionality,
and can't explain why they bothered putting it into the product.
http://www.aspfaq.com/
(Reverse address to reply.)
|||
> In some scenarios, it does give the right answer (e.g. if you compile all
> of
> your stored procedures after all their dependent objects have been
> created,
> don't alter anything, and don't use dynamic SQL).
>
How does one recompile all the stored procedures with one command? Is there
a way to do that? How about Views and User functions?
> For all other scenarios, my only suggestion is to parse the text from
> syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
> And please remember, the people here are merely trying to help you. We
> did
> not design SQL Server, have no control over the dependencies
> functionality,
> and can't explain why they bothered putting it into the product.
Your point is well taken.
|||> How does one recompile all the stored procedures with one command?
If you alter one table, do you have to recompile all stored procedures?
Unlikely.
> How does one recompile all the stored procedures with one command? Is
there
> a way to do that? How about Views and User functions?
This will generate the command for procs and functions, but not run it.
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+ROUTINE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+ROUTINE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
FROM
INFORMATION_SCHEMA.ROUTINES
For views,
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+TABLE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+TABLE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='view'
In both cases, use Query Analyzer with results to text. Run the code, and
copy the output from the bottom pane to the upper pane or a new window. You
may want to add filters to leave out system or other specific objects.
Keep in mind that this still does not guarantee that sp_depends or some GUI
red herring like "Display Dependencies" will work flawlessly, because of
other factors I mentioned earlier.
http://www.aspfaq.com/
(Reverse address to reply.)
there is something I am not seeing here.
For example, I want to see all dependencies for a given table. It shows a
view and a couple of stored procedures that perform SELECT statements.
However, there is a stored procedure that performs UPDATE and INSERT against
that particular table, but I am not seeing on in the Display Dependencies
screen.
When I attempt to see the Dependencies screen on the stored procedure that
does UPDATE and INSERT, I am not seeing the table listed.
There seems to be a disconnect some place either in my head or in Enterprise
Manager. What am I missing? How can I display, all, I mean ALL
dependencies? For a given table, I want stored procedures listed if they do
ANYTHING on the table. And views. And functions. All dependencies,
period. How can I do that?
Because of deferred name resolution and other factors, then you won't
necessarily see all dependencies (e.g. depending on the order the objects
were created). I think one way to solve would be to recompile the stored
procedures, but I still don't think that will guarantee all dependencies
will show up... there are other things that aren't captured by sp_depends,
e.g. dynamic SQL.
http://www.aspfaq.com/
(Reverse address to reply.)
"David C" <nospam@.nospam.com> wrote in message
news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
> Within Sql Server Enterprise, I click on an object to show dependencies,
and
> there is something I am not seeing here.
> For example, I want to see all dependencies for a given table. It shows a
> view and a couple of stored procedures that perform SELECT statements.
> However, there is a stored procedure that performs UPDATE and INSERT
against
> that particular table, but I am not seeing on in the Display Dependencies
> screen.
> When I attempt to see the Dependencies screen on the stored procedure that
> does UPDATE and INSERT, I am not seeing the table listed.
> There seems to be a disconnect some place either in my head or in
Enterprise
> Manager. What am I missing? How can I display, all, I mean ALL
> dependencies? For a given table, I want stored procedures listed if they
do
> ANYTHING on the table. And views. And functions. All dependencies,
> period. How can I do that?
>
|||So do you have a suggestion?
I would like to re-engineer a table (changing a column type), so I need to
find all objects that talk to this table.
If "Display Dependencies" does not do what it's supposed to, then what
purpose does it serve other than giving partial answers?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uZaO$RYpEHA.1960@.TK2MSFTNGP10.phx.gbl...
> Because of deferred name resolution and other factors, then you won't
> necessarily see all dependencies (e.g. depending on the order the objects
> were created). I think one way to solve would be to recompile the stored
> procedures, but I still don't think that will guarantee all dependencies
> will show up... there are other things that aren't captured by sp_depends,
> e.g. dynamic SQL.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "David C" <nospam@.nospam.com> wrote in message
> news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
> and
> against
> Enterprise
> do
>
|||> If "Display Dependencies" does not do what it's supposed to, then what
> purpose does it serve other than giving partial answers?
In some scenarios, it does give the right answer (e.g. if you compile all of
your stored procedures after all their dependent objects have been created,
don't alter anything, and don't use dynamic SQL).
For all other scenarios, my only suggestion is to parse the text from
syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
And please remember, the people here are merely trying to help you. We did
not design SQL Server, have no control over the dependencies functionality,
and can't explain why they bothered putting it into the product.
http://www.aspfaq.com/
(Reverse address to reply.)
|||
> In some scenarios, it does give the right answer (e.g. if you compile all
> of
> your stored procedures after all their dependent objects have been
> created,
> don't alter anything, and don't use dynamic SQL).
>
How does one recompile all the stored procedures with one command? Is there
a way to do that? How about Views and User functions?
> For all other scenarios, my only suggestion is to parse the text from
> syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
> And please remember, the people here are merely trying to help you. We
> did
> not design SQL Server, have no control over the dependencies
> functionality,
> and can't explain why they bothered putting it into the product.
Your point is well taken.
|||> How does one recompile all the stored procedures with one command?
If you alter one table, do you have to recompile all stored procedures?
Unlikely.
> How does one recompile all the stored procedures with one command? Is
there
> a way to do that? How about Views and User functions?
This will generate the command for procs and functions, but not run it.
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+ROUTINE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+ROUTINE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
FROM
INFORMATION_SCHEMA.ROUTINES
For views,
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+TABLE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+TABLE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='view'
In both cases, use Query Analyzer with results to text. Run the code, and
copy the output from the bottom pane to the upper pane or a new window. You
may want to add filters to leave out system or other specific objects.
Keep in mind that this still does not guarantee that sp_depends or some GUI
red herring like "Display Dependencies" will work flawlessly, because of
other factors I mentioned earlier.
http://www.aspfaq.com/
(Reverse address to reply.)
"Display Dependencies" not showing all dependencies
Within Sql Server Enterprise, I click on an object to show dependencies, and
there is something I am not seeing here.
For example, I want to see all dependencies for a given table. It shows a
view and a couple of stored procedures that perform SELECT statements.
However, there is a stored procedure that performs UPDATE and INSERT against
that particular table, but I am not seeing on in the Display Dependencies
screen.
When I attempt to see the Dependencies screen on the stored procedure that
does UPDATE and INSERT, I am not seeing the table listed.
There seems to be a disconnect some place either in my head or in Enterprise
Manager. What am I missing? How can I display, all, I mean ALL
dependencies? For a given table, I want stored procedures listed if they do
ANYTHING on the table. And views. And functions. All dependencies,
period. How can I do that?Because of deferred name resolution and other factors, then you won't
necessarily see all dependencies (e.g. depending on the order the objects
were created). I think one way to solve would be to recompile the stored
procedures, but I still don't think that will guarantee all dependencies
will show up... there are other things that aren't captured by sp_depends,
e.g. dynamic SQL.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"David C" <nospam@.nospam.com> wrote in message
news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
> Within Sql Server Enterprise, I click on an object to show dependencies,
and
> there is something I am not seeing here.
> For example, I want to see all dependencies for a given table. It shows a
> view and a couple of stored procedures that perform SELECT statements.
> However, there is a stored procedure that performs UPDATE and INSERT
against
> that particular table, but I am not seeing on in the Display Dependencies
> screen.
> When I attempt to see the Dependencies screen on the stored procedure that
> does UPDATE and INSERT, I am not seeing the table listed.
> There seems to be a disconnect some place either in my head or in
Enterprise
> Manager. What am I missing? How can I display, all, I mean ALL
> dependencies? For a given table, I want stored procedures listed if they
do
> ANYTHING on the table. And views. And functions. All dependencies,
> period. How can I do that?
>|||So do you have a suggestion?
I would like to re-engineer a table (changing a column type), so I need to
find all objects that talk to this table.
If "Display Dependencies" does not do what it's supposed to, then what
purpose does it serve other than giving partial answers?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uZaO$RYpEHA.1960@.TK2MSFTNGP10.phx.gbl...
> Because of deferred name resolution and other factors, then you won't
> necessarily see all dependencies (e.g. depending on the order the objects
> were created). I think one way to solve would be to recompile the stored
> procedures, but I still don't think that will guarantee all dependencies
> will show up... there are other things that aren't captured by sp_depends,
> e.g. dynamic SQL.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "David C" <nospam@.nospam.com> wrote in message
> news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
>> Within Sql Server Enterprise, I click on an object to show dependencies,
> and
>> there is something I am not seeing here.
>> For example, I want to see all dependencies for a given table. It shows
>> a
>> view and a couple of stored procedures that perform SELECT statements.
>> However, there is a stored procedure that performs UPDATE and INSERT
> against
>> that particular table, but I am not seeing on in the Display Dependencies
>> screen.
>> When I attempt to see the Dependencies screen on the stored procedure
>> that
>> does UPDATE and INSERT, I am not seeing the table listed.
>> There seems to be a disconnect some place either in my head or in
> Enterprise
>> Manager. What am I missing? How can I display, all, I mean ALL
>> dependencies? For a given table, I want stored procedures listed if they
> do
>> ANYTHING on the table. And views. And functions. All dependencies,
>> period. How can I do that?
>>
>|||> If "Display Dependencies" does not do what it's supposed to, then what
> purpose does it serve other than giving partial answers?
In some scenarios, it does give the right answer (e.g. if you compile all of
your stored procedures after all their dependent objects have been created,
don't alter anything, and don't use dynamic SQL).
For all other scenarios, my only suggestion is to parse the text from
syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
And please remember, the people here are merely trying to help you. We did
not design SQL Server, have no control over the dependencies functionality,
and can't explain why they bothered putting it into the product.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||> In some scenarios, it does give the right answer (e.g. if you compile all
> of
> your stored procedures after all their dependent objects have been
> created,
> don't alter anything, and don't use dynamic SQL).
>
How does one recompile all the stored procedures with one command? Is there
a way to do that? How about Views and User functions?
> For all other scenarios, my only suggestion is to parse the text from
> syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
> And please remember, the people here are merely trying to help you. We
> did
> not design SQL Server, have no control over the dependencies
> functionality,
> and can't explain why they bothered putting it into the product.
Your point is well taken.|||> How does one recompile all the stored procedures with one command?
If you alter one table, do you have to recompile all stored procedures?
Unlikely.
> How does one recompile all the stored procedures with one command? Is
there
> a way to do that? How about Views and User functions?
This will generate the command for procs and functions, but not run it.
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+ROUTINE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+ROUTINE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
FROM
INFORMATION_SCHEMA.ROUTINES
For views,
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+TABLE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+TABLE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='view'
In both cases, use Query Analyzer with results to text. Run the code, and
copy the output from the bottom pane to the upper pane or a new window. You
may want to add filters to leave out system or other specific objects.
Keep in mind that this still does not guarantee that sp_depends or some GUI
red herring like "Display Dependencies" will work flawlessly, because of
other factors I mentioned earlier.
--
http://www.aspfaq.com/
(Reverse address to reply.)
there is something I am not seeing here.
For example, I want to see all dependencies for a given table. It shows a
view and a couple of stored procedures that perform SELECT statements.
However, there is a stored procedure that performs UPDATE and INSERT against
that particular table, but I am not seeing on in the Display Dependencies
screen.
When I attempt to see the Dependencies screen on the stored procedure that
does UPDATE and INSERT, I am not seeing the table listed.
There seems to be a disconnect some place either in my head or in Enterprise
Manager. What am I missing? How can I display, all, I mean ALL
dependencies? For a given table, I want stored procedures listed if they do
ANYTHING on the table. And views. And functions. All dependencies,
period. How can I do that?Because of deferred name resolution and other factors, then you won't
necessarily see all dependencies (e.g. depending on the order the objects
were created). I think one way to solve would be to recompile the stored
procedures, but I still don't think that will guarantee all dependencies
will show up... there are other things that aren't captured by sp_depends,
e.g. dynamic SQL.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"David C" <nospam@.nospam.com> wrote in message
news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
> Within Sql Server Enterprise, I click on an object to show dependencies,
and
> there is something I am not seeing here.
> For example, I want to see all dependencies for a given table. It shows a
> view and a couple of stored procedures that perform SELECT statements.
> However, there is a stored procedure that performs UPDATE and INSERT
against
> that particular table, but I am not seeing on in the Display Dependencies
> screen.
> When I attempt to see the Dependencies screen on the stored procedure that
> does UPDATE and INSERT, I am not seeing the table listed.
> There seems to be a disconnect some place either in my head or in
Enterprise
> Manager. What am I missing? How can I display, all, I mean ALL
> dependencies? For a given table, I want stored procedures listed if they
do
> ANYTHING on the table. And views. And functions. All dependencies,
> period. How can I do that?
>|||So do you have a suggestion?
I would like to re-engineer a table (changing a column type), so I need to
find all objects that talk to this table.
If "Display Dependencies" does not do what it's supposed to, then what
purpose does it serve other than giving partial answers?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uZaO$RYpEHA.1960@.TK2MSFTNGP10.phx.gbl...
> Because of deferred name resolution and other factors, then you won't
> necessarily see all dependencies (e.g. depending on the order the objects
> were created). I think one way to solve would be to recompile the stored
> procedures, but I still don't think that will guarantee all dependencies
> will show up... there are other things that aren't captured by sp_depends,
> e.g. dynamic SQL.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "David C" <nospam@.nospam.com> wrote in message
> news:0oh6d.21182$OB2.1947@.twister.socal.rr.com...
>> Within Sql Server Enterprise, I click on an object to show dependencies,
> and
>> there is something I am not seeing here.
>> For example, I want to see all dependencies for a given table. It shows
>> a
>> view and a couple of stored procedures that perform SELECT statements.
>> However, there is a stored procedure that performs UPDATE and INSERT
> against
>> that particular table, but I am not seeing on in the Display Dependencies
>> screen.
>> When I attempt to see the Dependencies screen on the stored procedure
>> that
>> does UPDATE and INSERT, I am not seeing the table listed.
>> There seems to be a disconnect some place either in my head or in
> Enterprise
>> Manager. What am I missing? How can I display, all, I mean ALL
>> dependencies? For a given table, I want stored procedures listed if they
> do
>> ANYTHING on the table. And views. And functions. All dependencies,
>> period. How can I do that?
>>
>|||> If "Display Dependencies" does not do what it's supposed to, then what
> purpose does it serve other than giving partial answers?
In some scenarios, it does give the right answer (e.g. if you compile all of
your stored procedures after all their dependent objects have been created,
don't alter anything, and don't use dynamic SQL).
For all other scenarios, my only suggestion is to parse the text from
syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
And please remember, the people here are merely trying to help you. We did
not design SQL Server, have no control over the dependencies functionality,
and can't explain why they bothered putting it into the product.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||> In some scenarios, it does give the right answer (e.g. if you compile all
> of
> your stored procedures after all their dependent objects have been
> created,
> don't alter anything, and don't use dynamic SQL).
>
How does one recompile all the stored procedures with one command? Is there
a way to do that? How about Views and User functions?
> For all other scenarios, my only suggestion is to parse the text from
> syscomments or INFORMATION_SCHEMA.ROUTINES for the name of your table.
> And please remember, the people here are merely trying to help you. We
> did
> not design SQL Server, have no control over the dependencies
> functionality,
> and can't explain why they bothered putting it into the product.
Your point is well taken.|||> How does one recompile all the stored procedures with one command?
If you alter one table, do you have to recompile all stored procedures?
Unlikely.
> How does one recompile all the stored procedures with one command? Is
there
> a way to do that? How about Views and User functions?
This will generate the command for procs and functions, but not run it.
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+ROUTINE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+ROUTINE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
FROM
INFORMATION_SCHEMA.ROUTINES
For views,
SELECT
CHAR(13)+CHAR(10)+'EXEC sp_recompile '''+TABLE_NAME+''';'
+CHAR(13)+CHAR(10)+'EXEC '+TABLE_NAME+';'
+CHAR(13)+CHAR(10)+'GO;'
INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='view'
In both cases, use Query Analyzer with results to text. Run the code, and
copy the output from the bottom pane to the upper pane or a new window. You
may want to add filters to leave out system or other specific objects.
Keep in mind that this still does not guarantee that sp_depends or some GUI
red herring like "Display Dependencies" will work flawlessly, because of
other factors I mentioned earlier.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Disk full"
I am running Windows 2000 professional, we are showing the entire drive
is full( 30gig). I suspect it is in system backups. Any ideas?Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running Windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running Windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.|||thanks, I'll look at that.
is full( 30gig). I suspect it is in system backups. Any ideas?Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running Windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running Windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.|||thanks, I'll look at that.
"Disk full"
I am running windows 2000 professional, we are showing the entire drive
is full( 30gig). I suspect it is in system backups. Any ideas?Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.|||thanks, I'll look at that.
is full( 30gig). I suspect it is in system backups. Any ideas?Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegroups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.|||thanks, I'll look at that.
"Disk full"
I am running windows 2000 professional, we are showing the entire drive
is full( 30gig). I suspect it is in system backups. Any ideas?
Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegro ups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>
|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegro ups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>
|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.
|||thanks, I'll look at that.
is full( 30gig). I suspect it is in system backups. Any ideas?
Hi
This will depend on the machine and what it is used for e.g. your cached
internet files could be huge or temporary files could be cluttering up the
system.
If you used Windows Explorer to seach the drive you can then order the files
by size.
John
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegro ups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>
|||Also take a look at the size of your DB (mdf,ndf) and Log files (ldf)
you can use the following below to find out
sp_spaceused
DBCC SQLPERF ( LOGSPACE )
<austx@.ev1.net> wrote in message
news:1136735870.520313.12800@.g44g2000cwa.googlegro ups.com...
>I am running windows 2000 professional, we are showing the entire drive
> is full( 30gig). I suspect it is in system backups. Any ideas?
>
|||Install a program called "Treesize" and use it to scan your hard drves,
that way you will be able to see the biggest folders and you can
manually check why and delete the files that use most of the space and
are not needed.
Hope it helps.
|||thanks, I'll look at that.
Saturday, February 11, 2012
"Data-Driven Subscription" Not Showing
Hi,
Just a follow-up on my earlier email.
I have Reporting Services 2000 installed on Small Business Server for
Windows 2003.
I am logged on as admistrator and all permissions for Content Manager ans
System Admistrator are in place
When I Go To Subscriptions in Report Manager, "New Subscription" option only
shows.
I know that there should be a "New Data-Driven Subscription" option showing
right next to this.
But it just does not show. Does nayone know why this is not the case.
Does this appear only with SQL Reporting Services 2000 Service Pack 1 only?
Or is some option that needs to be ticked off somehwere for this to show.
Does anyone know why this option just will now show?
Thanks
SanjeevWhen I looked into the same problem, I was told that Data Driven
Subscriptions are only available with the Enterprise Edition of SQL Server.
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:uh1UhJX%23FHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Just a follow-up on my earlier email.
> I have Reporting Services 2000 installed on Small Business Server for
> Windows 2003.
> I am logged on as admistrator and all permissions for Content Manager ans
> System Admistrator are in place
> When I Go To Subscriptions in Report Manager, "New Subscription" option
> only shows.
> I know that there should be a "New Data-Driven Subscription" option
> showing right next to this.
> But it just does not show. Does nayone know why this is not the case.
> Does this appear only with SQL Reporting Services 2000 Service Pack 1
> only?
> Or is some option that needs to be ticked off somehwere for this to show.
> Does anyone know why this option just will now show?
> Thanks
> Sanjeev
>|||Thanks for the assist Susan.
Did you ever try using Enterprise Edition to see if that solved the problem
Sanjeev
"Susan" <sfischer@.csg-llc.com> wrote in message
news:%230EDmmb%23FHA.2040@.TK2MSFTNGP14.phx.gbl...
> When I looked into the same problem, I was told that Data Driven
> Subscriptions are only available with the Enterprise Edition of SQL
> Server.
>
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:uh1UhJX%23FHA.1988@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> Just a follow-up on my earlier email.
>> I have Reporting Services 2000 installed on Small Business Server for
>> Windows 2003.
>> I am logged on as admistrator and all permissions for Content Manager ans
>> System Admistrator are in place
>> When I Go To Subscriptions in Report Manager, "New Subscription" option
>> only shows.
>> I know that there should be a "New Data-Driven Subscription" option
>> showing right next to this.
>> But it just does not show. Does nayone know why this is not the case.
>> Does this appear only with SQL Reporting Services 2000 Service Pack 1
>> only?
>> Or is some option that needs to be ticked off somehwere for this to show.
>> Does anyone know why this option just will now show?
>> Thanks
>> Sanjeev
>>
>
Just a follow-up on my earlier email.
I have Reporting Services 2000 installed on Small Business Server for
Windows 2003.
I am logged on as admistrator and all permissions for Content Manager ans
System Admistrator are in place
When I Go To Subscriptions in Report Manager, "New Subscription" option only
shows.
I know that there should be a "New Data-Driven Subscription" option showing
right next to this.
But it just does not show. Does nayone know why this is not the case.
Does this appear only with SQL Reporting Services 2000 Service Pack 1 only?
Or is some option that needs to be ticked off somehwere for this to show.
Does anyone know why this option just will now show?
Thanks
SanjeevWhen I looked into the same problem, I was told that Data Driven
Subscriptions are only available with the Enterprise Edition of SQL Server.
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:uh1UhJX%23FHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Just a follow-up on my earlier email.
> I have Reporting Services 2000 installed on Small Business Server for
> Windows 2003.
> I am logged on as admistrator and all permissions for Content Manager ans
> System Admistrator are in place
> When I Go To Subscriptions in Report Manager, "New Subscription" option
> only shows.
> I know that there should be a "New Data-Driven Subscription" option
> showing right next to this.
> But it just does not show. Does nayone know why this is not the case.
> Does this appear only with SQL Reporting Services 2000 Service Pack 1
> only?
> Or is some option that needs to be ticked off somehwere for this to show.
> Does anyone know why this option just will now show?
> Thanks
> Sanjeev
>|||Thanks for the assist Susan.
Did you ever try using Enterprise Edition to see if that solved the problem
Sanjeev
"Susan" <sfischer@.csg-llc.com> wrote in message
news:%230EDmmb%23FHA.2040@.TK2MSFTNGP14.phx.gbl...
> When I looked into the same problem, I was told that Data Driven
> Subscriptions are only available with the Enterprise Edition of SQL
> Server.
>
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:uh1UhJX%23FHA.1988@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> Just a follow-up on my earlier email.
>> I have Reporting Services 2000 installed on Small Business Server for
>> Windows 2003.
>> I am logged on as admistrator and all permissions for Content Manager ans
>> System Admistrator are in place
>> When I Go To Subscriptions in Report Manager, "New Subscription" option
>> only shows.
>> I know that there should be a "New Data-Driven Subscription" option
>> showing right next to this.
>> But it just does not show. Does nayone know why this is not the case.
>> Does this appear only with SQL Reporting Services 2000 Service Pack 1
>> only?
>> Or is some option that needs to be ticked off somehwere for this to show.
>> Does anyone know why this option just will now show?
>> Thanks
>> Sanjeev
>>
>
Subscribe to:
Posts (Atom)
