Improve System Performance in Your Indexing Scheme Using Asynchronous
Comments posted to this topic are about the content posted at http://www.microsoft.com/mspress/developer/feature/
2001-09-08
1 reads
security
Thoughts on DBA Roles within a company
I was just wondering how other companies handle the DBA Roles. We have 2 DBA Teams, a Development DBA Team, and a Networking DBA Team. The Development DBA team creates tables, stored procedures, jobs and DTS Packages. The Networking DBA Team maintains permissions, does backups and creates database shells. The current managers do not trust […]
2001-09-05
4 reads
Using a central Alias for a Named Instance
Let me pose the scenario and see if anyone has a solution: Most of our applications are client/server, in other words they have no middle tier. My management would like to be able to create warm standby servers for our SQL 2000 instances. In the case that we have to "fail-over" to one of these […]
2001-09-05
2 reads
SQLMail and Lotus
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
Can we use any ActiveX Object in SQL Server
Can we use any kind of activex object in SQL server stored procs. I have used CDONTS component to send mails from SQL Server. I know there is xp_sendmail in sql server to send mails. But what if I create my own activex control. Can I use it. And how? Paras Shah Evision Technologies Mumbai, […]
2001-09-02
13 reads
insert/update image datatype column
Hi, someone can show me how can I insert/update a row containing an image datatype column ? Table: Product (ProdId int, Description varchar(50), ProdImage image) The image files (Prod1.jpg, Prod2.jpg,...) are located in a directory \Image. If possible, I'd like to use stored procedures for this purpose.
2001-08-30
3 reads
Syncronisation of DataBases
Hello experts, I have built a small application with database[25 tables] on SQL server now what I want is I want the branch office also to use that same database for booking or reservation purposes but how should I make sure that both databases (one at HO and one in branch office are in sync […]
2001-08-29
2 reads
disk space free/total disk space
I'm trying to find the percent of free disk space from a t-sql script so I don't run some operations and blow up the server due to out of disk space errors. I'm stumped. Wes
2001-08-29
166 reads
SQL Mail with Lotus Notes
Dear Forum, Does anybody have detailed, comprehensive documentation, or URL for configuring SQL Mail to communicate using Lotus Notes R5. Thanks In Advance. John
2001-08-26
4 reads
Using Output Variables from One Procedure to Other
I just needed a help from you. The problem that I am facing is that I am not able to use the output variable of sp_A into sp_b. sp_A: output variable X, input variable Y sp_B: Line 1: exec sp_A, @x='',@y='anything' Line 2: insert into tab1(id) values (@x) i am not able to use @x […]
2001-08-26
2 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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