I have situation where i have to every month bring in new data from Text files which are Vertical tab separated in columns and carriage return for every row. The are many such files which are entered into many tables For this i will have to manually do the DTS every month. Can we automate […]
2004-11-10
2 reads
Been there, done that... it's always so simple once you have the solution 🙂
2004-11-10
I'm not sure I understand what your question is. Are you asking how to deploy DTS packages to another server?If that's what you want, you can either backup backup msdb and restore on the other server (don't do this if you're moving packages to a production server that already has packages and jobs) or open […]
2004-11-09
Interesting. I know the wizard adds/drops indexes as it schemes along, just doing that shouldnt affect replication - unless it tries to change the primary key, that would not work and would break replication if it succeeded.
2004-08-16
Hello, everyone.We have a very interesting problem. Fortunately, this was happened with test database. We lost information from one of the tables. There are some developers who worked with this table. How can we define what happend?Database backed up once a week, and transaction log every hour?Thanks in advance.
2004-05-24
2 reads
Hi,I want to get the last occurance of a string/char in a given string.is there any implicit function for doing so similar to CAHRINDEX that returns the first occurance. Thanks in advance-Prasad
2004-03-25
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-22
This one puts the output into SQL commands that you can cut and paste into a new query and execute. -- af_revPermissions-- Verify existence of af_revPermissions procedure. If it does exist, -- drop it, so that it can be re-created. if exists (select * from sysobjects where id = object_id(N'[dbo].[af_revPermissions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) begin […]
2004-03-18
While this doesn't offer any reasons why it is happening, I think the first thing I would do is try to restore one of those backups (obviously not over production)!Steve
2004-03-10
On the http://qa.sqlservercentral.com/forums/userinfo.aspx?id=67108 Profile Information page it states a incorrect number of posts. In my case 2519, while I'm actually on 2530.
2004-01-04
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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