Every time I view a form or dialog in Visual Studio (2005) the Properties and Toolbox panes show up on the right side of my screen. That's good to have because they are useful for manipulating dialogs.
However once I switch back to source code these panes just get in the way... is there a way to get them to go away automatically?
I'm working in Sql Server 2005. I have an event log table that tracks user actions, and I want to make sure that inserts into the table are as fast as possible. Currently the table doesn't have any indexes. Does adding a single non-clustered index slow down inserts at all? Or is it only clustered indexes that slow down inserts? Or should I just add a clustered index and not worry about it?
Hi, I have an asp.net web app and I need to launch a pdf report that is developed in SSRS using SQL 2005. The SSRS report query has been created. How can I go about launching the report?
I'm using 2005 and the Native XML WebServices. The integrated authentication via HTTP:80 works fine. But i need the basic authentication which requires SSL. So if i change the web service to ssl i always get a connection reset (101). I tried several ports 80,443,9999 with the same outcome.
What is the error?
Hi.
I'd like to indicate to SQL Server 2005, in my BEGIN CATCH...END CATCH block that the error is "handled"... That is, clear the error.
Is that possible??
Thanks.
A.
I am getting the error from the application as following with SQL server 2005
"Transaction count after EXECUTE
indicates that a COMMIT or ROLLBACK
TRANSACTION statement is missing.
Previous count = 1, current count =
0"
How can i find the stage where this error raised?
how can i found the missing transaction or the stored procedure where it is not committ or rollback?
I'm using Crystal Report with VB.NET in Visual Studio 2005.
I have report that works if I pass in a list of List(Of Stuff). I had been sorting the report by one of the members of Stuff but a need now to sort first by one member, like Stuff.StatusCode and then by another member, like Stuff.ItemNumber.
Can I do this just be having more than one SortField member, or do I need to do it some other way?
Thanks as always!
Whenever a single page report is exported to excel, sheet in excel is named by the report name.
If a report has multiple pages, the sheets are named as sheet1, sheet2,....
Is there any way to specify sheet names in SSRS 2005 ?
solution:
Found this after some googleing:
Changing the Sheet names in SQL Server RS Excel: QnD XSLT
Will try out and post an update if it works.
I installed SQL Server 2005 sometime ago and forgot the administrator password I set during setup. How can I connect to SQL server now?
EDIT: I think I only allowed Sql Server Authentication. Login with integrated security also does not work.
Hi,
I'm using Sql Server 2005 and i'm trying to achieve something like:
In the same select statement i want to get the first x rows and the last x rows.
SELECT TOP(5) BOTTOM(5)
Of course 'bottom' does not exist so i need other solution.
I believe there is an easy and elegant solution that i'm not getting.
Doing the select again with Group By Desc is not an option.
Thanks.
I have Table with two smalldatetime columns, where one is startTime and other one is endTime.
I need to select all values from table which between times of both columns compared to getdate()' time.
I'm using SQL-Server 2005.
example
startDate endDate value1
2/2/01 16:00 2/2/01 18:00 1
2/2/01 21:00 2/2/01 22:00 2
2/2/01 05:00 2/2/01 22:00 3
getdate() gives 2/2/2000 21:40
so i need to get value1 2 and 3
thanks in advance
I'm trying to compare the schemas of two tables that exist in different databases. So far, I have this query
SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('table1')
The only thing is that I don't know how to use the sys.columns to reference a database other than the one that the query is connected to. I tried this
SELECT * FROM db.sys.columns WHERE object_id = OBJECT_ID('table1')
but it didn't find anything.
I'm using SQL Server 2005
Any suggestions? thanks!
in Sql Server 2005, I have a master table, and several other tables which are related to
this master through several one to many relations.
How can I find all tables and fields which are in relation with the
primary key in the master table, on "many" side?
I know I can extract this by querying views from INFORMATION_SCHEMA,
but I don't know where exactly I can find this info.
Thank you
i am using sql server 2005, please tell me how can i get 6 digits (unique numeric which should be random) value for every row in table.
i have a field in table in which i needs 6 digit numeric value (random and unique).
please help me to do this.
I have 3 computers having the same sql server 2005 database, i would like to gather the data from the 3 computers to another computer which has the same database.
pls help me tnx in advance
So this my first question here, let's look how it works.
I'm working on a project, which has to to provide a "Native XML WebService" on a SQL Server 2005. The web service and the WSDL generation works fine. But there are troubles with the authentication.
Is it possible to turn the authentication off (The tests and the documentation by Microsoft say no.)?
And if so how?
Hello , i have written an sql script for updating a database that runs in SQL server 2005 and I want to make that changes to the production DB server but I dont want to run the query from the query analyzer , is there a way to run the sql script from console?
Is it possible to find out who called a store procedure. So if you get an error in proc3, I know if it was called by proc1 or proc2.
I'm using SQL Server 2005.
Hi,
Is there any way, to save formatted in database from richtextbox?
I've got richtextbox and some parts of text in this are bold.
string s=richtextbox.Text obviously doesn't work.
And If I can get this formatted text how to save it in Ms Sql Server 2005 ?
I need to Pass some data to a text file and save that text file in a SQL Server 2005 database.
Then I'll need to be able to load that textfile into a C# WinForms DataGrid.
How do I do that in C#?
My sql query gives the columns:
product_id (which is an integer)
pnl (which is float - can be negative)
I get more than 100 rows.
I want to filter out the top 40 rows based on abs(pnl).
But the results should be ordered by pnl column only and not by abs(pnl).
I want to do this for MSSQL 2005.
Is there a way to do this?