Viewing 15 posts - 5,671 through 5,685 (of 9,712 total)
It does sort of does make sense. And you're correct. There's no way I know of to use the BIDS solution to set up that information.
Our developers use a SQL...
June 21, 2011 at 12:28 pm
Have you had any service pack updates or anything applied to your box or the server recently? Right about the same time that this error started.
June 21, 2011 at 12:23 pm
GSquared (6/21/2011)
SSIS job and they don't know about derived columns????
Is that the part where I make something up and hope it fits with the rest of the data?
@=)
How can...
June 21, 2011 at 11:09 am
Steve Jones - SSC Editor (6/20/2011)
GabyYYZ (6/20/2011)
Anyone know if he has official Microsoft MVP designation, either now, or in the past?
AFAIK, he never has. Not enough contributions to the SQL...
June 20, 2011 at 12:26 pm
What queries have you tried based on the above table schema?
June 20, 2011 at 12:15 pm
Then it's my bad.
June 20, 2011 at 9:37 am
opc.three,
I think you're mixing this post up with another thread. There is no requirement for 60 days in the OP that I can see. The OP says "all files."
June 20, 2011 at 9:07 am
You can query on sys.Filegroups.
June 20, 2011 at 9:04 am
chris.caines (6/20/2011)
They appear to be, if I query sys.master_files:
CCT_MSCRME:\DATA\CCT_MSCRM.mdf 0ONLINE
CCT_MSCRM_logF:\LOGS\CCT_MSCRM_log.LDF 0ONLINE
FYI: Your .mdf file is not the same as a...
June 20, 2011 at 7:14 am
ravisamigo (6/20/2011)
How can I configure that database server to reportserver to generate Reports?
Ravi, looking at this question, I just realized I don't understand what you mean by it. Could you...
June 20, 2011 at 7:11 am
Grant Fritchey (6/20/2011)
polasabhushan (6/20/2011)
June 20, 2011 at 7:05 am
polasabhushan (6/20/2011)
But I can say that, before taking a full or differential backup, we are truncating log by changing recovery model from bulk-logged to simple and again to bulk-logged.
That's your...
June 20, 2011 at 7:00 am
Script tasks in SSIS work with C# and VB.Net. If you don't know these languages, I advise you to steer clear of the Script Task and use the File System...
June 20, 2011 at 6:58 am
dec_obrien (4/2/2007)
When you backup the database, what happends the log file?
Absolutely nothing. Database backups don't even look at the log file. Transaction Log Backups, however, are a different story entirely....
June 20, 2011 at 6:56 am
Not sure you need VS installed to create an SSIS package. The SSIS Import / Export wizard could create the package for you. You would, however, need to have SSIS...
June 20, 2011 at 6:54 am
Viewing 15 posts - 5,671 through 5,685 (of 9,712 total)