|
Hi,
I just want to install the visual studio 2005 in my machine in home and it's working but when i install SQLserver 2005 developer edition i cant get a hold of Enterprise manager nor SQL Server managment Studio .
guys can any one just tell me what is miising or required
I have WindowsXP SP2 and i dont get any errors while installing and i've installed many times with differnt setting but neither of them will give me :start-->all programs-->Microsoft SQL Server 2005-->(only configuration tools and no SQL Server Managment Studio).
Thanks for your Help,(in adv.)
|
|
|
|
|
SQL doesn't fully support Windows XP SP2. Read the installation guide, it is clearly stated.
|
|
|
|
|
ExpertComing wrote: SQL doesn't fully support Windows XP SP2
Well Mr. I have 3 Computers with XP SP2 installed and I can Install it in my Laptop which runns on XP SP2 and also in my old P4 computer it is installed and running perfectly but with this new computer P4 3.4Ghz with Hyper Threading I cant Install it (only client and connectivity tools) So i really have no idea why is this happenning.
Thanks
|
|
|
|
|
XP Home Edition SP2 will work with SQL Server 2005 Developer Edition, only.
XP Pro SP2 will work with SQL Server 2005 Developer, Standard, Workgroup, Express, and Evaluation Editions. It will NOT work with the Enterprise Edition.
For anything further, you'll have to read the RequirementsSQL2005.htm file that comes on the installation disk.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello all,
In our office we are using a single SQL server for database and it is installed on separate system. We are using ASP.Net as the front-end. Almost 10-15 systems are accessing the database server at a time, and very frequently we are getting "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. " Is there any problem with our ASP.Net code or else is this problem from the database end? We are closong all the Data Readers and data base connections immediately. even the we are getting this kind problem very often.
Please help me out to solve this problem
thanks in advance
Naga Raju Epuri
|
|
|
|
|
Hello,
I am just trying to get some familiartity with ASP.NET website
Administration Tool and set up few users and roles. I launched the tool
and clicked on provider configuration link and it goes to the page that
has the link "Select a single provider for all site management data "
and then I clicke on it and it takes me to the page that has
AspNetSqlProvider radio button checked. I clicked on the link, test to
test the connection but its taking long to connect and finally it
couldn't connect to the database. I am not sure what credentials its
using to connect to the database.
This is the link I just copy and pasted thinking it might give any
inside of it.
http://localhost:1472/asp.netwebadminfiles/providers/ManageConsolidat...
When I used windows authentication to connect to the Managment Studio I
had no problem connecting to it. But I am not sure if the above process
trying to connect to the SQL Express by default. If it was then it
makes it sense. Becauase I have deleted SQL Express on my machine
before installing Sql Server 2005 Developer Edition.
If thats the case how do I can connect to the SQL Server 2005 from
the tool? Do I need to setup any think on my machine to have it
connected to the SQL Server 2005?
Any input is greatly appriciated.
Thanks
-L
|
|
|
|
|
This is the error Its throwing after a while trying to connecting to the database
****************************
Internet Explorer cannot display the webpage
Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.
What you can try:
Check your Internet connection. Try visiting another website to make sure you are connected.
Retype the address.
Go back to the previous page.
More information
This problem can be caused by a variety of issues, including:
Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server is not reachable.
The Domain Name Server does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section.
****************************
|
|
|
|
|
Hello.
I'm trying to insert a record into Oracle table via Command.Execute"Insert
Into..Values" query. The table has several DATE fields and some of them have
to have NULL value.
The problem is that when I specify NULL in my insert query, the DATE fields
are getting value of "30-DEC-99" instead of NULL. CHAR fields are getting
NULL value without any issues.
I've tried both Microsoft and Oracle providers with the same result.
Please, let me know what I'm missing or should I use different ways to
achieve what I need (stored procedures or queries w/o values NULL fields).
Thanks
Valeriy Raygorodetskyy
|
|
|
|
|
Hi all,
I'm wondering if there's a limit/recommendation in the number of records
that it can be inserted in an Access 2003 table before the performance is
affected considerably. I know that in Access 2000 the limit was around 100,000 records but I'd like to know it for Access 2003.
thanks in advance,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
In my opinion, performance in Access is more dependent on whether or not tables are properly indexed, and whether or not the database is being used as a desktop/single-user database or in multi-user situations.
I've seen Access tables with a million rows perform very well. I've seen much smaller tables, improperly indexed, perform very poorly.
Keep in mind too - Because of Access' easy-to-use datagrid views, it is tempting to always have forms based on complete table recordsets, which can often kill performance. Again, I've seen well-designed Access applications which force the user to limit the number of records being displayed; even with million-row tables, this can perform very well.
As for a strict limit - in Access 2003, I think 2 Gigs (minus space for system tables) is the largest a table can be.
|
|
|
|
|
Hi all
Using ADO & SQL Server & VB6
Assume that some changes on different tables are made within a BeginTrans-CommitTrans pair. Like below:
Dim Con As ADODB.Connection
'...
With Con
.BeginTrans
.Execute("Insert Into table1 (field1, field2) Values (1,2)")
.Execute("Update table2 Set field1 = 3")
'...
.Execute("Delete From tableX Where fieldY = Z")
'...
.CommitTrans
End With
I'm looking for a way for getting the names of the changed tables right after the CommitTrans?
Thanks
Good Day
|
|
|
|
|
hi,
i have a datagrid which is filled from database with edit, delete options. i have used inline coding. how to write a stored procedure for filling a datagrid. can anyone help me with the code
regards,
boon
|
|
|
|
|
david boon wrote: how to write a stored procedure for filling a datagrid
A stored procedure won't exactly fill a datagrid for you. You would write a stored procedure to execute database code and optionally return a result set; if you do return data from the stored procedure, then you can use the .Fill() method of a DataAdapter object (OleDbDataAdapter, SqlDataAdapter, etc. depending on the brand of database you are working with) to populate a DataSet object. The DataSet object could then serve as the source for your DataGrid.
If your database system supports stored procedures, you can likely use the CREATE PROCEDURE statement - here's a very simple example:
CREATE PROCEDURE GetEmployees
(
@startOfLast varchar(128)
)
AS
BEGIN
SELECT EmployeeID, LastName, FirstName, Department
FROM MyEmployeesTable
WHERE LastName LIKE @startOfLast + '%'
END Specific syntax will still depend on your brand of database system.
|
|
|
|
|
How can i determine all the currently logged users of my SQL Server dabase using ADO.NET
|
|
|
|
|
I think you can query master.dbo.sysprocesses to derive who is logged in at any given moment in Sql Server. With that, you could create a class kind of like this:
using System.Data;
using System.Data.SqlClient;
public class SqlServerUsers
{
private static SqlConnection GetConnection()
{
string sCon = "Server=(local);Database=master;Trusted_Connection=True;";
SqlConnection con = new SqlConnection(sCon);
con.Open();
return con;
}
public static DataSet GetLoggedInUsers()
{
string sql = "SELECT hostname, loginame, cmd, program_name "
+ " FROM master.dbo.sysprocesses "
+ " WHERE hostname != ''";
using (SqlConnection con = GetConnection())
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
}
|
|
|
|
|
Hello all. I need to know if that's possible.
I have a database with many tables, but other person is updating it, so there are tables that have changes: new fields, new relationships...
I have the backup with the new version and I have to update my database, but I don't want to lose the tables information. Is it possible to do that automatically? There are many tables to do it manually.
Regards,
Diego F.
|
|
|
|
|
Diego F. wrote: I have a database with many tables, but other person is updating it, so there are tables that have changes: new fields, new relationships...
I have the backup with the new version and I have to update my database, but I don't want to lose the tables information. Is it possible to do that automatically? There are many tables to do it manually.
Don't quite follow you. What are you updating? This other person should be working with you in synchronization so you both are on the same page.
PC
|
|
|
|
|
The thing is that I'm working with a large database with about 300 tables. Other person is working updating that db, adding fields and relationships to some tables. The problem is that I only have a backup with the new version and not the scripts with the changes.
So I need a way to "upgrade" my database with the new version without losing data.
I think it must be something like creating a new database restoring the backup and moving the data from the old database, but I don't know how to move that data.
Regards,
Diego F.
|
|
|
|
|
Sounds like you two should be in close communication of what is going on with the database. I am assuming you are using some flavor SQL. The person doing the changes to the tables by adding fields and relationships should provide you with a script containing ALTER commands reflecting the new changes to the database that have been made. At this point, you would run the script and your backup database would be structurally the same as the updated database. No data loss, no moving of data, or anything like that.
http://www.w3schools.com/sql/[^] has a nice reference of SQL commands if you are not familiar with them.
Hope this gives you some ideas,
Paul
|
|
|
|
|
Hi experts..im new to sql and i wrote this stored procedure for number to character conversion..
intially i have taken one numeric parameter and i have converted into varchar to display in words..
But i want to do one more modifications to this code..if i entered 500 then it shuld be treated
as 500 dollors and should be multplied with 45 and the result should be = 500 * 45.
But im returning varchar value..how to multiply with '45'. im getting data type conversion error..
Here im sending my code upto ten thousand only.. and return statement..
pls solve the problem..and thanks in advance..
@p_Number numeric(18,2) --> Parameter...
begin
declare @Num varchar(20)
declare @Dec varchar(3)
declare @Return varchar(2000)
set @Return = convert (varchar(2000),@p_Number)
set @Dec = substring(convert(varchar(20),@p_Number),len(convert(varchar(20),@p_Number))-2,3)
set @Num = substring(convert(varchar(20),@p_Number),1,len(convert(varchar(20),@p_Number))-3)
declare @Hundred Char(8)
declare @HundredAnd Char(12)
declare @Thousand Char(9)
declare @Lakh Char(5)
declare @Lakhs Char(6)
declare @Crore Char(6)
declare @Crores Char(7)
set @Hundred = 'Hundred '
set @Thousand = 'Thousand '
set @Lakh = 'Lakh '
set @Lakhs = 'Lakhs '
set @Crore = 'Crore '
set @Crores = 'Crores '
set @HundredAnd = 'Hundred and '
if len(@Num) = 1 -- One
begin
set @Return = testuser.fn_GetTextValue_arif(@Num)
end
else
if len(@Num) = 2 -- Ten
begin
set @Return = testuser.fn_GetTextValue_arif(@Num)
end
else
if len(@Num) = 3 -- Hundred
begin
set @Return = testuser.fn_GetTextValue_arif(substring(@Num,1,1)) + @Hundred
if substring(@Num,2,2) <> '00'
set @Return = @Return + 'And '
set @Return = @Return + testuser.fn_GetTextValue_arif(substring(@Num,2,2))
if substring(@Num,2,2) = '00'
set @Return = testuser.fn_GetTextValue_arif(substring(@Num,1,1)) + @Hundred
end
else
if len(@Num) = 4 -- thousand
begin
set @Return = testuser.fn_GetTextValue_arif(substring(@Num,1,1)) + @Thousand
if substring(@Num,2,1) <> '0'
set @Return = @Return + testuser.fn_GetTextValue_arif(substring(@Num,2,1)) + @Hundred
if substring(@num,3,2) <> '00'
set @Return = @Return + 'And '
set @Return = @Return + testuser.fn_GetTextValue_arif(substring(@Num,3,2))
if substring(@num,2,1) = '0' and substring(@num,3,2) = '00'
set @Return = testuser.fn_GetTextValue_arif(substring(@Num,1,1)) + @Thousand
end
else
if len(@Num) = 5 -- Ten Thousand
begin
set @Return = testuser.fn_GetTextValue_arif(substring(@Num,1,2)) + @Thousand
if substring(@Num,3,1) <> '0'
set @Return = @Return + testuser.fn_GetTextValue_arif(substring(@Num,3,1)) + @Hundred
if substring(@num,4,2) <> '00'
set @Return = @Return + 'And '
set @Return = @Return + testuser.fn_GetTextValue_arif(substring(@Num,4,2))
if substring(@num,3,1) = '0' and substring(@num,4,2) = '00'
set @Return = testuser.fn_GetTextValue_arif(substring(@Num,1,2)) + @Thousand
end
if @Dec <> '.00'
set @Return = @Return + 'And ' + testuser.fn_GetTextValue_arif(substring(@Dec,2,2)) + 'Paise '
select '$' + @Return + 'Only' as 'MoneyInWords' ---> Retrun value...
|
|
|
|
|
I'm running msde2000, what I need to do is subtract data from the tables into a c.s.v file, I don't really want to make code changes and install updates of my app everywhere, so what I want to do is just create a script file or some statement that I can run through osql,
Any ideas?
Sql not my area of experties.
|
|
|
|
|
Hi All
I want to run a stored proc to query a dynamic field set by a parameter. When I run the query I Get no results and I know the data exists.. Can anyone see if I am doing something incredibly dumb
'''My sproc
CREATE PROCEDURE SearchOrders @Field nvarchar(20), @SearchStr nvarchar(20)
SELECT *
FROM SorDetail
WHERE (@Field=@SearchStr)
thanks y' all
|
|
|
|
|
here is the solution, i was not able to figure this one out my girlfriend was good enuff to get one of the propellor heads to figure it out at here work:
CREATE PROCEDURE SearchOrders @Field nvarchar(20), @SearchStr nvarchar(20) AS
declare @Query nvarchar(4000)
set @Query = 'SELECT * FROM SorDetail WHERE [' + @Field + ']=''' + @SearchStr + ''''
exec sp_executesql @Query
|
|
|
|
|
thedom2 wrote: one of the propellor heads to figure it out
So we're all just "propellor heads" to you. I see....
Anyway, this "expert" failed to mention the need to defend against incorrect or malicious input into the stored procedure.
You may like to consider putting the following code at the start of your stored procedure:
IF NOT EXISTS(SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='SorDetail'
AND SCHEMA_NAME = 'dbo'
AND COLUMN_NAME = @Column)
BEGIN
-- Column does not exist.
RETURN 0;
END
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Anybody know how to dump a database to SQL? (Yup, all tables, procedures, etc...)
I only read CP for the articles.
Code-frog System Architects, Inc.
|
|
|
|
|