Hi All, We are coming up with a OLTP kin of application. To start with we are little concerned upon how to handle errors (hope in the next version sql server will come with exceptions in line with oracle). Two ways we thought of is 1. After every dml statement check for errornum and have […]
2001-12-19
1 reads
Comments posted to this topic are about the content posted at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/default.asp
2001-12-16
1 reads
Hi, I've tried whatever I know, if anyone can help me on this it would be really very helpful. The application is related to web server hits reporting. The platform is asp/vb/sql2000/win 2k. The main database consists of the records from the Web Server Log files and it grows at 0.1 million records per day. […]
2001-12-08
6 reads
This document introduces the new security features of Microsoft SQL Server 2000. New features are outlined, and a detailed discussion is provided about how to best implement security in a Microsoft Windows 2000 domain environment. Source code examples are included for developers who want to implement the security model immediately.
2001-12-06
1,547 reads
what is a standard locking mechanism in sql server 2000? is it a pagelock or a rowlock ? and if i access sql server from client side application ( like vb ), what locking mechanism it's used? because as far as i know the lowest locking mechanism in vb is pagelock
2001-12-04
3 reads
One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?
2001-12-04
6,221 reads
This past week, a worm virus began to attack SQL Servers on the internet that hold a blank password. Read some of the details about what this virus can do here.
2001-12-03
13,204 reads
I am trying to export a recordset to excel, change or copy the excel file to a new file, and then email this result to a group of users. I am using a vbscript task to execute the file copy (changing the name). The problem I am having is that the excel file is locked […]
2001-11-30
4 reads
Hi all, We use SQL 7.0 and I have a good understanding of DTS but I would love to know where I can learn more. I'm looking for any recommendations of books, etc. to find out how to edit existing jobs and learn about the different features of DTS jobs. Thanks in advance, Kevin ------------------ […]
2001-11-29
2 reads
Hi all, I hope someone can help. I have a Sql Server 6.5 Database that i need to shrink. It currently has a total size of 2200 MB 2000MB data and 200MB Logs. it is reporting 1432MB avalible for data. however when i try to shrink this it is reporting a minimum size possible of […]
2001-11-29
1 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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