2003-06-17
Storage
RE: Import DTS package with T-SQL
Hi, Yes you can execute structured storage file with DTSRUN utility. dtsrun /Ffilename /Npackage_name /Mpackage_password Regards Johnny
2003-06-13
1 reads
RE: Need a good Internet Mail Server
Another good free alternative could be 'Mercury' which is the complementary Mail Transport for the email client 'Pegasus Mail'. See . While I haven't used it in anger myself I did have a play with it some months back. Pegasus/Mercury is highly regarded software used extensively in UK Academic institutions due to it's support for […]
2003-05-27
RE: Rebuilding Indexes on System Tables
Ok, after a bit of research the only way to fix up the system tables is using sp_fixindex (or at least the code in the Proc). But you have to first set the DB into single user mode. Once done then you can affect the system indexes except for Sysobjects and Sysindexes (there is a […]
2003-05-20
RE: Procedure cache - recompile problem
Example script: set nocount on go if object_id('cache_test') is not null drop table cache_test go create table cache_test ( id int not null, descr varchar(30) not null, rowcreateddt datetime not null default getdate(), rowcreatedby varchar(30) not null default right(system_user,30), testcolumn varchar(30) null, primary key (id) ) go create trigger cache_test_update on cache_test for update as […]
2003-05-15
2 reads
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers