Viewing 15 posts - 6,316 through 6,330 (of 6,344 total)
No I didn't look at calculated columns, will take a look and re-post.
June 6, 2011 at 7:58 am
Managed to get what I needed.
To do this, open up the DSV in BIDS, click on VIEW, CODE, this will then bring up the XML for the DSV and then...
May 20, 2011 at 2:48 am
I have seen this a number of times in relation to MSDTC and BizTalk, with one of the instances causing quite a significant problem in the live environment.
To get the...
May 18, 2011 at 2:09 am
I would like to thank Chris for this, it is excellent.
One question I have is how do you "UNDROP" from trash can.
Say we have 3 copies of the same table
zz_RecycleBin.Table1_20110411_1125
zzz_TrashCan.Table1_20110410_1426
zzz_TrashCan.Table1_20110409_1735
The...
April 12, 2011 at 6:53 am
Hi Gail
Thanks for this, unfortunatly the application which runs is only supported up to SP2 for SQL 2005 as the vendor hasnt got round to testing on their systems for...
April 5, 2011 at 1:33 am
to get around this issue i put event handlers on all of my DFT's and Execute SQL Tasks to log to a table when the task started and finished.
i managed...
March 2, 2011 at 5:43 am
after a bit of playing with the job and bids I have noticed that the first package is the one which is cancelling so it never gets to package 2,3...
January 21, 2011 at 3:16 am
The job was stopped prior to completion by (Unknown) . The Job was invoked by User SITES\agreen. The last step to run was step 1 (LoadingBayBT1). The...
January 21, 2011 at 1:28 am
Hi McSQL
Its usually between 6 and 7 minutes then the job stops.
One of the articles I was looking at was in relation to a WAITFOR event where it maybe that...
January 19, 2011 at 5:40 am
Hi Adiga
Query --> IntelliSence Enabled is checked, I shall try a repair via Add Remove Programs shortly.
Hi Gail
In terms of the 'not working' I am not seeing the popup box...
December 7, 2010 at 3:38 am
That was my understanding too.
We have a number of filegroups which have an assigned schema against that file group, and we just wanted to have the schemas together on the...
August 17, 2010 at 5:20 am
Hi Adiga
No our issue hasnt been resolved as it will require a full rebuild of the virtual server and SQL.
As the server is SQL 2000 we move MSDB and MODEL...
July 27, 2010 at 6:34 am
I have already done this.
Both services run as the same account.
Recreated the MAPI profile
All services restarted
Server rebooted
Thanks
Ant
February 2, 2010 at 5:32 am
Doug
I was changing the account through services.msc.
I will arrange downtime and change through config manager and repost the results.
Anthony
July 26, 2009 at 3:50 am
The issue is not with the master log file, it is with the master data file.
I dont see how moving the log will resolve the issue
Thanks
Ant
July 24, 2009 at 8:31 am
Viewing 15 posts - 6,316 through 6,330 (of 6,344 total)