1. Enable non-system administrators to execute the xp_cmdshell extended stored procedure in SQL Server 2000 as MS Article 8907752. Create a group and Grand exec xp_cmdshell permission to the group and add user to that group.
2005-04-26
Having rollback scripts for text-based objects like stored procedures, triggers, views is one thing (relatively easy) However, having rollback scripts for scripts that change structure, rearrange data, etc is entirely another. In my career, we never do this ahead of time, but only if there is a problem in rolling out the original structure change, […]
2005-03-31
Thanks.Changing option in EM/Mgmnt/server Agent/JobSystem worked ok!
2005-03-23
Yes and no. I am not a physicist and can't speak on the realative merits of Newton's and Lobachevsky's theories, so I won't attempt to. But you are correct when you say that the OODBMS design is trash. Why? Precisely because it isn't based on a defined, cogent theory at all. At least the hierarchical […]
2005-02-07
Comments posted to this topic are about the content posted at http://www.sqlsummit.com/People/MRys.htm
2004-12-28
Change the registry LoginMode to 2 will set SQL Server to mixed authentication mode. If you are lucky, the login "BUILTIN\Administrators" is stil there and you can then login with either domain or local administrator account.Can you run sp_helplogins and post result here? Don't rush to reinstall SQL Server.
2004-12-03
keep getting on Error messages on my package: (running on Windows Server 2000 SP4 & MS-SQL 2000 SP3)Context:Error calling open rowset on the provider... Error Source: Microsoft OLE DB Provider for ODBC Drivers funny... but it works fine from my Workstation (XP pro SP-1)any suggestion guys ?? thx for the attention
2004-11-28
29 reads
Merge replication keeps track of changes to published tables (articles) through metadata tables (triggers are created on each article and help to keep track of the changes you do). As you keep doing changes those tables will continue to increase. The tables I mention are MSmerge_contents, MSmerge_tombstone to mention just the most important ones.Merge replication […]
2004-11-13
Gary,For log shipping, the secondary server should be in read-only mode. There is nothing wrong with it. With you having mentioned that all the copy and restore jobs are successfully, i can't think of anything else. Can you verify that the loginhistory table is in the log shipped database ?
2004-09-22
I have a SQL DTS job that runs every night to populate the FaxList table of a publication with data from our Contact Management database. The job has failed recently because the Identity range is not large enough. The publication automatically gave the article a range of 5000. Currently there are 5010 records in the Contact management […]
2004-09-17
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers