Viewing 15 posts - 1,291 through 1,305 (of 1,412 total)
I don't know any way either, but you could of course limit what the user can do/see by setting (restrincting) permissions for him in the db accordingly. He will of...
October 10, 2002 at 6:19 am
Have you got AWE enabled? If you do, is it configured for a max memory? If it is not then it will use up to Total memory - 180 MB...
October 10, 2002 at 1:35 am
If it's a security related hot fix, I'd say that it's imortant to patch all servers. Biggest security issue is inside, not outside, and there are several major flaws in...
October 9, 2002 at 4:00 pm
I'd say that depends on you, or rather your customer.
Is it OK to have the risk of getting 'incorrect' data? Even if the risk is minimal,...
October 9, 2002 at 3:50 pm
Hmm... sorry for me being blind, I just spotted the problem. sp_executesql executes it's statements in a separate batch, so therefore scope_identity() will return null as there haven't been any...
October 9, 2002 at 9:40 am
quote:
Assuming the column's data will allow a unique constraint.
If it doesn't, the design is not...
October 9, 2002 at 9:37 am
You can create a .BAT-file that executes them all using osql.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
October 9, 2002 at 9:28 am
Just add a TOP 150. Either to the select-statement calling the view, or in the select-statement that is the view.
SELECT TOP 150 * FROM CPDB
or
Create View CPDB
AS
SELECT TOP 150
dbo.CPDB_View.pupsn...
October 9, 2002 at 8:37 am
As antares said, you can use Crystal Reports for creating reports, among other tools.
Using XML is of course a good alternative. Just add FOR XML AUTO to your selects, or...
October 9, 2002 at 8:19 am
No, what I meant was if you execute these statements from your VB application as a single batch, or as several statements executed after each other, one by one. What...
October 9, 2002 at 8:15 am
Are you logged on as the same user that your application uses? Maybe you don't have permissions to it.
Who is the owner of the table?
--
Chris Hedgate @ Apptus Technologies (
October 9, 2002 at 7:51 am
October 9, 2002 at 7:48 am
I can also confirm this, running SQL Server 2000 Ent Ed SP2, MDAC 2.7 on client. I profiled what was going on and it is the entire statement that is...
October 9, 2002 at 4:24 am
quote:
As for triggers on system tables. This is a bad practice and should be avoided.
Yes,...
October 9, 2002 at 1:16 am
select groupid from sysindexes where name = 'yourtable'
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
October 9, 2002 at 1:14 am
Viewing 15 posts - 1,291 through 1,305 (of 1,412 total)