Viewing 15 posts - 4,171 through 4,185 (of 7,429 total)
When a view is first saved it stored the column names in syscolumns.
To see this type
select * from syscolumns where [id] = object_id('my_view')
and you will see * is converted to...
November 25, 2002 at 11:13 am
The prerquiste to installing SQL should match the minimum version of IE needed. Taskpad uses dynamic hmtl and scripting so if the version doesn't match you get the error. You...
November 25, 2002 at 11:07 am
Also, when looking in sysindexes the StatVersion is 0 for indexes and 1 for stats and impid should be 0 there are some that are -1 that are not...
November 25, 2002 at 11:02 am
Yes, I put this into the MS folks as I hear there may be some documentation updates in the upcoming in SP3. Hopefully this is true and they can get...
November 25, 2002 at 10:51 am
Found this in another thread and has some good company listings and what they are doing with SQL. Case studies.
http://www.microsoft.com/sql/evaluation/casestudies/alphalisting.asp
November 25, 2002 at 10:48 am
Sorry, I usually use the SQL Backup process to tape. Where we are forced to use Veritas we use SQL Backup to disk file then Veritas, I am not sure...
November 25, 2002 at 10:44 am
Verify you file does not have any unexpected garbage, bad delimiter in a spot or unexpected end of file by a gap in the data.
Run several times, sometimes the messages...
November 25, 2002 at 5:45 am
Could be a permissions thing. Was this a clean install or a resotre or attach from an old install? What type of account were you logged into when it happened....
November 25, 2002 at 5:44 am
If you completely lost the master and have only a backup then you will have to do a reinstall. Then you will need to start the new install in single...
November 25, 2002 at 5:39 am
My understanding is that most of the large SQL transactions in Oracle use Cursors in processing under the hood.
November 25, 2002 at 5:37 am
You need the -c option also.
From BOL
quote:
How to start the default instance of SQL Server in single-user mode (Command Prompt)To start...
November 25, 2002 at 5:35 am
Guess my information is outdated, this was the case for older servers at one time, got to looking and see the new controllers should work fine. However, as I was...
November 25, 2002 at 5:33 am
Where did you get the <...> taht is usally one way of denoting paremeters to use in example code. But mostly you don't see them use NULL but instead...
November 25, 2002 at 4:57 am
Make sure Print and File Sharing is enabled.
November 25, 2002 at 4:53 am
EnumProcesses method of the SQLServer object will list them. See BOL for more details.
November 25, 2002 at 4:44 am
Viewing 15 posts - 4,171 through 4,185 (of 7,429 total)