How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!
2006-05-05 (first published: 2002-03-19)
37,917 reads
Hi, I use sp_refreshview to refresh my view when I change the structure of my table. It works when I add a column to my table but if I remove a column and run sp_refreshview on my view, the following error occur : Server: Msg 4502, Level 16, State 1, Procedure vwRR, Line 5 View […]
2002-03-18
1 reads
I use "xp_readmail" to read an Inbox. Does anybody know, how to read some other folder insted of "Inbox" paul
2002-03-07
Anyone know how to use the SQLDriverConnect'keyword to set up a DSN ? I'm trying to set a default language using it as I launch a VB6 app ? Help anyone.
2002-03-01
how can i delete a DTS package saved with lineage option in the repository. it is not visible under repository packages folder in enterprise manager.
2002-02-26
3 reads
I have a stored procedure that builds a select statement based on search options in a web page. At the end of the procedure, I have a command: exec @search so that it returns the values in the custom-built select statement. Now my users are asking me for a sum value for a field of […]
2002-02-25
4 reads
Hello I have a problem with my Sql Statement and i need to know if is it possible to make a group by clause that returns all records grouping by 'Armazem' and 'article' I send my statment and there result : select left(sl.ref,4) as article,(select case when ARMAZEM=1 THEN 'FEIRA' ELSE CASE WHEN ARMAZEM=2 THEN […]
2002-02-07
10 reads
I have 36 columns in a table. My objective is to create a trig which traps any column change and populate a tran table. Here is my question. When I compile and run this no errors. When I update a column in my table I am expecting to see one row inserted for the change […]
2002-01-22
2 reads
I am wanting to deploy a demo copy of my VB app via internet using MS Access as the database. Later will ship MSDE or sell SQL 2000. I wish to use essentially the same code base for both db's but having trouble with an Access query. Code is: Dim rs As ADODB.Recordset Dim cmd […]
2002-01-17
In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.
2007-10-02 (first published: 2002-01-14)
50,358 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