MDX

RE: Performance Issues

• by Site Owners

• Database Journal

• Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

2003-05-26

RE: Why can't a Windows Group own a job?

• by Johan Bijnens

• Database Journal

• Reply

I guess because groups don't have a loginname. Add it to the ms-sql-wishlist.

2003-05-23

1 reads

RE: I need some helpful advice...

• by cdun2

• Database Journal

• Reply

quote: Check at http://www.cramsession.com/ to see what the most recent version of the test are. Thanks for your help, I will check the cramsession site. CSDunn

2003-05-20

1 reads

RE: Multiserver jobs

• by Roust_m

• Database Journal

• Reply

Is it possible to defect a target server without master server, from itself?

2003-05-15

1 reads

RE: Collation error when adding DB user

• by Allen-Cui-55137

• SQLServerCentral

• Reply

Did you receive this error message by tring to add new login or grant existing login to access database? What is your database collation?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-12

RE: increasing number of bytes per row

• by 5409045121009-7368

• Database Journal

• Reply

I thought it may have a bearing on whether the table has an index or not, how SQL handle tables without PKs. First made second column an primary index. Problem persist. Secondly change second(pk) to int and problem disappeared. set nocount on drop table test go if exists (select * from dbo.sysobjects where id = […]

2003-05-10

1 reads

RE: xp_cmdshell permissions

• by mromm

• Database Journal

• Reply

I think if you create a stored procedure named abc that calls xp_cmdshell and grant EXECUTE abc rights to the given user, the user should be able to execute abc even if he cannot execute xp_cmdshell directly.

2003-05-09

RE: Unused login accounts

• by James Travis

• Database Journal

• Reply

You can also audit your logins with either Profiler to capture connections or if you right click the Server in question in EM and choose properties you will find Audit level options on the Security tab (you will have to stop and restart the service to use this and to turn off).

2003-05-09

1 reads

RE: Convert ASCII

• by AnzioBake

• SQLServerCentral.com

• Reply

Not Entirely sure what you want but try this: It Will give you the ascii number represented by the hexadecimal number declare @s1 varchar(2) ,@ii int ,@bin varbinary(10) set @s1='14' set @bin = 0 set @ii = 1 While @ii <= Len(@s1)Begin Select @Bin = @Bin +( Power( 16, @ii - 1 ) * Convert( […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-09

RE: Failover Clustering

• by zach_john

• Database Journal

• Reply

Only the databases (not the server) that you log ship are in standby. I have a situation where my production databases are standby servers for other production server and then the reverse. The chances of catastrophic failure are so slim I hate to have duplicate boxes sitting there doing nothing. So like Clustering I guess […]

2003-05-08