How to show all aliases in SQL 7 ?

Does anybody know a command that shows ALL aliases on the database?
Or could I search for them in the system table and make a SELECT for them?
pls. helpRE: Q1 Does anybody know a command that shows ALL aliases on the database?
Or could I search for them in the system table and make a SELECT for them?

pls. help

A1 To get the alias [member] or user status for each login on a Sql Server run:

exec sp_helplogins

If run without specifing a login, the information will appear in the last column (UserOrAlias) of the second result set that the sp_helplogins stored proc returns.

How to set writable property to readonly

Hi all,
Is there any command to change writable property of database or table or
column to readonly.
Thanks in advance.
SupriyaBelow links will be helpful
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/27/read-only-file-group-tables-are-not-really-read-only-in-the-strict-sense.aspx
-
Shiju Samuel
On Sep 11, 1:56 pm, "Supriya Pagadala" <supriya_...@.yahoo.com> wrote:
> Hi all,
> Is there any command to change writable property of database or table or
> column to readonly.
> Thanks in advance.
> Supriya|||Hi Samuel,
Thanks for your response.I think you misunderstood the question.I want
to make particular property to readonly. Not entire table or database.
for example Table has following properties..
Name,NoOfColumns...etc.
If "Name" property is writable , how to make it read only?
"Shiju Samuel" <shiju.samuel@.gmail.com> wrote in message
news:1189502014.158301.151010@.y42g2000hsy.googlegroups.com...
> Below links will be helpful
> http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx
> http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/27/read-only-file-group-tables-are-not-really-read-only-in-the-strict-sense.aspx
> -
> Shiju Samuel
> On Sep 11, 1:56 pm, "Supriya Pagadala" <supriya_...@.yahoo.com> wrote:
>> Hi all,
>> Is there any command to change writable property of database or table
>> or
>> column to readonly.
>> Thanks in advance.
>> Supriya
>sql

How to set SQL Profiler via command line

Hello,

How can I set SQL Profiler to capture the logs via command line?

This is what I have:

I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.

C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out

What other parameters am I missing?

Thanks!

J

Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.

Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm

How to set SQL Profiler via command line

Hello,

How can I set SQL Profiler to capture the logs via command line?

This is what I have:

I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.

C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out

What other parameters am I missing?

Thanks!

J

Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.

Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm

|||How about if the SQL Server I used is 2000, I've checked it b4 but cannot find the Profiler90.exe, only Profiler.exe is exist which don't hv output file path I can specified. Pls help. Thanks.|||

Please read the following to find out how to monitor SQL Server using Profiler Traces.

http://yukonspace.blogspot.com/2007/09/server-side-profiler-traces.html

The EXE for SQL Server 2000 Profiler is Profiler.exe and for SQL Server 2005 is Profiler90.exe

How to set SQL Profiler via command line

Hello,

How can I set SQL Profiler to capture the logs via command line?

This is what I have:

I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.

C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out

What other parameters am I missing?

Thanks!

J

Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.

Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm

|||How about if the SQL Server I used is 2000, I've checked it b4 but cannot find the Profiler90.exe, only Profiler.exe is exist which don't hv output file path I can specified. Pls help. Thanks.|||

Please read the following to find out how to monitor SQL Server using Profiler Traces.

http://yukonspace.blogspot.com/2007/09/server-side-profiler-traces.html

The EXE for SQL Server 2000 Profiler is Profiler.exe and for SQL Server 2005 is Profiler90.exe

How to set SQL Profiler via command line

Hello,
How can I set SQL Profiler to capture the logs via command line? I wanted to
this just before my testing.
This is what I have:
I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I
need SQL to capture.
C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE"
/Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
What other parameters am I missing?
Thanks!
Read the below article about server side tracing.
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
http://www.dbazine.com/sql/sql-articles/larsen6
THanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OThA6%23tZHHA.1388@.TK2MSFTNGP05.phx.gbl...
> Read up on "Server Side Trace".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MS" <MS@.discussions.microsoft.com> wrote in message
> news:301D495F-1B3F-4694-B9CA-6A3417F7CDEF@.microsoft.com...
>
|||On 15 Mar, 14:14, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Read the below article aboutserverside tracing.
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
> http://www.dbazine.com/sql/sql-articles/larsen6
> THanks
> Hari
> "Tibor Karaszi" <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote in
> messagenews:OThA6%23tZHHA.1388@.TK2MSFTNGP05.phx.gb l...
>
>
>
>
>
>
> - Show quoted text -
That was very useful.. Thanks hari..
-PrasannaKRao

how to set connection string value by using SET switch of dtexec sql server 2005 command

hi

I need to load a text file into sql server table using SSIS package.

the idea is to load this file with the help of dtexec command by giving the file path and name in the SET switch of dtexec command.

anyone having an idea; would be of great help.

Regards,

Salman Shehbaz.

Try using the package configuration wizard to get the property path:

Jamie talks about it here:

http://blogs.conchango.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx

|||

o.kays

i finally got hold of the command;

here it is

execute master.dbo.xp_cmdshell 'dtexec /Ser "ServerName" /SQ "SSISPackagehName" /SET "\Package.Connections[ConnectionManagerName].Properties[ConnectionString]";"TextFilePath/Name"'

Regards,

Salman Shehbaz.

How to set a bigger rollback segment?

Hi,

I′m trying to transfer a large amount of data from Oracle 8 to Sql Server. For each table, I have an OleDBSource with DataAccessMode Command (select with one inner join), Data Conversion and OleDBDestination. Sometimes I′m getting an ORA-01555 snapshot too old error, so I′d like to set a bigger rollback segment, but don′t know how. Please, can anybody help me?

Thanks

Janca

That has nothing to do with SSIS. That is an Oracle DB related issue that needs to be address for the DBA.

Whatever you are doing in the package; Have you tried to commit the SSIS work in a smaller batches? That is something you can controll.