Viewing 15 posts - 4,786 through 4,800 (of 11,678 total)
Another alternative:
SELECT ID
FROM emp
WHERE empskills = 'C'
INTERSECT
SELECT ID
FROM emp
WHERE empskills = 'CPP'
September 24, 2013 at 7:53 am
Third result for "sql server script database backup":
Simple script to backup all SQL Server databases[/url]
If you're uncomfortable with backup scripts, you can always try a maintenance plan.
September 24, 2013 at 7:07 am
vignesh.ms (9/24/2013)
Im handling cores of data which will refreshed in every run.
Can you elaborate a bit more on your set-up?
What do you mean with cores of data?
September 24, 2013 at 7:05 am
They are just some fun way to indicate how many points you have already gathered.
Some point totals have special statuses that only people who know a lot of baseball understand...
http://www.sqlservercentral.com/Forums/Topic935523-83-1.aspx
September 24, 2013 at 7:02 am
I'm pretty sure if you google around for a bit, you can find thousands of scripts on how to take a backup on SQL Server.
September 24, 2013 at 7:01 am
Yes.
You can script it out and run the script every hour with SQL Server Agent, or you can create a maintenance task.
September 24, 2013 at 6:40 am
Not directly within SSIS.
You could use .NET to extract the attachments from Outlook (don't ask me how though, this is more for a .net forum) and then use SSIS to...
September 24, 2013 at 6:30 am
Can't you use the R2 edition, but set the database compatability level to 2008?
September 24, 2013 at 6:20 am
There is a poll option somewhere 🙂
There is no "industry-standard" practice on SSIS configurations, at least as far as I know.
Both have their advantages and disadvantages and in the end...
September 23, 2013 at 1:19 pm
Does the SQL Server Agent account have the right permissions to access the configuration file?
September 23, 2013 at 12:22 pm
Very nice question, thanks.
September 22, 2013 at 1:43 pm
Jan Van der Eecken (9/20/2013)
wolfkillj (9/20/2013)
... The filibuster ...
I don't think I'm the lone non-US citizen who doesn't quite understand what the Filibuster is all about. The way I understand...
September 22, 2013 at 1:38 pm
Viewing 15 posts - 4,786 through 4,800 (of 11,678 total)