Sunday, March 25, 2012
Can't find tool
"FiletoTable.exe" anywhere online. Does anyone know how I can get this file?
"You can also use FiletoTable.exe, a command line utility, to load a trace
file
to a database table so that data in the trace file can be analyzed..."
www.microsoft.com/technet/ prodtechnol/sql/2000/maintain/sqlc2.mspx
Thanks in advance,
Arnold
I don't know about that tool but if you have SQL 2000 you can use:
Select * FROM ::fn_trace_gettable('C:\Traces\TestTrace.trc', default)
See BOL for more details.
Andrew J. Kelly SQL MVP
"Arnold" <Arnold@.discussions.microsoft.com> wrote in message
news:51EF4662-3922-448D-8E46-FCF9F88EDECD@.microsoft.com...
> Based on this message referenced in the link below I can't find the file
> "FiletoTable.exe" anywhere online. Does anyone know how I can get this
> file?
>
> "You can also use FiletoTable.exe, a command line utility, to load a trace
> file
> to a database table so that data in the trace file can be analyzed..."
> www.microsoft.com/technet/ prodtechnol/sql/2000/maintain/sqlc2.mspx
> Thanks in advance,
> Arnold
Can't find SSIS ?
I have VS2005 and have been using SQL 2000. I installed SQL 2005 Developer but I can't find SSIS anywhere. It is hard to start even the first tutorial if I can't find the program. Was it supposed to be installed with 2005 Developer? Help!
Thanks in advance.
Chuck
Did you select to install Integration Services and the development environment. If you did, the best way to Start to is to open the Business Intelligence Development Studio (BIDS) - find it under your SQL Server group on the Start menu. See http://msdn2.microsoft.com/en-us/library/ms173767.aspx
Start a new Integration Services project ... http://msdn2.microsoft.com/en-us/library/ms141823(sql.90).aspx
If you do not have BIDS installed then you most likely did not install dev tools.
Donald
|||Did you select SSIS during the install? Note that installing SSIS does not enable you to build packages, only run them.
The SSIS development tool (i.e. BIDS) is installed when you select the "Client Tools" option.
-Jamie
Cant find SQL Server Management Studio
Where can I find it, or am I missing something?
Copy all the files to your hard drive and rerun setup and choose repair to select all components management studio is under management tools. And I don't know what the configuration managers do but they are not related to management studio. Hope this helps.
|||or, tryhttp://www.microsoft.com/downloads/details.aspx?familyid=57856CDD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en#filelist
where I googled it. Seems as it doesn't install in some packages of SQLExpress.
hope this helps. - itagens
Thursday, March 22, 2012
Can't find answer to this anywhere
When using rs.CreateFolder to create a folder, is it possible to set the
"Inherit security from parent" property to false? How would I do this. What
is the property called? I have tried "InheritSecurity" but that did not
work...On Mon, 18 Apr 2005 03:57:27 -0700, "DBA72"
<DBA72@.discussions.microsoft.com> wrote:
>A fairly straightforward question:
>When using rs.CreateFolder to create a folder, is it possible to set the
>"Inherit security from parent" property to false? How would I do this. What
>is the property called? I have tried "InheritSecurity" but that did not
>work...
You might want to look at UpdateDeleteAuthorizationPolicy. I don't
know of any example syntax to go beyond what is in BOL, which isn't
much.
Andrew Watt
MVP - InfoPathsql