Viewing 15 posts - 451 through 465 (of 479 total)
hmmm... interesting problem..
I like and have used may times option 4). the package can ve secured and you can run it any time via DTSRUN, or, batch it up...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 6, 2001 at 9:50 pm
Yep.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 6, 2001 at 2:33 am
Hi there, I had this problem yonks ago when going a bit of VB work.
Its something to do with when EOF gets initialised and its value...
try this:
a) Remove...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 6, 2001 at 2:31 am
Nice piece of code. Thanks for the post.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 6, 2001 at 2:24 am
Hi there
No it wasnt actually, and this is why it supprised me. It was a single massive query over 14 tables.
Cheers
Chris.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 3, 2001 at 9:19 pm
Andy
Hey there Andy, check this out from profiler...my table "aaaaa" didnt have identity enabled, then enabled it and got this:
CREATE TABLE dbo.Tmp_aaaaa
(
aaa int NOT NULL IDENTITY (1, 1),
bbb char(10)...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 30, 2001 at 9:26 pm
Hi all
Thanks for the replies. I had a closer look at the code. Basically the ADODB connection property (adoconnection.commandtimeout) default for query timeouts was returning 30secs, the report...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 30, 2001 at 1:46 am
Hi guys
Hmmm.. yeh, knew this one and wasnt what I was after . Basically I wanted to permanently remove IDENTITY from a column via an ALTER DATABASE statement. ...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 29, 2001 at 9:30 pm
Hi all
I am the same in that no one geting dbowner (dbo) access. Even in dev, i try and run a very strict shop with NO application schema changes...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 26, 2001 at 11:47 pm
"STILL allows the user to alter the name of the columns in a table, but they can alter the data types and other physical structures of the table. Altering the...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 26, 2001 at 5:04 am
Well Well.. more testing done.
Basically the
exec sp_droprolemember 'db_ddladmin', 'trs'
STILL allows the user to alter the name of the columns in a table, but they can alter the data types...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 26, 2001 at 5:03 am
Hi all
use mydb
go
exec sp_droprolemember 'db_ddladmin', 'myuser'
go
Does the trick.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 25, 2001 at 10:47 pm
Chris - excellent!
Most appreciated...
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 25, 2001 at 3:04 am
Hi
Yep, this is a problem alright. Check the EXECUTE function to run your dynamic SQL, there is a return value that you can check which may help you. ...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 24, 2001 at 11:10 pm
Andy
Fair call.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 22, 2001 at 9:52 pm
Viewing 15 posts - 451 through 465 (of 479 total)