I have SQL Server Manager 8.00.2039 installed because I have one program
(app) installed that requires it be installed. For the first little
while when I had SQL server installed it would only show up in the
taskmanager tray, now MOST of the time, it shows up as a popup on my
desktop and also in my task tray when I first start XP (SP2). It stays
there until I close it. Is there a way to prevent the SQL from popping
up?
Please feel free to redirect me if this has been previously addressed. I've read through the FAQ post and searched the forums, and as yet haven't found anything relevant on Google so I'm hoping you folks can help.
I am using SQL Server 2005 Express Edition on a fully patched Windows 2000 Server, and for some reason the database just will not start up when the machine starts or reboots. The service starts fine if I go start it by hand though. This is obnoxious because it prevents me from running fully automated updates to the box since that reboots it at least once a week on "patch Tuesday".
Here are what my related services and their startup types look like:
SQL Server (MSSQLSERVER) Automatic SQL Server Active Directory Helper Disabled SQL Server Browser Disabled SQL Server VSS Writer Manual
This is a production machine so I'd prefer not to run any services I don't have to. All this database needs to do is sit there and get hit by a local Cold Fusion instance that talks to it by TCP/IP. Any administration on it I tend to do locally with Management Studio Express by remotely logging into the server on it's internal IP.
The really weird thing is, I have these services configured exactly the same on development environments I've created in Windows XP and Windows 2003 Server Standard Edition. This seems to be specific to Windows 2000 Server, and I just can't figure it out...
I am having a problem connecting to my SQL Server 2005 database at the same time with SQL Management Studio Express and from the website at the same time. Everytime I want to view any pages in my site that access the database, I have to close management studio and restart the server for some reason or i get a failed login error message. Is it NOT possible to work on the database at the same time as viewing pages in the website that access the database? This freaking error is realy starting to bug me. I sure hope that there is a work around or something for this.
Hello, does anyone hate the new interface where you manage the Table Relationships, Indexes, and etc?
I hate it a lot for these reasons. 1) Dialog window cannot be resized (really really annoying) 2) The Table-Relationship configuration dialog window is not as convenient to use as SQL Server 2000 Enterprise Manager.
I hope this is the correct place to provide feedback and I hope this will get modified a bit in the next service pack (or) update....
I have installed SQL7 Gold on a client running W98. Every time I boot a dial-up window loads and pauses the boot process. Pressing Esc removes it. Is there a SQL 7 registry setting that can stop this?
Here is a new one for me. I added the /3GB switch to the boot.ini, restarted the server and now receive a number of messages when the OS tries to load.
Explorer.exe - Application Error The application failed to initialize properly.
If I click OK the server sits on a blue screen with no information on the screen.
The other messages are the result of me trying to do anything within Task Manager, with the exception of rebooting the server. These messages make sense since Explorer.exe had a problem.
The server has the following configuration.
HP DL580 Windows Server 2003 Enterprise Edition - SP2 SQL Server 2000 Enterprise Edition - SP3a 14GB Memory (4) dual core procs PAE is enabled in the boot.ini
If I remove the /3GB the OS starts without a problem. Any suggestions?
We are trying to setup a Virtual Machine for our developers and would like to put SQL Server 2014 (Developer Edition)pre-installed. Each of our devs have their own MSDN accounts so they would have access to their own installers / product keys.So, two questions:How do we pre-install it without a product key or install it then remove the product key?How can they change the product key once they boot up?
I'm looking for a way to popup a message from my .asp program for users under the following scenario:
(1) user enters an id number in a field on Page A and clicks on a link. (2) .asp program runs a query against a bunch of tables and then calls another .asp program which presents the user with the data extracted via the query on Page B.
I'd like to pop up a message box when the user clicks on the link in #(1) above (something like "Retrieving Information...please wait") until the screen #2 with the data is displayed.
but the message doesn't pop up until the data has already been retrieved. This is an application that is going away in the next year and a half so, rather than tweak it to see if the query time can be decreased, I'm told I should popup this message. Thank you, Jeff
I'm trying to find a way to put in a hyperlink to a url so the url linked to comes up in a new popup window and leaves the original report visible. Any help greatly appreciated.
In my report, I would like to have the following functionality :
The report will have a table with table header columns. If the user clicks on the header column, a window or text box should show up specifying the rules how that cloumn is calculated.
I can do that through sub-report, but I cannot use subreport, according to our specifications.
I just added a post but I don't see it so here I go agian, sorry if it shows up later and there ends up being two of them. I started getting the error message - SQL Dumper Library failed ... Please reinstall... it doesn't say what to reinstal. Does anyone know if this is part of Office or XP? My problem started when I added Office 2007 and the additional Business contacts program from the web site. I did get SQL 2005 and installed it but it says it isn't working. When I click to repair it, it wants the disk, again I don't know what disk or program it wants, although it will not fix it from the XP disk. Any help would be appreciated!
I want a hiperlink on my country sales reports. When user will click on this hiperlink one popup window will open(Popup report). This popup report will contain some input parameter eg list box of sales person name and list of country to be selected select.
One user will select country germany and sales person as Mr Bin and click go on the poup report I want the popup report to be closed and based on the input(country germany and sales person as Mr Bin ) want my country sales reports to get updated.
I am new-bie to reporting services 2005 and using it from last 1month.
I have interesting problem.
I have to pass some common input parameters to 10 of detail report. I want a popup report having those parameters.
So my detail report will have a link for that popup report once user click a popup window will open(popupreport). User can select the input parameter and click go on popup report then these parameter will be passed to the detail report.
I thing it is possible using ="javascript:void window.open()"
but i donot exact syntaxt?
Where should I pass in Jump to report ot Jump to Url?
Hey guys, I bet you didn't guess it but I'm posting here because i need help :P
What I'm trying to do is create a procdure that will run a task on the first Working day of the week. Normally monday but then theres public holidays etc etc.
on a normal week the task runs monday, on public holiday weeks it is tuesday, and christmas even pushs it back to wednesday.
so far im using the dts designer to do this
What I have is: a table with the last run date(not sure I even need this now) a table with a list of public holidays(date) along with a year column
a sql statment getting the last ran date and storing it into a global variable glastrundate
a activex vbscript getting the current year, which is then stored into a globalvariable(gcurrentyear)
then gcurrentyear is then used in a select statement to get the public holidays that are in that year, which are then stored to a rowset (gpubdays) (select pubdays from tbl_pubdays where pubyear = ?)
Now the problem, I am trying to use another axtivex script to check the current date against each row in the global gpubdays. well really I just can't get the for each loop to work, was trying to use it like: for each row(or pubday) in gpubdays if day = today then task fails and will not run the rest of the procedure end if next
sorry if it isnt very clear, still kinda new to SQL server
thanks if you help ^_^
ps. please dont go writing all the code for me, just a nudge in the general right direction
I know I shouldn't rely on sysdepends because it's got all sorts of problems with broken dependency chains, etc. But it's better than nothing for finding dependencies, short of rolling your own t-sql parser. So I use sysdepends anyway, with all its faults. I just don't rely on it. anyway, to the point, just an fyi really:
Here's something about sysdepends discovered today that annoys me. If you introduce a dependency of a proc on a table by selecting from the table in the proc, the sql parser discovers this and dutifully adds a row to sysdepends. Very well. But if you do the same select into a temp table, sysdepends doesn't pick up the dependency! Here's what I mean:
use master go
drop database test_sysdepends go
create database test_sysdepends go
use test_sysdepends go
create table MyTable01 (id int) go
create proc MyProc01 as select id from MyTable01 go
create proc MyProc02 as create table #t (id int)
-- comment this next line out and the dependency is picked up. -- but as long as we insert into the temp table, we don't pick it up... :( insert into #t select id from MyTable01
select id from #t go
select so2.name as parent ,so1.name as dependent from sysdepends d join sysobjects so1 on d.id=so1.id join sysobjects so2 on d.depid=so2.id go
Well all bugs are annoying, but this one is particularly annoying because it kills the BIDS session with consequent loss of all changes made since the last save.
Click on a control flow task. Position the cursor so that it changes to the 4-way pointer. Drag the task a little bit. The UI locks up, and then BIDS disappears.
I can't repro this on demand, but it has happened about 6 times in the past month. Anyone else seen this one?
I have a cube where i would like to define some actions. I have done report Actions but they are limiting in terms of what i am trying to achieve.I want a popup window from the action from relevant cells at the moment i can use the urlaction type to open the link in a new window which is ok but i want this as a popup.
hi, i'm working with LINQ to SQL and i have a table called Account, in that is Type, which is an int in the database but i map it to a AccountType enum, this works fine, but if i go into the dbml designer and change something later on, it gets errors, so i have to change all int->enum mappings back to int, recompile and then set them again! has anyone else had this? kindest regards
I am running a 'simple' stored procedure from the Query Analyser (command - FindCustomer L18239, [ ]) which should return a name from a customer table from the input id. It does return the name but I keep getting the message 'Server: Msg 245, Level 16, State 1, Procedure FindCustomer, Line 9 Syntax error converting the varchar value 'Kevin ' to a column of data type int.' - Any ideas what I've done wrong?, thanks.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008).
I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything.
Please give some suggestions on how I can resolve this issue.
I have the following problem in SSIS and it's driving me nuts!!!!!
My situation is as follows :
Data Source 1 & Data Source 2are joined using a merge join. This bit works fine.
The output of the above join is then joined to a third data source but this time, I only get 63 rows coming through instead of 77097 even though the join key in the second merge join component is the same as the first one!!!
I thought I was going mad so I decided to see if the same problem occurs if I was to do this with T-SQL. I created 3 temporary tables for each of my data sources.
I did an inner join between tmpTable_Source1 and tmpTable_Source2, I then stored the result in tempTable4
The final inner join was performed between tempTable4 and tempTable3 and the result produced 77097 and not 63 rows.
What the hell is SSIS playing at?! The merge keys I used in T-SQL is the same one I used in my SSIS package!!!!
I recently migrated from 2000 to 2005 database. On the new server, I kept getting this type of error message when there is some sort of join involved and they are not complex join either.
Error - "A severe error occurred on the current command. The results, if any, should be discarded."
ie
select A.Cookie1, A.Cookie2 into BookersLookers_Cookie from BookersLookers_DataSet A LEFT JOIN ActionSetup B on A.ActionID = B.ActionID group by A.Cookie1, A.Cookie2
Is there something in the code where I could prevent this error from happening?
Our Information Assurance (IA) office wants us to add a warning message popup box to our SQL 2012 SSRS server.The purpose is to force users to acknowledge the warning box popup before they get into to the SSRS main page.The message box would contain text stating Privacy Act information and or DoD monitoring consent...
I am generating a Report by using SSRS. I am making using use of SSRS Report Viewer control for displaying the report. Which has an option to export the generated report in PDF format. Instead of displaying the report in by using report viewer I want to generate it directly in PDF format whenever that report is selected from the list of reports. So is there is any way to generate the report directly in PDF format which prompt a pop up for opening or saving the PDF?
Intra-query parallelism caused your server command (process ID #57) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
I've seen MS KnowledgeBase for that (http://support.microsoft.com/default.aspx?scid=kb;EN-US;837983)
But I have some probs with it: 1. I don't have permissions for this kind of queries "USE master EXEC sp_configure 'show advanced option', '1' RECONFIGURE WITH OVERRIDE GO" 2. I don't know what is an "intra-query parallelism"...
I'm attaching the query I use. The query runs OK for some parameters but gets this error msg on other parameters.
I'm using a single CPU on 2003 STD Edition.
Query:
create table #mytemp_table (client_id int not null, commission_value int null) insert into #mytemp_table (client_id, commission_value) select client_id, sum(transfer_value) from users_transfers where transfer_type in (1,3) and is_paid = 1 group by client_id
select u.name [Vendor], u.email, sum(cost) as Payment, cmpd.vendor_id, ua.name [Agent], vd.join_date, commission_value [paid], allow_sign from reports ra left outer join codes ctd on ra.affiliation_code_show = ctd.affiliation_code_show left outer join traffic cmp on cmp.campaign_id = ctd.campaign_id left outer join traffic_details cmpd on cmp.campaign_id = cmpd.campaign_id left outer join userssb u on cmpd.vendor_id = u.client_id left outer join userssb ua on cmpd.agent_id = ua.client_id left outer join users_details vd on u.client_id = vd.client_id left outer join #mytemp_table com_paid on com_paid.client_id = u.client_id left outer join allow_db asd on asd.client_id = u.client_id where [conditions] group by
[all the group fields] having sum(cost) > 2999 order by u.name
I have a report that has rolled-up groups with the "expand row" + sign on each row. Everything works great except when you click the + the report scrolls everything above the + off the screen which completely re-shifts the users context... which nobody likes... how can we turn this "feature" off please?
Hello, I am having problems inserting information into my DB.
First is the code for the insert
Sub AddCollector(Sender As Object, E As EventArgs) Message.InnerHtml = ""
If (Page.IsValid)
Dim ConnectionString As String = "server='(local)'; trusted_connection=true; database='MyCollection'" Dim myConnection As New SqlConnection(ConnectionString) Dim myCommand As SqlCommand Dim InsertCmd As String = "insert into Collectors (CollectorID, Name, EmailAddress, Password, Information) values (@CollectorID, @Name, @Email, @Password, @Information)"
myCommand = New SqlCommand(InsertCmd, myConnection)
Try myCommand.ExecuteNonQuery() Message.InnerHtml = "Record Added<br>" Catch Exp As SQLException If Exp.Number = 2627 Message.InnerHtml = "ERROR: A record already exists with the same primary key" Else Message.InnerHtml = "ERROR: Could not add record" End If Message.Style("color") = "red" End Try
myCommand.Connection.Close()
End If
End Sub
No matter what I get a "Could not add record" message
Even substituting the insert command string with my stored procedure I would get the same thing
Stored Procedure:
CREATE Procedure CollectorAdd ( @Name nvarchar(50), @Email nvarchar(50), @Password nvarchar(50), @Information nvarchar(3000), @CustomerID int OUTPUT ) AS
INSERT Collectors ( Name, EMailAddress, Password, Information )
VALUES ( @Name, @Email, @Password, @Information ) GO
Can anyone see any problems with this code? It looks good to me but I get the same message always.
Originally I started using SQL Server Management Studio on the server directly. When I would right click on a view->edit I would essentially get a Alter Script of the view. Clicking on view-> design would open the query editor.
However I decided to connect to the server from my desktop instead using a local installation of SQL Server Management Studio. Now when I right click on a view I only get the modify option which opens the Query Editor and not the actual code that can be scripted. I know I can just right click->script view as->alter to to get similar results. I just can't seem to find any options to change this functionality. Does anybody know how to change this or is this a limitation of a desktop installaion?