Can I connect SQL Enterprise Manager ...

To an internet address (ip).
Is this done by registering the "IP" instead of the server name?
Many thanks
MP
You can use the IP address instead of the server name. Just try 127.0.0.1 to
connect to your local server. If you think the ip addresses are confusing in
Enterprise Manager, you can use the Client Network Utility to set up an
alias that you can use instead.
Jacco Schalkwijk
SQL Server MVP
"Michael Persaud" <michaelsrpersaud@.hotmail.com> wrote in message
news:eG5W5bmeEHA.3944@.tk2msftngp13.phx.gbl...
> To an internet address (ip).
> Is this done by registering the "IP" instead of the server name?
> Many thanks
> MP
>

Can I connect SQL Enterprise Manager ...

To an internet address (ip).
Is this done by registering the "IP" instead of the server name'
Many thanks
MPYou can use the IP address instead of the server name. Just try 127.0.0.1 to
connect to your local server. If you think the ip addresses are confusing in
Enterprise Manager, you can use the Client Network Utility to set up an
alias that you can use instead.
Jacco Schalkwijk
SQL Server MVP
"Michael Persaud" <michaelsrpersaud@.hotmail.com> wrote in message
news:eG5W5bmeEHA.3944@.tk2msftngp13.phx.gbl...
> To an internet address (ip).
> Is this done by registering the "IP" instead of the server name'
> Many thanks
> MP
>

Can I assign rowguid from the client code instead of using default newid()?

Do I have to use default newid() for the rowguid? I would prefer to pass a
sequential GUID from the client code instead.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1
Or can I at least use newsequentialid() instead of newid() as the ROWGUID
default?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1
|||Alex,
Yes,
CREATE TABLE dbo.Table1
(
test uniqueidentifier NOT NULL ROWGUIDCOL
) ON [PRIMARY]
ALTER TABLE dbo.Table1 ADD CONSTRAINT
DF_Table1_test DEFAULT (newid()) FOR test
-- Bill
"Alex via droptable.com" <no@.spam.pls> wrote in message
news:6bd9f60658969@.uwe...
> Or can I at least use newsequentialid() instead of newid() as the ROWGUID
> default?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1
>
|||Thank you for your response. It seems your code is still using newid(), but
anyway it is not what I was asking. The MS documentation says that one can
create replication ROWGUID column manually as long as it have the following
characteristics:
* The data type as UNIQUEIDENTIFIER.
* The default as NEWID().
* The ROWGUIDCOL property.
* A unique index on the column.
My questions are:
1. Can I use newsequentialid() instead of newid() ?
2. Can I supply GUID from my client code instead of using this default value?
I am interested in transactional replication model with updating subscribers.
AlterEgo wrote:[vbcol=seagreen]
>Alex,
>Yes,
>CREATE TABLE dbo.Table1
> (
> test uniqueidentifier NOT NULL ROWGUIDCOL
> ) ON [PRIMARY]
>ALTER TABLE dbo.Table1 ADD CONSTRAINT
> DF_Table1_test DEFAULT (newid()) FOR test
>-- Bill
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1

Can I add user and passw to my OLAP ConnectionString?

Hi all,
I have written a custom assembly that works fine in preview mode, but when I deploy the report I get the '#Error' message instead of the output.
I have copied the assembly to the bin folder of Reportserver, placed it in the GAC and even edited the policyfiles.

Any help would be very appriciated,

Thanks in advance

public static class SimCardBuyer
{
public static string ReturnBuyer(string Seller, string PeriodeCode, string ComDevice)
{
string connstring = "PROVIDER=MSOLAP;DATA SOURCE=srv03-gc-10;INITIAL CATALOG=Invoicing";
AdomdConnection conn = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection(connstring);
//Create a new string builder to store the results
System.Text.StringBuilder result = new System.Text.StringBuilder();
//Connect to the local server
using (conn)
{
conn.Open();
//Create a command, using this connection
AdomdCommand cmd = conn.CreateCommand();
cmd.CommandText = @."SELECT NON EMPTY { [Measures].[InvoiceAmount] } ON COLUMNS, NON EMPTY { ([Buyer].[Company].[Company].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
( SELECT ( { [Com Device].[Com Device].[" + ComDevice + @."] } ) ON COLUMNS FROM
( SELECT ( { [Invoice].[Period Code].[" + PeriodeCode + @."] } ) ON COLUMNS FROM
( SELECT ( { [Seller].[Company].[" + Seller + @."] } ) ON COLUMNS FROM [Invoicing])))
WHERE ( [Seller].[Company].[" + Seller + @."], [Invoice].[Period Code].[" + PeriodeCode + @."], [Com Device].[Com Device].[" + ComDevice + @."] )";

//Execute the query, returning a cellset
CellSet cs = cmd.ExecuteCellSet();
//Output the column captions from the first axis
//Note that this procedure assumes a single member exists per column.
TupleCollection tuplesOnRows = cs.Axes[1].Set.Tuples;
if (tuplesOnRows.Count > 1)
{
for (int row = 0; row < tuplesOnRows.Count - 1; row++)
{
result.Append(tuplesOnRows[row].Members[0].Caption);
result.Append(" / ");
}
result.Append(tuplesOnRows[tuplesOnRows.Count - 1].Members[0].Caption);
}
else if (tuplesOnRows.Count == 1)
{result.Append(tuplesOnRows[0].Members[0].Caption);}
else{result.Append(Seller);}
conn.Close();
return result.ToString();
}
}

Dear readers,

I have solved the problem above, but now I get an error with the Connectionstring.
I'm getting the next error now:

Either the user, NL01\SRV03-GC-10$, does not have access to the Invoicing database, or the database does not exist.
NL01\SRV03-GC-10$ is not a user in my system, so I'm stunned with this strange error.

I would appriciate any reply on this.

regards.

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.
No, you will have to change it at the connection level.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.No, you will have to change it at the connection level.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.No, you will have to change it at the connection level.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.

Can anyone make a suggestion?

the "View Report" button - Can it be place at a fixed position so that
the user sees to press it instead of having to scroll to the right?
ThanksYou can open a window using javascript and play with window's size. The
toolbar controls will wrap.
Just a suggestion.
"Hoa" <hn.hoanguyen@.gmail.com> wrote in message
news:1128089846.201541.180790@.g14g2000cwa.googlegroups.com...
> the "View Report" button - Can it be place at a fixed position so that
> the user sees to press it instead of having to scroll to the right?
> Thanks
>|||Thank you, Oleg. I will give it a try.

can anyone help me regarding tool

hi
is there any tool to write stored procedure
i have long queries to write instead of that i want a tool or editor where i can click or drag and drop to write procedure
i make my work to complete faster
if any please tell me the site to download
thanx
bye
ramesh

Hi Ramesh,
Maybe is this something your looking for:
http://www.softcities.com/Lattice.SPGen-Stored-Procedure-Generator/download/16114.htm
or
http://www.freevbcode.com/ShowCode.asp?ID=3412
I never used these programs but i just did a search on google for you.
mgg