Hey,Are you familiar with SQL DMO Libraries ? you can do all the actions of SQL EM using sqldmo libraries. i dont have any code base for the same. just have a look at this COM and if you are facing any probs let me know.Jeswanth
2004-11-17
Oops, forget it. Reread it that you want it on both columns. Sorry.
2004-11-12
A quick search on SQLServerCentral.com yielded the following article on transferring DTS packages - http://qa.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.aspThere were also numerous threads in the forums that showed up in that search.My search was simply the words "copy" and "dts" in the search box. I figure ANYTHING would be better than manually copying 300 DTS packages between servers!!!!Steve
2004-11-09
I made correction to my datatypes to match all columns in database. Also, I entered all the fields on the entry form but I still unable to save it. (Error : Input string is not in a correct format.  I even tried that I left the data unchanged, (that means I didn't have any empty strings) and I still received […]
2004-10-14
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-10-11
Well the processes may have rolled back by now, 3 days on from the posting. If not then I think you will have to stop & start the SQL Server Service. On restart the db will go into recovery mode but it should be OK several minutes later. Back the database up before the reboot […]
2004-10-11
HiI sharing too. The risk we knows.I had many problems with kill sessions and the last resource was a reboot or stop and start SQL Server.The chance of you corrupt database use this processes is very difficult. You need understand a processes , if it use a temp tables.In best pratice programming, all developers design […]
2004-10-11
If you require the number of rows at the output from the proc then try this:create Procedure dbo.RecCount (@Table as nvarchar(100)) AsBegin DECLARE @cntTotal varchar(10) DECLARE @sql nvarchar(400) set @sql = N'select @cnt=count(*) from ' + @Table exec sp_executesql @sql, N' @cnt varchar(10) output', @cnt=@cntTotal output select @cntTotal End
2004-08-20
The answer would be things like last 5 deposits and similar situations like you see on banking sites. Many of these are predetermined queries and people want to simplify as much as they can so to support TOP and get a correct result ORDER BY was allowed under this situation from my understanding, it isn't […]
2004-08-18
What version of SQL are you running. There is a problem (bug) in 7.0 that would cause this to happen. After much effort back and forth with MS, they confirmed it a bug.It is fixed in 2K
2004-08-17
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