Viewing 15 posts - 226 through 240 (of 1,132 total)
"Error Message: Maximum stored procedure, function, trigger, or view
nesting level exceeded (limit 32)."
As each stored procedure or trigger is invoked, the "nest level" is increased by one and SQL Server...
May 31, 2009 at 5:21 pm
The rules for the schema appear to be:
A task is a "master" task when the "AssoId" is NULL
A Sub-Task of a master task is identified by the constant "s" preceeding...
May 31, 2009 at 11:03 am
You can customize the action to be taken by a hot-key including removing the association.
From the menu, pick "tools" , "customize" and then the "keyboard" tab. From the list,...
May 31, 2009 at 9:49 am
If all of the user databases are in full recovery mode, then full backups could be made earlier (starting at 6PM?), and then at 7 PM, only transaction log backups...
May 30, 2009 at 7:57 am
Below are three sets of SQL statements that show that when an index is rebuilt or all indexes on a table are rebuilt, column statistics not associated with the indexes...
May 28, 2009 at 6:35 pm
How about "Value Added" ? Which actually means "we only do those activities that we are obligated to perform based on the contract"
With my collegues, I also...
May 27, 2009 at 8:03 am
Utopia - Also in a software perspective (We are progressing our software to a utopia)
What makes that buzzword extremely funny is that Utopia means "no where" :-D. Origin is...
May 27, 2009 at 7:59 am
Error 7884 is an invalid network packet, so check out the NICs to insure that
the latest drivers are installed and that "link speed & duplex" are a fixed value...
May 24, 2009 at 7:29 am
1. Would I need a new virtual name and virtual ip for the new instance?
Yes
2. I have a separate lun allocated for the new instance, does it need to be...
May 24, 2009 at 6:59 am
Found that a state of 3 means "maximum user connections exceeded" and the value can be checked by running
exec sp_configure 'user connections'
May 21, 2009 at 12:26 pm
User Debbie.Smith that exists in group [IT-ABC Production Infastructure Users] can not log in and work. It either gives her a connection failed SQLState: 28000 sql server error 18456 error....
May 21, 2009 at 12:12 pm
Login names are stored as NVARCHAR(128) , so that is probably not the problem.
There could be a problem when the following occurs:
1. An AD Group is created
2. The...
May 21, 2009 at 9:54 am
There is the possibility that the AD Account is in more than one AD Group, which can create a problem. You can get the AD groups with this SQL
exec...
May 20, 2009 at 6:29 pm
Possibly a SQL Parser problem along with an implicit datatype conversion
SELECT 1.1Number11
Which has results with a column name of "Number11" having a numeric value of "1.1"
Looks like the...
May 20, 2009 at 11:41 am
This problem can be caused by a 3rd-party file encryption solution or if NTFS compression is being used.
Also see http://support.microsoft.com/kb/926070
Error messages may be logged in the SQL Server error log...
May 19, 2009 at 8:56 am
Viewing 15 posts - 226 through 240 (of 1,132 total)