Viewing 13 posts - 1 through 13 (of 13 total)
March 13, 2019 at 11:05 pm
You have to take into account, that this is the SQL Server database engine service account that must have the right to access this share. The account under which...
March 13, 2019 at 11:01 pm
YourSqlDba: There is a free maintenance tool that is described in the readme portion of this page at his adress. https://github.com/pelsql/YourSqlDba
It covers the five basic maintenance...
June 29, 2017 at 1:17 pm
This approach needs some more improvements. Updating all columns is problematic for trigger that test "if update()" because if there is no necessarily a real change. You put the...
May 23, 2009 at 10:35 am
I use the following strategy : At full backup time, two new file name are generated (including a timestamp in the name): one for full backups, one for log...
January 13, 2009 at 2:21 pm
Be careful how you grant your permissions, there is share permissions, and there is ntfs permissions. I got this problem some day because I forgot share permissions.
October 15, 2008 at 7:08 am
By checking more how index are created by my developers, if found that one method for index creation is setting page level locking...
April 30, 2007 at 9:59 am
The problem is that I have also this porblem that appears spuriously from differents index on my development box.
I suspect a bug in the...
April 30, 2007 at 9:25 am
Oups.. "as if the row hold more than 8096 bytes"
November 9, 2005 at 4:05 pm
You should specify that varchar(max) and nvarchar(max) are new features specific only to SQL2005 and that they make appears as if the row hold more that 8096 rows.
Varchar(max) and nvarchar(max)...
November 9, 2005 at 4:01 pm
Just try to do all this in one single batch. All theses statements can be put together in one single execute like this.
strSQL = "IF EXISTS (SELECT * FROM sysobjects...
July 29, 2005 at 3:01 pm
Well you should have a BUILIN/Administrators account defined. It is the default setup. You can add it by hand using as a standart user, and you must set it to...
July 18, 2005 at 1:57 pm
The problem is not really in the cursor itself. It is in the fact that operations are not set-oriented. Doing 1 million inserts is not the same at...
July 11, 2005 at 10:35 am