Viewing 15 posts - 3,271 through 3,285 (of 3,641 total)
I've tried running a SQL Trace on the MASTER and local database but cannot see any attempt to access the MASTER database.
I know that this is not conclusive because it...
March 23, 2004 at 1:39 am
The script doesn't switch to using TEMPDB. It simply references temporary tables.
CREATE TABLE #Tbl_Tree1(...etc)
INSERT #Tbl(... etc)
It is a shame that there isn't a global setting for SET NOCOUNT.
March 22, 2004 at 9:00 am
It is one long stored procedure. I am intending to break it out into smaller procedures later, but at this stage I am simply getting the procedure working.
What I am...
March 22, 2004 at 5:26 am
Sorry, half the post got lost for some reason.
It should have said that I have a stored procedure where SET NOCOUNT ON doesn't seem to work.
The procedure itterates down through...
March 22, 2004 at 1:28 am
I could be picky here and say that in addition to the "bouncing through the master database" thing having a different prefix for none Microsoft procedures aids identification.
Bert De Haes,...
March 22, 2004 at 1:23 am
Firstly you cannot TRUNCATE a table that has primary/foreign key relationships.
The only advantage to DROP/CREATE that I can see is that it takes care of situations where the source structure...
March 19, 2004 at 4:23 am
The problem I have with "how to program" type books is that at some stage there seems to be an example that is basically how to build a scribble or...
March 17, 2004 at 5:36 am
Given the importance of data in the corporate environment I think Microsoft have made a good call.
If YUKON is as big a jump forward as VS.NET then it will have...
March 12, 2004 at 4:36 am
This is assuming you have a reference to Microsoft Data Access Objects.
Public Sub sbRename()
Dim db As DAO.Database
Dim tb As DAO.TableDef
Set db =...
March 5, 2004 at 2:06 am
I have an MS Access database that is blank apart from standard utility functions that I always use.
One of the routines loops through the tabledefs collection and removes any dbo_...
March 5, 2004 at 1:28 am
INSERT won't delete records because the virtual table "inserted" contains the appended records, not the "deleted" table.
This strikes me as a Dilbert trigger. If anyone attempts to update records, punish...
March 5, 2004 at 1:17 am
I thought hotfix 8.00.818 which is supposed to be the SQL Slammer patch?
March 1, 2004 at 1:54 am
Yep,
They are an external (an theoretically neutral) department with no connection to the issues involved. Effectively they are for external verification that you raised an issue and it wasn't dealt...
February 27, 2004 at 5:08 am
Put down your issues in writing in unemotional language.
E-mail said issues to your boss and copy in your HR manager.
Keep a copy where you know you can get at it.
If...
February 27, 2004 at 3:11 am
Anyone remember EDLIN and the F6 key?
February 27, 2004 at 2:28 am
Viewing 15 posts - 3,271 through 3,285 (of 3,641 total)