can SQL Profiler ('05) look into User Defined Functions (UDFs)?

particularly table valued UDFs that may cause other udfs, etc.

what settings/events do I need to see inside and get each statement or at least each seperate UDF that is executed internally?

Try SP:StmtStarting, SP:StmtCompleted events. They are under "Stored Procedures" event category.

can objects in sql server change your nt login password

hi guys,
i was wondering if there is a bug in sql server 2000 that upon changing settings in the sqlserver agent or sqlserver services that it will actually change your nt user password.
a strange occurence happened to me i switched the sqlmail to a different outlook profile that is MAPI compliant i had to stop and start the sql server agent upon restart it said it could not log me in b/c my nt logon failed (i guess you can figure out by now that i have authentication as NT in my set up of sql server agent). well me knowing microsoft products i was like ah i will just reboot the machine) well upon reboot my administrator password which is empty "null value"no longer is valid.
now noone in the company said that they changed the administrator password and it is not logged into a domain so the machine is not on our companys network. we log in local to the machine as the administrator. the last things that i played around in with sql server was replication setting it up as a publisher and deleteing it and changing a mapi profile. is there anywhere in sql 2000 that messing with any setting that it will actually affect your windows nt user login?? i know i cant be loosing my mind here and i hope someone at my company wouldnt sabotage my machine. right now i have two options i can reinstall win 2000 and choose repair hoping that i will not lose my sql 2000 info or i can try a password cracker. any suggestions that might of cause this to happen?
regards,
Robertof course Microsoft is always providing use with new features, but I doubt this unlikely. What you described sounds exactly as if the user password had been changed at the OS level. The password could have been changed by mistake.

Can not start Report Builder!

I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default.

When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or network service provider." I don't think it's about permission issues. I am using the administrator group user. Besides the report builder activiation part, I can browser every part on report server website without error.

Do appreciate your help!!!

Details provided by server are
"PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://myserver/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [11/22/2005 10:13:33 AM] : Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [11/22/2005 10:13:33 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (500) Internal Server Error.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Silly question, but did you install the .net 2.0 runtime on your client box?|||Yes, .net 2.0 is installed. Even I tried both released one and Beta 2. Both of them do not work.

Weird part is I can launch Report Builder successfully from wireless laptop. But when I connected laptop back to wired network, same error came back. I suspect it's due to network settings.

Any one has the similar problem?|||

Having similar kind of issue. Error summary says this.

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine

It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.

Pleaseeee HELP!

Thanks,

Can not start Report Builder!

I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default.

When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or network service provider." I don't think it's about permission issues. I am using the administrator group user. Besides the report builder activiation part, I can browser every part on report server website without error.

Do appreciate your help!!!

Details provided by server are
"PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://myserver/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [11/22/2005 10:13:33 AM] : Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [11/22/2005 10:13:33 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (500) Internal Server Error.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Silly question, but did you install the .net 2.0 runtime on your client box?|||Yes, .net 2.0 is installed. Even I tried both released one and Beta 2. Both of them do not work.

Weird part is I can launch Report Builder successfully from wireless laptop. But when I connected laptop back to wired network, same error came back. I suspect it's due to network settings.

Any one has the similar problem?|||

Having similar kind of issue. Error summary says this.

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine

It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.

Pleaseeee HELP!

Thanks,