Viewing 15 posts - 6,676 through 6,690 (of 7,429 total)
Sorry about that sysporperties is correct. Having a murphy day here. ANyway you should learn to use the function thou as MS states system changes can change between versions but...
March 25, 2002 at 11:15 am
As far as I know these numbers are just sequence numbers and are generated like UIDs. However I do not have any idea at this point how they are created...
March 25, 2002 at 6:13 am
You could look at the syscomments table for the data or use the preferred fn_listextendedproperty which works but takes a bit to use, check out BOL for more information.
"Don't roll...
March 25, 2002 at 5:44 am
I think Andy is referring to the following KB Article on Microsofts site.
Which you state you have SP3 and this should have fixed. You could have had issues though with...
March 25, 2002 at 5:42 am
Also I would do a trace on all the stages of the transactions from start to complete and see if a specific step is occurring when this happens since you...
March 25, 2002 at 5:37 am
Or for that fact your spouse direct access to the family budget, they mut go thru you and you only return the stuff you want them to know.
"Don't roll...
March 25, 2002 at 5:32 am
Although yes not earth shattering it did contain usefull information for those who have come across the same type of problem and presented a function that can be quite handy.
"Don't...
March 25, 2002 at 5:29 am
I believe you should be able to but have never tried myself so I cannot be 100% it does. I believe if you do a search on syslogins and sysxlogins...
March 25, 2002 at 5:17 am
Put the data in a Global temp table and B will be able to see as well as any other process. Or create a physical table thru A and allow...
March 25, 2002 at 5:00 am
If you are saying you need to limit the query performed when someone does
SELECT * FROM myView
Then you will need to add the o.[Name] AS TableName in you views output...
March 23, 2002 at 6:52 am
Hey argyle can you point me to a document on this, I have neve seen this occurr and am curious how this occurrs.
"Don't roll your eyes at me. I will...
March 23, 2002 at 6:45 am
Intel's anypoint home network is 1.6mb transmitted. But this was the first version and is hard to find anywhere other than compusa and ebay, the new version may be a...
March 23, 2002 at 6:42 am
I changed nothing just extended the number of rows that would output with all fields with data.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
March 23, 2002 at 6:33 am
From BOL
quote:
Setting the SET ROWCOUNT option causes most Transact-SQL statements to stop processing when they have been affected by the...
March 23, 2002 at 6:29 am
Check out Use DELETE On Many Tables With Foreign Keys here at http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=220, I have not tried but it is supposed to so the job.
"Don't roll your eyes at me....
March 22, 2002 at 1:19 pm
Viewing 15 posts - 6,676 through 6,690 (of 7,429 total)