Please try this: 1 - use Northwind 2 - Delete FK Constraints from orderdetails table reference products and orders tables 3 - Create view to have: 4 - orderdetails.OrderID, orderdetails.ProductID, orderdetails.ProductName 5 - Run this view 6 - Delete a record. Before delete write orderid and productid values on a paper 7 - Try to […]
2001-09-04
Anyone know if SQL Server 2K can use bitmapped indexes? I have not been able to find anything about this
2001-09-03
1 reads
Does anyone have any inside knowledge on what goes on 'behind the scenes' with OPENXML used with sp_xml_preparedocument and sp_xml_removedocument? I know it uses MSXML2, and that it will use up to 1/8 of the total amount of memory allocated to SQL Server, all from BOL. What I'm really interested in if it is any […]
2001-09-03
11 reads
Hi all, I backed-up (full) a database in one sql server and copied the backed-up file to another sql server machine. I created a new database and when I tried to restore from the backed-up file, I got the following error "The backup set holds a backup of a database other than the existing 'databasename' […]
2001-09-03
2 reads
I use MSSQL Server. I let SQL Server Agent to "Autostart when OS starts". The problem is that when I have to restart the server , the agent doesn't start and I get the famous message "At least on of your services ..." Subsequently, Once I check NT's event log , I see the error […]
2001-09-02
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
How can you Execute a DTS Package from an StoredProceedure?
2001-09-01
2 reads
I've created this procedure to count the number of times a particular condition was met in a log file. CREATE PROCEDURE SP_SMTPSTATS AS DECLARE @TEST AS INT SELECT @TEST = COUNT (*) FROM smtpstats Where clienthost = "10.0.0.64" AND Operation = "Data" AND bytesrecvd > 200 AND bytesrecvd < 2000 ??????????????NOW WHAT???????????????????????????? GO Now I […]
2001-08-30
2 reads
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
how to drop a temprory table created by command create table #123 thanks in advance from alkesh
2001-08-30
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