Search results for query: *

Does anyone know if there is a way to make the drop-downs for parameters in Reporting Services Auto-Expand? Right now, when I select a letter, it does go down to that letter in the list but it does not work beyond the first letter. I am used to drop-downs in Access etc. that allow this...

If I have an existing report on a Report Server, and I modify the report in Visual Studio, then deploy it, only some of the information gets updated on the server. For example, I changed a report parameter from type string to Date/Time and that got updated on the server, but when I added a...

I need to get the name of the Domain that my SQL Server is in using Transact SQL. Is there a function that does this? Like Select GetDomainNameOfMySQLServer() Thanks in advance!

What is the best way to do the following: I have a URL that contains an XML file. I need to easily take that XML file and put it in to a table in SQL Server. I will know in advance the fields in the XML file and in the table. I have seen some code using OpenXML, OpenRowset etc. but I have not...

I want to know if there is a "Best Pracice" to what I am doing. I have a table with several fields and I know that 2 of the fields should ideally be sorted for best performance, so I added a cluster index that uses both of those fields. What I'd like to know is, do I need to add additional...

Is there any way to embed a Word Document, Excel Document etc. using OLE or some other means directly into a Reporting Services report the way it can be done in for example Microsoft Access? If so, how? And if not, what is the easiest way to accomplish what I am trying to do, and that is - to...

I have a Terminal Services machine which users log in to and then go to my Reporting Services web site (ServerName\Reports). Anyway, for some reason, all users are getting prompted for their UserNames/passwords when they go to the web site. I added the web site to the trusted zone. Also...

This is going to be a hard one but I am hoping that someone out there has experienced this and can help me. I have a .Net user control in a DLL. I have embedded this control on to an MS Access Form and it works fine. The Access form thinks it's an ActiveX control, renders it and I can...

In Management Studio, when you delete a DB, there is a check box that optionally allows you to drop all existing connections. Is there an equivalent in T-SQL? So far, I have found that the "Drop Database" command has no parameters that can be used for this. And if not, how can I, using T-SQL...

First some background: In classic VB and VB.Net on Windows XP and higher machines, there is a way of avoiding having to use the registry for COM Components. Called Registration Free COM, all that is required is a manifest file for the application to be in the same folder as your applcation or...

The code below has worked for years on my SQL Server 2000 database. I recently moved the same code to SQL Server 2005 and it worked fine too. But I just installed the DB that contains this procedure on to a new SQL Server 2005 machine and for some reason I am getting the message 'A cursor with...

Does anyone have any experience using Perforce with the MS Access IDE? If you have gotten it to work, I would be greatly interested in knowing how, as I have been getting errors trying to get it to work. If you have not used Perforce, but have used any other Source Control program with the...

I am building many User Controls. Each of these is used in an MS Access application (using ActiveX / COM). I have gotten as far as creating individual User Controls, registering them using RegAsm and using them in MS Access. All of this works fine. But right now, each user control sits in it's...

Does anyone have experience with putting SQL Server on the same physical machine as a Windows Terminal Server 2003? I know Microsoft might frown upon it, but if I have enough memory and enough CPU power, is there a problem? I have a client with only 5 users and the Application they need to run...

I would like to be able to open a form created in .Net from my VB6 or Microsoft Access application. I know that you can create controls/assemblies etc. in .Net and have them exposed as COM objects, so I would think this were possible. Is it? If so, how do I go about doing it? Thanks in advance!!!

I am a consultant for several Terminal Server Machines at several different customers. Unfortunately, there are multiple administrators on the machines that I am using - administrators who work for my clients. The thought occured to me that while i am working on their machines (sometimes...

I have either discovered a bug or I am doing something totally wrong, but when I try to subtract days off of a Date field using DateAdd in a constraint, SQL Enterprise Manager is saying the constarint is not valid. My code is very simple. The constraint that does not work is [MyDateTime1] <...

I have an application that uses multiple instances of a form, so I instantiate it using Dim MyForm2 As New Form_MyForm When I try to refer to the form by name (i.e Forms("FormName").Name it does not work. MyForm2.Name does work and returns the name of the form, as does forms(3).name, i.e...

I need to be able to use the same underlying form as a subform on multiple forms. I know that sounds confusing but here is what I mean. Imagine opening up a form, form1 and a subform, subForm1 is displayed there as a subform. Clicking a button on that subform opens up another form, Form2 that...

Why does Microsoft recommend not putting SQL Server 2000 on the same box as a machine used for Terminal Services (2003). Assuming there is enough CPU power and memory and all the other potential hardware bottlenecks are taken care of? I know this is not ideal, but I want to understand the...