I got Distribution Agent failure

I got Distribution Agent failure
however everything working correctly, it's allways red x on distribution
agent.
I have transactional replecation between two virtual computer, i replecate
all tabels from my database, everything work correct however i got red X on
replication monitor, on distributer agene. Also i did'nt find any errors in
history of distributor agent.
When i change some rows on publisher and after this run agent i see the
changes?
Any ideas ?
Message posted via http://www.droptable.com
Please try running sp_MSload_replication_status.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul.
After running this procedure i got : The command(s) completed successfully.
and the return value is 0.
it doesn't print anything else.
Message posted via http://www.droptable.com
|||But does the red circle disappear when you refresh the replication agents?
Rgds,
Paul Ibison
|||O yeeeeeeeeeee. u r great.
However what happen wheb i was run this procedure, please explain.
Thanks. .
Message posted via http://www.droptable.com
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
table. You might notice that a reboot also solves the issue - when you
restart the sql server service the msdb is recreated from the model database
so it has the same effect.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Sorry - meant the tempdb gets recreated, not the msdb...
paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eVqGZyCaFHA.3712@.TK2MSFTNGP09.phx.gbl...
> The replication monitor gets its info from
> tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
> table. You might notice that a reboot also solves the issue - when you
> restart the sql server service the msdb is recreated from the model
> database so it has the same effect.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

i get an error when i use COUNT(DISTINCT colum_name)

hello,

i have a working stored procedure

SELECT CommentID, UserName, PictureID, DateCommented, COUNT(CommentID) OVER (PARTITION BY PictureID) AS'NrOfComments'FROM Comments WHERE PictureID = @.PictureID

witch returns among others the number of comments for a picture

i need to select the number of distinct users who commented that user too, so i added this at SELECT statement

, COUNT(DISTINCT UserName) AS'Expr1'

i get that error:

"Colum 'Comments.CommentID' is invalig in the select list beacuse it is not contained in either an aggregate function or the GROUP BY clause."

what should i do, to select the number of distinct users who commented on a specific picture?

here are the table rows, if you need that

CommentID -- UserName -- PictureID -- DateCommented

please help me, thank you

You cannot get both the distinct users and the total number of comments for a picture in the same query. To use the COUNT function, you need to use GROUP BY.

For instance, to get the total number of comments for a given PictureID you would do:

SELECT PictureID,COUNT(*)FROM CommentsWHERE PictureID = @.PictureIDGROUP BY PictureID

If you would like to get the number of comments each user has made for a given PictureID you would do:

SELECT PictureID, UserName,COUNT(*)FROM CommentsWHERE PictureID = @.PictureIDGROUP BY PictureID, UserName

You will have to do two queries to get the data you want - one for the summary, and one for the actual rows.|||

ok, i understand...

i have one last question

Is possible to have two SELECT statements in the same stored procedure?

thank you for replays

|||

Basically, you can only return the result from one SELECT statement but it is possible to build this query as a UNION or JOIN with values that you need. However, this can be quite complex, and I would recommend you to split it into two procedures in this case.

|||

yes, two select statements are not possbile, but select in select works very good for what i was needed

SELECT CommentID, UserName, PictureID,(SelectCOUNT(CommentID)FROM UserPictures)AS 'Comments'
FROM UserPictures

thanks for replyes, the post is solved

|||

Ouch. I don't mean to scare you, but this will in fact count the total number of comments for every row in your table. Doing the same calculation over and over again, it will give you the same result for every row. Is this really what you want? It is ok as long as you are aware that there may be performance issues with this. It might be an easy solution, (and working) if you dont have zillions of rows in your table ;-)

I don't think the log reader is working

Simply says that there are no transactions available. But when I go to my
production app and add some things it still says the same thing.
--K
please contact me offline on this one.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasepostreply@.here.com> wrote in message
news:e5gCnBRMFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Simply says that there are no transactions available. But when I go to my
> production app and add some things it still says the same thing.
> --K
>
|||Okay, I sent an email to your account. Thank you.
--Kristy
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23hsrl5SMFHA.1308@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> please contact me offline on this one.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Kristy" <pleasepostreply@.here.com> wrote in message
> news:e5gCnBRMFHA.3928@.TK2MSFTNGP09.phx.gbl...
my
>
|||I haven't got it yet, please resend - you can also try hilaryk @. att.net
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasepostreply@.here.com> wrote in message
news:ec9gRFUMFHA.1948@.TK2MSFTNGP14.phx.gbl...
> Okay, I sent an email to your account. Thank you.
> --Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23hsrl5SMFHA.1308@.tk2msftngp13.phx.gbl...
> my
>
sql

I can't get SQL Server 2005 Enterprise Edition working

Hi all,

I can't get SQL Server 2005 Enterprise Edition working on my notebook with Windows Vista Business Edition. I installed SQL Server 2005 Enterprise Edition and then i ran SP2 for SQL Server EE.

But now when i a am trying to connect to any server from SQL SERVER MANAGEMENT STUDIO i can't see any Server in Server Name list. When I click on Browse for more, I don't see any server. I am able to get Network servers.

While installing the SQL SERVER all the features were disabled as it is, then i went to advanced and selected all the options.

Any suggestions are apperiacted in advance.

Regards,

Syed Abbas Naqvi

Sr. Software Developer.

Enterprise Edition (EE) requires a server operation system.

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

Make sure that you installed SQL Server Express (sucessfully) by checking the Services running on the machine. Look for services name "SQL Server*"

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Thanks fo your reply.

But the question is that I want to install Microsoft SQL Server 2005 Enterprise Edition on My notebook which has

Microsoft Windows Vista Business.

I tried installing Microsoft SQL 2000 Server on my machine and it works fine while it is specified on Microsoft Website

that Microsoft SQL 2000 Server is not supported on Microsoft Windows Vista ( Of Any Edition ).

I installed SQL 2000 Server on my notebook when I got frustrated installing SQL Server 2005 Enterprise Edition on my

notebook.

I am really frustrated, i should have not gone for windows vista, let the Windows Vista features go to hell.

I am not able configue .NET 1.1 or .NET 2.0 on my notebook.

I wish there was some magic which can fix all these issues.

Hope to read you soon...

Regards,

Syed Abbas Naqvi

Sr. Software Developer.

|||

Once again, SQL Server EE will need a server OS to run and to be installed. if you have problems installing SQL Server on a vista system (non SQL-EE version) you might have a look here [1] to see what you will have to tweak to make it happen.

[1] http://blogs.msdn.com/sqlexpress/

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I think you have something wrong!
According to the document at:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
It says that I can install SQL Server 2005 - Enterprise Edition in Windows Vista (Ultimate - 32 Bit). But the note "Requires SQL Server 2005 SP2 on Windows Vista" makes me difficult to understand "how can I have SS2005 SP2". I had tried to install SS2005-Developer Edition, and upgraded it to SP2, after that, I tried to install SS2005-EE with hope to upgrade my DE into EE but nothing happened...
Please help me!
|||

I think folks are missing the point here...SQL Server Enterprise Edition can not be installed on Vista, period. Vista is a client operating system and we don't support installing Enterprise Edition on client operating systems. I'm pretty sure this is actually blocked in the installer. You will need to install a different edition if you want to install on Vista.

Mike

sql

I cant figure out why this update isnt working

i dont know if it is just because im tired or what. im trying to do a update one this table here is the stored procedure im using

ALTER PROCEDURE Snake.UpdateSPlits @.name nvarchar(50),@.splitnvarchar(50)ASUpdate accountsSet split_id = @.splitWhere name = @.name RETURN

Here is what im using to call it

 
Protected Sub GridView1_RowUpdating(ByVal senderAs Object,ByVal eAs System.Web.UI.WebControls.GridViewUpdateEventArgs)Handles GridView1.RowUpdatingMe.SqlDataSource1.UpdateParameters.Clear()Dim nameAs String =Me.GridView1.SelectedRow.Cells(0).TextDim SplitAs String =Me.GridView1.SelectedRow.Cells(1).TextDim pnameAs New Parameter("name", TypeCode.String, name)Me.SqlDataSource1.UpdateParameters.Add(pname)Dim psplitAs New Parameter("split", TypeCode.String, Split)Me.SqlDataSource1.UpdateParameters.Add(psplit)Me.SqlDataSource1.Update()End Sub

I keep getting one of 2 errors they are

Object reference not set to an instance of an object. or

one that says i had to many aurgements

any idea what im doing wrong?

Change these lines

Dim nameAs String =Me.GridView1.SelectedRow.Cells(0).TextDim SplitAs String =Me.GridView1.SelectedRow.Cells(1).Text

to

Dim nameAs String = e.NewValues["name"].ToString();Dim SplitAs String = e.NewValues["split"].ToString();

I guess above changes can solve your proble.

|||

In addition topooya.m's answer, try putting a break point and debug through your code.

|||

I tried that and getting this

Compiler Error Message:BC30203: Identifier expected.

Line 154:Me.SqlDataSource1.UpdateParameters.Clear()Line 155:Line 156:Dim nameAs String = e.NewValues["name"].ToString();Line 157:Dim SplitAs String = e.NewValues["split"].ToString();Line 158:

|||

Looks like u need to @.Name and @.split as the name of the parameters .. cause that whats ur sproc is expecting instead of Name and spilt

|||

YahoosSnake:

Line 156: Dim nameAs String = e.NewValues["name"].ToString();
Line 157: Dim SplitAs String = e.NewValues["split"].ToString();

You're getting the compiler error because the above code is not valid code. You are combining VB and C# style syntax. Use

Dim name As String = e.NewValues("name").ToString()
Dim Split As String = e.NewValues("split").ToString()

|||

DisturbedBuddha is right,

I used C# syntax to access NewValues. asDisturbedBuddha said you have to change NewValues["..."] to NewValues("...")

|||

How do i set up the web.confgire to run the debuger thorw vb.net 2005 i put this in the file already

<compilation debug="true" />

but i get this error

Unable to start debugging on the web server. Logon Fauilure, unknow username or bad password.

Where do i setup the username and password for my sever on the web.config file?

sql

I can't debug my SQL Server project

I'm coding a TVF in C# and the debugger doesn't stop at all. It used to work when I was coding scalar functions, but it stop working since I removed my assembly from the DB and register it manually to test my SQL scripts. I removed the assembly again from my DB and re-deployed it with VS.2005 hoping that will fix it, but it didn't work. Right now I can't debug.

Have anybody had a problem like this before? Any help will be appreciated.

Do you use your TVF in default test script in your VS project?|||Yes. The weird thing is that the debugger was working before, and I debugged scalar functions. But since I deployed the assembly manually and then removed it to deployed it from VS.2005, somehow the debugger stopped working.|||Check content of output window, you could find error messages here.|||

Got it. There was a problem with a commented section in query.

Thank you.

sql

I cannot delete, remove, rebuild, or repopulate fulltext catalogue.

I have SQL Server 7 on an NT server. The catalogue has
been working for a long time, however, it stopped and I
cannot seem to get it to repopulate. It stopped during an
incremental population. I have tried deleting it so I can
rebuild it, but whatever I try to do, I get the same
message: "Database is not full-text enabled yet". Can
anyone help?
Linda,
Could you review your server's Application Event log for any "Microsoft
Search" or MssCi source events (warnings, or errors) near the day & time
that the FT Catalog stopped working? Additionally, review the server System
Event log for any relate disk i/o warnings of low free disk space on both
your server's system disk drive (usually, the C:\ drive) or the drive where
the FT Catalog reside.
Most likely the FT Catalog is corrupt (and you may see a MssCi event with a
stack trace in it) and you may be in a "Catch-22" situation where you cannot
drop the FT Catalog (please try this), nor re-build it as well as not able
to run a Full or Incremental Population. IF so and depending upon the errors
in the Application event log, I have as sql script that you can "manually
de-reference" the FT Catalog, however, it is highly dependent on the type of
errors you are seeing and you may need to remove and re-install the FTS and
MSSearch components as well. Please, post any related application event
errors in your reply!
Thanks,
John
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:2865701c46458$a8cf3cf0$a501280a@.phx.gbl...
> I have SQL Server 7 on an NT server. The catalogue has
> been working for a long time, however, it stopped and I
> cannot seem to get it to repopulate. It stopped during an
> incremental population. I have tried deleting it so I can
> rebuild it, but whatever I try to do, I get the same
> message: "Database is not full-text enabled yet". Can
> anyone help?
|||John,
I examined all logs but could not find anything concerning
the FT catalog. The logs for that date are no longer
available. It seems that the server was rebooted while
the catalog was performing an incremental update, freezing
the catalog.
I tried to drop it, but again got the message "Database is
not full-text enabled Please run
sp_fulltext_database 'enable' . When I do that, the query
never finishes. I have to reboot the server to clear it.
Maybe the script can help?
Thanks!!
Linda
>--Original Message--
>Linda,
>Could you review your server's Application Event log for
any "Microsoft
>Search" or MssCi source events (warnings, or errors) near
the day & time
>that the FT Catalog stopped working? Additionally, review
the server System
>Event log for any relate disk i/o warnings of low free
disk space on both
>your server's system disk drive (usually, the C:\ drive)
or the drive where
>the FT Catalog reside.
>Most likely the FT Catalog is corrupt (and you may see a
MssCi event with a
>stack trace in it) and you may be in a "Catch-22"
situation where you cannot
>drop the FT Catalog (please try this), nor re-build it as
well as not able
>to run a Full or Incremental Population. IF so and
depending upon the errors
>in the Application event log, I have as sql script that
you can "manually
>de-reference" the FT Catalog, however, it is highly
dependent on the type of
>errors you are seeing and you may need to remove and re-
install the FTS and
>MSSearch components as well. Please, post any related
application event
>errors in your reply!
>Thanks,
>John
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2865701c46458$a8cf3cf0$a501280a@.phx.gbl...
an[vbcol=seagreen]
can
>
>.
>
|||Linda,
I emailed you the SQL Server 7.0 version to "manually de-reference" a FT
Catalog, please use it with caution as it requires modification to both
system tables as well as the registry hive. I highly recommend that you
backup both your database as well as the registry hive BEFORE using the
script as well as testing the procedure in a test environment prior to using
it.
Regards,
John
<anonymous@.discussions.microsoft.com> wrote in message
news:287e401c464fa$6a21ad10$a601280a@.phx.gbl...[vbcol=seagreen]
> John,
> I examined all logs but could not find anything concerning
> the FT catalog. The logs for that date are no longer
> available. It seems that the server was rebooted while
> the catalog was performing an incremental update, freezing
> the catalog.
> I tried to drop it, but again got the message "Database is
> not full-text enabled Please run
> sp_fulltext_database 'enable' . When I do that, the query
> never finishes. I have to reboot the server to clear it.
> Maybe the script can help?
> Thanks!!
> Linda
> any "Microsoft
> the day & time
> the server System
> disk space on both
> or the drive where
> MssCi event with a
> situation where you cannot
> well as not able
> depending upon the errors
> you can "manually
> dependent on the type of
> install the FTS and
> application event
> message
> an
> can
|||John,
Before I received your SQL I tried something that worked.
Since I couldn't stop the MSSearch engine, I changed the
startup from automatic to manual. Then I rebooted the
server. With MSSearch service off, I was then able to
manipulate the gatherlogs so I copied the entire folders
to another directory (as a backup). Then I deleted the
original folders, started the service, and
ran "sp_fulltext_database 'enable'" which worked this
time. I was then able to rebuild the fulltext catalogue
and repopulate it. The search is working fine now. You
were right...I think the files were corrupted. We are
still trying to find out how that happened.
Thanks for your help. I will keep the SQL in case that
happens again.
Linda
>--Original Message--
>Linda,
>I emailed you the SQL Server 7.0 version to "manually de-
reference" a FT
>Catalog, please use it with caution as it requires
modification to both
>system tables as well as the registry hive. I highly
recommend that you
>backup both your database as well as the registry hive
BEFORE using the
>script as well as testing the procedure in a test
environment prior to using[vbcol=seagreen]
>it.
>Regards,
>John
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:287e401c464fa$6a21ad10$a601280a@.phx.gbl...
concerning[vbcol=seagreen]
freezing[vbcol=seagreen]
is[vbcol=seagreen]
query[vbcol=seagreen]
it.[vbcol=seagreen]
for[vbcol=seagreen]
near[vbcol=seagreen]
review[vbcol=seagreen]
drive)[vbcol=seagreen]
a[vbcol=seagreen]
as[vbcol=seagreen]
re-[vbcol=seagreen]
has[vbcol=seagreen]
and I[vbcol=seagreen]
during[vbcol=seagreen]
I
>
>.
>
|||You're welcome, Linda,
As they say, there are many ways to 'skin a cat' (not that i'm anti-cat ;-),
but there are many ways to solve a problem and to further mix my metaphors,
the proof is in the pudding, i.e., whatever works, go with it!
Regards,
John
<anonymous@.discussions.microsoft.com> wrote in message
news:2d96a01c46a6d$2d545ea0$a501280a@.phx.gbl...[vbcol=seagreen]
> John,
> Before I received your SQL I tried something that worked.
> Since I couldn't stop the MSSearch engine, I changed the
> startup from automatic to manual. Then I rebooted the
> server. With MSSearch service off, I was then able to
> manipulate the gatherlogs so I copied the entire folders
> to another directory (as a backup). Then I deleted the
> original folders, started the service, and
> ran "sp_fulltext_database 'enable'" which worked this
> time. I was then able to rebuild the fulltext catalogue
> and repopulate it. The search is working fine now. You
> were right...I think the files were corrupted. We are
> still trying to find out how that happened.
> Thanks for your help. I will keep the SQL in case that
> happens again.
> Linda
> reference" a FT
> modification to both
> recommend that you
> BEFORE using the
> environment prior to using
> concerning
> freezing
> is
> query
> it.
> for
> near
> review
> drive)
> a
> as
> re-
> has
> and I
> during
> I
|||I would like a copy of that script if it's still
available! Thanks!
>--Original Message--
>Linda,
>I emailed you the SQL Server 7.0 version to "manually de-
reference" a FT
>Catalog, please use it with caution as it requires
modification to both
>system tables as well as the registry hive. I highly
recommend that you
>backup both your database as well as the registry hive
BEFORE using the
>script as well as testing the procedure in a test
environment prior to using[vbcol=seagreen]
>it.
>Regards,
>John
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:287e401c464fa$6a21ad10$a601280a@.phx.gbl...
concerning[vbcol=seagreen]
freezing[vbcol=seagreen]
is[vbcol=seagreen]
query[vbcol=seagreen]
it.[vbcol=seagreen]
for[vbcol=seagreen]
near[vbcol=seagreen]
review[vbcol=seagreen]
drive)[vbcol=seagreen]
a[vbcol=seagreen]
as[vbcol=seagreen]
re-[vbcol=seagreen]
has[vbcol=seagreen]
and I[vbcol=seagreen]
during[vbcol=seagreen]
I
>
>.
>

I can't debug my SQL Server project

I'm coding a TVF in C# and the debugger doesn't stop at all. It used to work when I was coding scalar functions, but it stop working since I removed my assembly from the DB and register it manually to test my SQL scripts. I removed the assembly again from my DB and re-deployed it with VS.2005 hoping that will fix it, but it didn't work. Right now I can't debug.

Have anybody had a problem like this before? Any help will be appreciated.

Do you use your TVF indefault test script in your VS project?
|||Yes. The weird thing is that the debugger was working before, and I debugged scalar functions. But since I deployed the assembly manually and then removed it to deployed it from VS.2005, somehow the debugger stopped working.|||Check content of output window, you could find error messages here.|||

Got it. There was a problem with a commented section in query.

Thank you.

I can not start (initialise) report server status from reporting services configuration ma

I have reporting services installed on my machine and just a couple of days back every thing was working correctly until some thing i have no idea of happened and screwed up every thing. No i can not access report manager and report sever. When i open reporting services configuration manager, the server status is not initialised and results in following error in the computers event log.

Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

File name: 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' --> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Accessing report manager from the browser also throws this exception.

Server Error in '/ReportServer$SQLExpress' Application.

---

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer' because access is denied.

Source Error:

[No relevant source lines]

Source File:c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line:0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

I'm having the same problem and I was just wondering if you managed to get your report server working

|||

Okay so I got it working.

I got this solution fromAaron Stebner's blog.

Create a batch file with the following commands:

cd %SYSTEMROOT%\WinSXS
for /D %%i in (*vc80*) do rd %%i /s /q
del manifests\*vc80* /q
cd policies
for /D %%i in (*vc80*) do del %%i\* /q

Run the batch file

Then run a repair install of SQL reporting services.

And it should come back.

|||

On my side, i got it working by just un-installing and then re-installing reporting services.

I can no longer connect to my SQL Server Express 2005 from Manager Studio Express

Everything was working fine. I have been able to connect using windows authentication. Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users. After doing this I now get an error when I try to conenct the management studio to the SQL server.

I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server. This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.

Does anyone know how I can attach to the server? Or, do I need to somehow remove the server and create a new one? How would I do that?

Thanks in advance for any input.

Hi,

did you disable remote connections by accident ? If so, see if this feature is enabled under the Serface Configuration. See more detaisl on the screencast on my site.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

I am unable to access Analysis Server with AMO

Hi All,

I developed one web service,Here i am making connection to the Analysis Server and working on Database,cubes,partitions.when i deploy this code it is failing to run and it is throwing error like."object reference not set to an instance of the object",so i added Impersonate = true code in my web service config file then it is working fine.

( am expecting My Analysis Server is not allowing to create object ,how to handle this)

But what i want is it should work with out providing Impersonate in config.

Help is needed it is very urgent.

Thanks in Advance.

You code has to run under the priviledges of some sort of account. There are only 3 possible configurations that I can think of.

1. Setup an account in the application pool (if using IIS6)

2. Set a fixed account using the <identity impersonate="true" userName="..." password="..." /> tag in the web.config

3. Set the current client account to be impersonated using <identity impersonate="true" /> in the web.config

Note that 3) will only work if the web service and SSAS are on the same machine, or if you have Kerberos configured. Otherwise the user credentials will not pass from client to Web server to SSAS server.

I am trying to work out datediff for just mon-fri between datefiel

I am trying to find the number of working days between two date fields.
I have datediff(dd, first date, second date) as turnaround time,
But this includes saturdays and sundays in the output. I need to find the
number of days, only including monday to friday, between the two date fields.
It helps to have a Calendar table in your database:
CREATE TABLE Calendar
(caldate DATETIME NOT NULL PRIMARY KEY,
workingday CHAR(1) NOT NULL CHECK (workingday IN ('Y','N')) DEFAULT 'Y')
Populate it with as many years as you'll ever need:
INSERT INTO Calendar (caldate) VALUES ('20000101')
WHILE (SELECT MAX(caldate) FROM Calendar)<'21001231'
INSERT INTO Calendar (caldate)
SELECT DATEADD(D,DATEDIFF(D,'19991231',caldate),
(SELECT MAX(caldate) FROM Calendar))
FROM Calendar
Set the non-working days:
UPDATE Calendar SET workingday = 'N'
WHERE DATENAME(DW,caldate) IN ('Saturday','Sunday')
You'll probably want to record any public holidays in the same way.
Now you can easily compute the number of working days between two dates:
SELECT COUNT(*)
FROM Calendar
WHERE caldate BETWEEN @.first_date AND @.second_date
AND workingday = 'Y' ;
David Portas
SQL Server MVP
|||Hi Shaun,
Check if this helps...
SELECT DATEDIFF(dd, 'startdate', 'enddate')
- DATEDIFF(ww, 'startdate', 'enddate') *2
Thanks
Yogish

I am trying to work out datediff for just mon-fri between datefiel

I am trying to find the number of working days between two date fields.
I have datediff(dd, first date, second date) as turnaround time,
But this includes saturdays and sundays in the output. I need to find the
number of days, only including monday to friday, between the two date fields
.It helps to have a Calendar table in your database:
CREATE TABLE Calendar
(caldate DATETIME NOT NULL PRIMARY KEY,
workingday CHAR(1) NOT NULL CHECK (workingday IN ('Y','N')) DEFAULT 'Y')
Populate it with as many years as you'll ever need:
INSERT INTO Calendar (caldate) VALUES ('20000101')
WHILE (SELECT MAX(caldate) FROM Calendar)<'21001231'
INSERT INTO Calendar (caldate)
SELECT DATEADD(D,DATEDIFF(D,'19991231',caldate)
,
(SELECT MAX(caldate) FROM Calendar))
FROM Calendar
Set the non-working days:
UPDATE Calendar SET workingday = 'N'
WHERE DATENAME(DW,caldate) IN ('Saturday','Sunday')
You'll probably want to record any public holidays in the same way.
Now you can easily compute the number of working days between two dates:
SELECT COUNT(*)
FROM Calendar
WHERE caldate BETWEEN @.first_date AND @.second_date
AND workingday = 'Y' ;
David Portas
SQL Server MVP
--|||Hi Shaun,
Check if this helps...
SELECT DATEDIFF(dd, 'startdate', 'enddate')
- DATEDIFF(ww, 'startdate', 'enddate') *2
Thanks
Yogish

I am trying to work out datediff for just mon-fri between datefiel

I am trying to find the number of working days between two date fields.
I have datediff(dd, first date, second date) as turnaround time,
But this includes saturdays and sundays in the output. I need to find the
number of days, only including monday to friday, between the two date fields.It helps to have a Calendar table in your database:
CREATE TABLE Calendar
(caldate DATETIME NOT NULL PRIMARY KEY,
workingday CHAR(1) NOT NULL CHECK (workingday IN ('Y','N')) DEFAULT 'Y')
Populate it with as many years as you'll ever need:
INSERT INTO Calendar (caldate) VALUES ('20000101')
WHILE (SELECT MAX(caldate) FROM Calendar)<'21001231'
INSERT INTO Calendar (caldate)
SELECT DATEADD(D,DATEDIFF(D,'19991231',caldate),
(SELECT MAX(caldate) FROM Calendar))
FROM Calendar
Set the non-working days:
UPDATE Calendar SET workingday = 'N'
WHERE DATENAME(DW,caldate) IN ('Saturday','Sunday')
You'll probably want to record any public holidays in the same way.
Now you can easily compute the number of working days between two dates:
SELECT COUNT(*)
FROM Calendar
WHERE caldate BETWEEN @.first_date AND @.second_date
AND workingday = 'Y' ;
--
David Portas
SQL Server MVP
--|||Hi Shaun,
Check if this helps...
SELECT DATEDIFF(dd, 'startdate', 'enddate')
- DATEDIFF(ww, 'startdate', 'enddate') *2
--
Thanks
Yogish

I am new to this SQL Server Reporting Services. HELP

Hi Friends,

I am working on .Net tech with SQL Server 2000.

I want to update my technical skills to DW.

I mean, i planning to learn SQL Server Reporting Services and i am new this topic.

Please help me........

thanks

babu

my dear friend ,

i am also new to ssrs ... check this link

http://www.crystalreportsbook.com/SSRSandCR_Overview.asp

http://safari.oreilly.com/0596529414

atleast this will give little bit idea abt ssrs... if u get any resources...plz update here.......so that every one will know

u can also use microsoft virtual lab ...But as a beginneer still i am finding a resource for good foundation in ssrs......

I am new to this OLAP & OLTP - Analysis Services.

Hi,

I am working on .Net tech with SQL Server 2000.

I want to update my technical skills to DW.

I mean, i planning to learn Analysis Services and i am new this topic.

Please help me........

thanks

babu

http://www.databasejournal.com/features/mssql/article.php/1429671

maybe this will be a good start

I am new this SSIS, Please help me.

Hi,

I am working on .Net tech with SQL Server 2000.

I want to update my technical skills to DW.

I mean, i planning to learn SSIS and i am new this topic.

Please help me........

thanks

babu

Two options-

Pay for Books and/or Training

or

Teach yourself, perhaps get hold of SQL Server 2005, perhaps try the free documentation and tutorials? Have you you even looked on the MS site for this?

http://msdn2.microsoft.com/en-us/library/ms167031.aspx ?

|||

thanks for reply. I am asking is there any free documents and tutorials are available in any free sites.

thanks

Babu

|||

There are tutorials in SQL Server Books Online.

Also, try the followink searches:

http://search.live.com/results.aspx?q=ssis+tutorials&mkt=en-us&FORM=OPNSCH

http://search.live.com/results.aspx?q=ssis+examples&form=QBRE

|||

Sridhar,

Apart from msdn and latest downloadable samples from microsoft site, There are lots of online resources.

1) www.sqlis.com by Darren Green and Allan Mitchell

2) Download Free Samples at Wrox official site

2) Blogs by Jamie Thomson,Rafael Salas, Brian Knight, Donald Farmer, Kirk Haselden, Scott Barret, John welch, Ashwin Sharma, Phil Brammer, Michael Entin, Alberto Ferari

Many Thanks

Subhash Subramanyam

|||I suggest you download tutorial from www.microsoft.com/downloads/details.aspx?FamilyID=B1145E7A-A4E3-4D14-B1E7-D1D823B6A447&displaylang=en.
It's great for the begining.

I am having a problem with percision which appears to be a documented bug is there a work around

I have been working on an application which require as much percision as we can get. We have defined all numeric values as (38,16) however when ever we divide a number by the result of a built in function it truncate the percision to 5 decimal place this cause us to have a small but enoying loss in the numbers being caculated we need a minimuim of 8 decimal places or better is there a work around or solution for this problem in sql server 2005. The more percision the better.

example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345

the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = .00000

if it is a reporducable bug use the product feedback center to report the bug:

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220

Otherwise you can use the SQL Server Data Access forum to ask your question

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

|||

Hi Caverman1,

It isn't bug. I resolve this issue in other thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=661591&SiteID=1

Good coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

I am having a problem with percision which appears to be a documented bug is there a work ar

I have been working on an application which require as much percision as we can get. We have defined all numeric values as (38,16) however when ever we divide a number by the result of a built in function it truncate the percision to 5 decimal place this cause us to have a small but enoying loss in the numbers being caculated we need a minimuim of 8 decimal places or better is there a work around or solution for this problem in sql server 2005. The more percision the better.

example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345

the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = .00000

if it is a reporducable bug use the product feedback center to report the bug:

http://connect.microsoft.com/Main/content/content.aspx?ContentID=2220

Otherwise you can use the SQL Server Data Access forum to ask your question

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

|||

Hi Caverman1,

It isn't bug. I resolve this issue in other thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=661591&SiteID=1

Good coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

Hyperlinks is SSRS 2005

Hi All,
Please help me in using the hyperlinks in the SSRS to call a page within a
particular frame.
I have been working on a project where i a using HTML frames and SSRS is a
part of the right frame.i have to make sure that the URL
link(eg:-http://www.google.com) opens up in the right frame,and not in a
separate window.
This is how i tried doing it.
1.In a report i have put a image control.
2.I go to the properties of the image, and go to "Navigation" tab and select
"Jump to URL" combo box and edit the expression.
3.The expression that i have given is:
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
where fraRightFrame is the frame,in which want to open the URL.
After i deploy this report and try clicking on the link, a page loads with
the message "Page cannot be displayed" and in the address bar, i can see the
above javascript.
Please help me as to how i can call a URl in the same frame where the
report is running.
Note:-
I am using SQL server reporting services 2005 with SP1 along with Shreapoint
server 2003.
Waiting for your responce,
Thanks in advance,
Regards,
Archana KamathPlease also note that Javascript works fine in the report.That is when i try
opening the report using the report manager /reportserver it works fine.When
i click the link, the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Hi All,
> Please help me in using the hyperlinks in the SSRS to call a page within a
> particular frame.
> I have been working on a project where i a using HTML frames and SSRS is a
> part of the right frame.i have to make sure that the URL
> link(eg:-http://www.google.com) opens up in the right frame,and not in a
> separate window.
> This is how i tried doing it.
> 1.In a report i have put a image control.
> 2.I go to the properties of the image, and go to "Navigation" tab and select
> "Jump to URL" combo box and edit the expression.
> 3.The expression that i have given is:-
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> where fraRightFrame is the frame,in which want to open the URL.
> After i deploy this report and try clicking on the link, a page loads with
> the message "Page cannot be displayed" and in the address bar, i can see the
> above javascript.
> Please help me as to how i can call a URl in the same frame where the
> report is running.
> Note:-
> I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> server 2003.
> Waiting for your responce,
> Thanks in advance,
> Regards,
> Archana Kamath
>|||Hi All,
The script
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
worked fine.
Many Thanks
Archana
"Archana" wrote:
> Please also note that Javascript works fine in the report.That is when i try
> opening the report using the report manager /reportserver it works fine.When
> i click the link, the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> > Hi All,
> >
> > Please help me in using the hyperlinks in the SSRS to call a page within a
> > particular frame.
> >
> > I have been working on a project where i a using HTML frames and SSRS is a
> > part of the right frame.i have to make sure that the URL
> > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > separate window.
> >
> > This is how i tried doing it.
> > 1.In a report i have put a image control.
> > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > "Jump to URL" combo box and edit the expression.
> > 3.The expression that i have given is:-
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> >
> > where fraRightFrame is the frame,in which want to open the URL.
> >
> > After i deploy this report and try clicking on the link, a page loads with
> > the message "Page cannot be displayed" and in the address bar, i can see the
> > above javascript.
> >
> > Please help me as to how i can call a URl in the same frame where the
> > report is running.
> >
> > Note:-
> > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > server 2003.
> >
> > Waiting for your responce,
> >
> > Thanks in advance,
> > Regards,
> > Archana Kamath
> >|||Hi,
can you explain in detail how the script solved the problem.
I cannot see any different between the script that you posted in the first
post. both
seems to be the same. Can you please explain in detail how it solved the
problem.
Thanks
Bava
"Archana" wrote:
> Hi All,
> The script
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> worked fine.
> Many Thanks
> Archana
> "Archana" wrote:
> >
> > Please also note that Javascript works fine in the report.That is when i try
> > opening the report using the report manager /reportserver it works fine.When
> > i click the link, the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying "Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > particular frame.
> > >
> > > I have been working on a project where i a using HTML frames and SSRS is a
> > > part of the right frame.i have to make sure that the URL
> > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > separate window.
> > >
> > > This is how i tried doing it.
> > > 1.In a report i have put a image control.
> > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > "Jump to URL" combo box and edit the expression.
> > > 3.The expression that i have given is:-
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > >
> > > where fraRightFrame is the frame,in which want to open the URL.
> > >
> > > After i deploy this report and try clicking on the link, a page loads with
> > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > above javascript.
> > >
> > > Please help me as to how i can call a URl in the same frame where the
> > > report is running.
> > >
> > > Note:-
> > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > server 2003.
> > >
> > > Waiting for your responce,
> > >
> > > Thanks in advance,
> > > Regards,
> > > Archana Kamath
> > >|||Hi,
There was some problem in my sharepoint page and not in the script, which
was not letting the report to open in the specified frame.
What i did was,created a new sharepoint page with just one page viewer web
part and included the report in it which had the hyperlink and the script.
On click of the hyperlink,new page got opened in the same frame as required
by me,solving my problem.
Best Regards,
Archana Kamath
"Bava Mani" wrote:
> Hi,
> can you explain in detail how the script solved the problem.
> I cannot see any different between the script that you posted in the first
> post. both
> seems to be the same. Can you please explain in detail how it solved the
> problem.
> Thanks
> Bava
> "Archana" wrote:
> > Hi All,
> >
> > The script
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > worked fine.
> > Many Thanks
> > Archana
> >
> > "Archana" wrote:
> >
> > >
> > > Please also note that Javascript works fine in the report.That is when i try
> > > opening the report using the report manager /reportserver it works fine.When
> > > i click the link, the page ('google') gets loaded.
> > >
> > > But when i include the same report in my sharepoint site ,using the page
> > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > cannot be displayed" and the javascript gets pasted on the address bar.
> > >
> > > Any idea why this behaviour?
> > > Many thanks inadvance,
> > > Regards,
> > > Archana
> > > "Archana" wrote:
> > >
> > > > Hi All,
> > > >
> > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > particular frame.
> > > >
> > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > part of the right frame.i have to make sure that the URL
> > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > separate window.
> > > >
> > > > This is how i tried doing it.
> > > > 1.In a report i have put a image control.
> > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > "Jump to URL" combo box and edit the expression.
> > > > 3.The expression that i have given is:-
> > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > >
> > > > where fraRightFrame is the frame,in which want to open the URL.
> > > >
> > > > After i deploy this report and try clicking on the link, a page loads with
> > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > above javascript.
> > > >
> > > > Please help me as to how i can call a URl in the same frame where the
> > > > report is running.
> > > >
> > > > Note:-
> > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > server 2003.
> > > >
> > > > Waiting for your responce,
> > > >
> > > > Thanks in advance,
> > > > Regards,
> > > > Archana Kamath
> > > >|||Thanks for the reply.
"Archana" wrote:
> Hi,
> There was some problem in my sharepoint page and not in the script, which
> was not letting the report to open in the specified frame.
> What i did was,created a new sharepoint page with just one page viewer web
> part and included the report in it which had the hyperlink and the script.
> On click of the hyperlink,new page got opened in the same frame as required
> by me,solving my problem.
> Best Regards,
> Archana Kamath
>
> "Bava Mani" wrote:
> > Hi,
> > can you explain in detail how the script solved the problem.
> > I cannot see any different between the script that you posted in the first
> > post. both
> > seems to be the same. Can you please explain in detail how it solved the
> > problem.
> >
> > Thanks
> > Bava
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > The script
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > worked fine.
> > > Many Thanks
> > > Archana
> > >
> > > "Archana" wrote:
> > >
> > > >
> > > > Please also note that Javascript works fine in the report.That is when i try
> > > > opening the report using the report manager /reportserver it works fine.When
> > > > i click the link, the page ('google') gets loaded.
> > > >
> > > > But when i include the same report in my sharepoint site ,using the page
> > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > >
> > > > Any idea why this behaviour?
> > > > Many thanks inadvance,
> > > > Regards,
> > > > Archana
> > > > "Archana" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > > particular frame.
> > > > >
> > > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > > part of the right frame.i have to make sure that the URL
> > > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > > separate window.
> > > > >
> > > > > This is how i tried doing it.
> > > > > 1.In a report i have put a image control.
> > > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > > "Jump to URL" combo box and edit the expression.
> > > > > 3.The expression that i have given is:-
> > > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > > >
> > > > > where fraRightFrame is the frame,in which want to open the URL.
> > > > >
> > > > > After i deploy this report and try clicking on the link, a page loads with
> > > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > > above javascript.
> > > > >
> > > > > Please help me as to how i can call a URl in the same frame where the
> > > > > report is running.
> > > > >
> > > > > Note:-
> > > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > > server 2003.
> > > > >
> > > > > Waiting for your responce,
> > > > >
> > > > > Thanks in advance,
> > > > > Regards,
> > > > > Archana Kamath
> > > > >