I ahve not run into any issues with shirnking an MDF except for when I setup a filegorup for TEXT. I found by setting the maxsize to the current size...

My concern under doing the APP=text is you will want to fill the APP with the value of the clients id, ip or other identifying piece. But when you create...

You would be better off using and IDENTITY filed and setting the seed value and incremement of 1.

You are building the same thing here basically anyway except for your...

Again go back and look at the syntax of LoadFromSQLServer

Package.LoadFromSQLServer ServerName, [ServerUserName], [ServerPassword], _

[Flags], [PackagePassword], [PackageGuid], [PackageVersionGuid], _

[PackageName], [pVarPersistStgOfHost]

Set a user password...

I am still trying to understand the statement using COALESCE will not utilize and index

I test this under with the following script

SET SHOWPLAN_TEXT ON

GO

DECLARE @dt datetime

SET @dt = '12/05/2002'

select count(*)...

I think I see the problem. You are assuming "elapsed time" is the amount of time the query took to execute. This is is the connections cumlative time and if...

Interesting approach without a table. If you test I suggest posting as an alternative to the scripts section.

No matter what solution you use keep in mind how many trasactions you need to process in a given time. I have seen people do this and tie themselves up...

See these threads for additional comments

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8534&FORUM_ID=23&CAT_ID=2&Topic_Title=Leading%20Zeros&Forum_Title=General

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8535&FORUM_ID=23&CAT_ID=2&Topic_Title=Leading Zeros&Forum_Title=General

Check this thread for comments on AdeptSQLDiff

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8415&FORUM_ID=9&CAT_ID=1&Topic_Title=AdeptSQLDiff&Forum_Title=General

Why are you using a cursor. Depending on what is happening in DSDBA.usp_ItemsDB_InsertGroup you should be able to do your insert much more effectivly like this.

DECLARE @PREFIX VARCHAR(6)

DECLARE @PARENTGUID UNIQUEIDENTIFIER

SET...

quote:

---

I was wondering why my transaction log is twice the size of the data file !

Are there any issues in adding 20,000...

No they do not supprt SYbase thru the SQL Server drivers, they do support Sybase as a linked server via ODBC. Is the problem still occurring, have you tried to...

How did you set yours up as I have no troubles using myself?

The prblem is you may not know. SOmeone stated @@error could be used to trap and handle the error but I have not tried myself.