Viewing 15 posts - 511 through 525 (of 1,248 total)
The error indicates that you have nested level over 32 either or stored procedures, functions, ...
May the following links help.
http://forums.databasejournal.com/showthread.php?t=6805
http://www.sqlservercentral.com/articles/Basic+Querying/nestingstoredprocedures/998/
March 18, 2008 at 1:01 pm
I believe that their compatibilities should be consistent.
March 18, 2008 at 12:53 pm
It may be right or wrong.
Right:
If your virtual server does not have enough resource, your jobs may not be processed in time. As a result, you may have timeout...
March 18, 2008 at 12:32 pm
Move your master database files back;
Modify their paths from the server properties;
...
For detail, refer to the link below.
March 18, 2008 at 12:25 pm
How about the following one?
SELECT AM.OracleProjectId, P.OracleProjectId
FROM uAccountMovement AM
LEFT OUTER JOIN uProject P ON AM.OracleProjectId = P.OracleProjectId
WHERE P.OracleProjectId IS NULL
March 18, 2008 at 10:25 am
What if you add counter filters, say, CPU > 0?
March 18, 2008 at 10:18 am
If my understanding is correct, you would like to compare which is better, an ad hoc query or a stored procedure.
If so, adding your query in your stored procedure is...
March 18, 2008 at 10:15 am
If you are not a DBA, it is out of your control. But you can ask your DBA to set the security.
If my understanding is correct, you would not like...
March 18, 2008 at 9:57 am
I experienced the same problem. When I tried to connect to SSIS from the client tools, my only choice is the Windows Authentication. However, my loginID is my local account...
March 18, 2008 at 9:52 am
What do you mean the service account? Whether or not an account has permission to complete a DTS depends whether or not this account has authority to manage all related...
March 17, 2008 at 9:53 pm
If you would like to see whether or not there is any process running on your SQL Server, you may run
SELECT * FROM master..sys.sysprocesses
If you would like to see whether...
March 17, 2008 at 1:48 pm
In SQL Server, we can use sp_helpindex
In MySQL, you may try
mysql> SHOW INDEX FROM mytable FROM mydb
mysql> SHOW INDEX FROM mydb.mytabl
May them help.
March 17, 2008 at 1:28 pm
May the following discussion help.
http://en.allexperts.com/q/MS-SQL-Server-1801/O-error-bad-page.htm
March 17, 2008 at 1:13 pm
My understanding is that the NT AUTHORITY account can be used only on your local machine. Try to change the account used in your backup job to your account and...
March 17, 2008 at 1:08 pm
Viewing 15 posts - 511 through 525 (of 1,248 total)