I am using SQL7SP2 on NT4SP5. I have a database where one of the tables should be strictly read only as the data in it is static except for a monthly load. There are over 80 million rows currently in this table. The table and it's indexes are in their own filegroup - say called […]
2001-10-24
1 reads
I'm trying to do the following: 1) If there is an error inside a transaction, rollback and return -1 2) If the error is outside the transaction, just return -1 3) Is there anything in SQL similar to On Error goto errh: 4) Ideally I would like to store the error details in log table. […]
2001-10-17
3 reads
The following is stored procedure that causing problems. When I run the sp it takes about 2 minutes to execute but when I copy the same code into Query Analyzer it runs in about 1-3 seconds. Even when I go back and forth between the sp and the code it consistantly takes about the same […]
2001-10-15
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Raj Gill
2001-10-14
5 reads
I have a DB and the final size will be 100GB one year later, it need to be replicated. Which replication log shipping, transactional replication or any other is better? Thanks.
2001-10-13
4 reads
I want to dump a list of the dts's that we have created, what table is this data stored in?? Steve Johnson
2001-09-25
5 reads
Comments posted to this topic are about the content posted at http://support.microsoft.com/support/kb/articles/Q281/8/79.ASP?LN=EN-US&SD=msdn&FR=0
2001-09-12
6 reads
I'm posted this question to every newsgroup I know but without any satisfactory response. As you know, EXECUTE on xp_cmdShell can be granted to anyone. I tried sp_helprotect xp_cmdShell to know all the people granted EXECUTE on it But this always gives a blank response Just try this 1) Create a new login 2) Do […]
2001-09-10
3 reads
Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman
2001-09-05
2 reads
Any opinions on the best way to achieve two-way ftp transfers from within a Stored Proc? DTS is of no use as it only goes one way We have used the 'build a batch file to use the built-in ftp, then execute it with xp_cmdshell' but it's a bit messy Has anyone used a CLI […]
2001-08-29
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