Viewing 15 posts - 5,296 through 5,310 (of 14,953 total)
It should be there in master, under the system extended stored procedures. It's part of a default instalation.
I haven't used it in years, since XQuery is easier for me,...
January 19, 2011 at 10:56 am
This definitely isn't a hole in SSIS, any more than SQL injection attacks are a hole in SQL.
The difference between report security and ETL security, is that a report does...
January 19, 2011 at 10:03 am
Brandie Tarvin (1/19/2011)
I've actually seen people use the data file extension for backup and vice versa. Then they complain when they can't restore because they grab the wrong one.<headdesk>
I keep...
January 19, 2011 at 9:55 am
GilaMonster (1/18/2011)
Craig Farrell (1/18/2011)
GSquared (1/18/2011)
...because some poor fool will try to open your multi-terrabyte database file in MS Word...
*sprays coke on the screen* Thanks Gus, you just lightened up...
January 19, 2011 at 9:53 am
I don't have access to that code currently, since it's for a prior employer. However, if I remember it correctly, it ended up using the TopParentID mentioned in the...
January 19, 2011 at 6:37 am
As far as security goes for ETL, this is another reason to understand how to limit the SSIS package's account. If it's running under a sysadmin account, it may...
January 18, 2011 at 2:57 pm
Craig Farrell (1/18/2011)
GSquared (1/18/2011)
...because some poor fool will try to open your multi-terrabyte database file in MS Word...
*sprays coke on the screen* Thanks Gus, you just lightened up my...
January 18, 2011 at 2:52 pm
Those are all default file extensions. Since you can "misname" files, and they'll still work, you could have a data file with ".doc" instead of ".mdf", if you really...
January 18, 2011 at 2:47 pm
Steve Jones - SSC Editor (1/18/2011)
There are three boxes of fruit. One has apples, one oranges, and one has mixed apples/oranges. Each one is labeled, but...
January 18, 2011 at 2:18 pm
It's either that or manually put them into a different role in SQL Server.
January 18, 2011 at 7:13 am
Have you added it to MS Connect? http://connect.microsoft.com/
You can suggest new features, report bugs, et al, through there.
January 18, 2011 at 7:12 am
tfifield (1/14/2011)
Actually the FROM syntax is very useful as a previous poster mentioned in that the UPDATE can...
January 18, 2011 at 7:08 am
John:
You're right, and wrong, both at the same time.
First, yes, concentrating resources CAN result in greater security. However, one of the key principles of higher level security planning is...
January 18, 2011 at 6:56 am
Koen (da-zero) (1/14/2011)
GSquared (1/14/2011)
Jeff Moden (1/13/2011)
Stefan Krzywicki (1/13/2011)
If they see a penny on the ground, they leave it there.
Maybe other folks will leave it, but I'll stop and pick it...
January 14, 2011 at 7:31 am
Gianluca Sartori (1/14/2011)
Unfortunately this does not solve my issue. Basically, that thread says "don't use distributed transactions", but this is exactly what I'm trying to do.
Please...
January 14, 2011 at 7:27 am
Viewing 15 posts - 5,296 through 5,310 (of 14,953 total)