Viewing 15 posts - 2,221 through 2,235 (of 2,387 total)
Your 'va2' is depend on 'va' that depends on 'ta'. If there are any changes in either 'ta' or 'va', you have to refresh 'va2' too.
February 12, 2003 at 7:59 am
It can come from Vendor's applications, Microsoft Office 2000 etc.
You can use Microsoft tools to scan all you MSDE 2000 instances.
http://www.microsoft.com/security/slammer.asp
Edited by - Allen_Cui on 02/11/2003 1:06:29 PM
February 11, 2003 at 1:06 pm
In order to update view that has more than one base tables, you have to create partitioned view and there are rules for update a patitioned view. See BOL for...
February 11, 2003 at 10:32 am
I don't remember whether machine has to be restarted. Try to restart MSSearch and SQL Server services.
February 11, 2003 at 9:53 am
Have you tried to select columns you need instead of everything (*).
Information below may help you too. That is from BOL.
"Using text, ntext, and image Data in INSTEAD OF Triggers
Data...
February 11, 2003 at 7:28 am
It is 'local system account' to run Microsoft Search service that has to access SQL Server.
As long as you remove 'BUILTIN\Administrators' from SQL Server logins, Those people with NT...
February 10, 2003 at 1:17 pm
Check your NT administrator to see any security policy changes to the local system account in this server too.
February 10, 2003 at 10:09 am
From EM, Go to security --> Linked Servers and right click the linked server --> property --> Server Option Tab --> Enable server access option.
February 10, 2003 at 9:34 am
If you did remove BUILTIN\Administrators account, you have to grant 'Nt Authority\System' account to access SQL Server with 'sa' right.
February 10, 2003 at 9:26 am
How did you restore the database? If you did not specify the "with norecovery" option when you restored the full database, your database had been alreay recovered.
February 7, 2003 at 1:51 pm
Don't see benefits by place those lookup tables in separate database. It will create more issues in system maintenance, administration and operations. For example, if you have problem to bring...
February 7, 2003 at 9:46 am
Have you considered about Updatable Partitioned View?
February 6, 2003 at 2:12 pm
I don't see it is possible. They have to be member of db_owner at least.
February 6, 2003 at 12:35 pm
Update statistics for that table and check from EM again.
For examplr, UPDATE STATISTICS authors
Edited by - Allen_Cui on 02/06/2003 10:06:49 AM
February 6, 2003 at 10:05 am
Viewing 15 posts - 2,221 through 2,235 (of 2,387 total)