Database Index - How To Find It Using The Application's GUI
Mar 22, 2006On the Enterprise Manager of the MS-SQL server, how do I find or see the database index in there? Both that was done by SQL query or Stored Procedure?
Thanks...
ADVERTISEMENT
How To Let The Different Domain Name Find Different Web Application In One Server
Mar 19, 2008Hi:
We have one dedicated server, and have 3 different web applications, one of them is located in www folder which is default path, my question is: how do I set different path so all 3 web applications can be accessed by different URL?
Say: www.mywebname1.com, www.mywebname2.com www.mywebname3.com , I need those three URL to find the correct files from my server.
Thanks a lot.
(the DBA in my company has just left, so I need to make these works, however, I have very limited knowledge for this, do you have any suggestion what kind of book I need to read and start with?)
jt
How To Find A Running Application In SQL Server?
May 15, 2007How to find a running application in SQL Server?
Hi
In SQL Server (7.0, 2000), we know HOST_NAME() in a DEFAULT definition is used to record the workstation name of computers. But I need to find the name of the application which interacts my DB from the workstations. Is it possible? Please help me
Regards
Ahmed Sahib
ibnukuraish@gmail.com
Could Not Find Row In Sysindexes With Index ID
Dec 19, 2005Please help
1. my database can not truncate log and I use this command
BACKUP LOG IMVDB2 WITH NO_LOG
and after that I received result as below
->The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.
2. so I drop all replicate but it's still return same error
so I try to run
DBCC CHECKDB --> but no error meesage
DBCC CHECKALLOC --> but no error meesage
DBCC CHECKTABLE ('sysindexes') --> but no error meesage
but I tried to run
3. DBCC PAGE (IMVDB2, 1, 13015, 3) i recieved
-->Server: Msg 2591, Level 16, State 14, Line 1
Could not find row in sysindexes with index ID 2 for table 'object ID (334220541)'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
so what can I do the next to fix this problem, please help[/b]
Could Not Find The Index Entry For RID...
Jul 23, 2005Greetings. Today I was testing the sql backup/restore functions on ourprimary server. I was able to backup my database without any problemsbut when I tried to restore it, I received an error "Could not find theindex entry for RID '3610200101a03cc4b49d8bbc84bac50cbe042cecf76' inindex page (1:40), index ID 0, database 'walkthrough'." Thinking thatdata had been corrupted somehow I tried another database and received asimilar error for that database. In the past, our service provider hasattempted to restore data to this server and the restore failed do toanother data corruption. The problem is, I can't find out where thecorruption is located or how to fix it.When I open the restored database in enterprise manager, it returns theabove error and is unable to get a listing of my tables. In queryanalyzer I am able to view my data but receive the index error when Iattempt to look at the information_schema data. When I try to run a DBCCCHECKDB on the corrupted database it reports 0 errors and 0inconsistencies.So my diagnosis of the problem is that something is corrupting my systemtables and that problem shows up whenever I try to restore data from abackup. There could be a hardware failure but I believe the failurewould affect more then just the sql system tables. Can anyone offer anyadvice on how to find the corruption?Thank you in advanceRichard Bailey*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies View RelatedWhere Can I Find Northwind OleDb Native Sample Application
Jun 22, 2007Where can I find Northwind OleDb Native Sample Application?
KB 909751 states to install VS 2005 with: "Smart Device Programmability install option"
When installing VS 2005 I do not get the opportunity to specify this option..
What am I missing?
Thanks in Advance..
JEK
Setup And Upgrade :: Cannot Find One Or More Components - Reinstall The Application
Nov 1, 2015SSMS is fail and show this ERROR : "Cannot find one or more components. Please reinstall the application."
What Can i do?
How To Find Index Size / Usage (mb)
Nov 18, 2004I'm trying to establish the mb usage of a series of nonclustered indexes, I'm used to using the manage indexes GUI in 6.5, and showcontig doesn't quite give me what I want, any suggestions?
View 2 Replies View RelatedFind Specific Index Size
Mar 27, 2008We're looking at optimizing some of our tables because we have indexes on columns that are not used. So for example we might have a table that has 6GB of data and 4GB in indexes (according to sp_spaceused). We need to know how much of the 4GB of indexes is consumed by each of the indexes individually. I've tried dbcc showcontig, but that doesn't tell me the amount of space used by the index that I run it for.
Second (and by far not as important), is there a way to determine how much space is being consumed by data in a specific column. The original creator of some of the tables added an incrementing identity column that is used no where in the system. I'd like to be able to say..."If we drop this column we'll save XXX in space."
Knowing the index space is more critical, the column space would be nice but not necessary.
How To Find If Index Key Is ASC Or DESC From System Tables?
Apr 29, 2003There is a index: CustomerInfo_1
with keys: customerId, EnteryDate DESC
I could not find where the order of index key (i.e. whether the key is ascending or descending) is stored?
I tried system tables such as sysindexes and sysindexkeys tables. But could not find it.
Any help in this regard will be truly appreciated.
Thank you.
Regards,
Anuj Goyal
How To Find If Index Key Is ASC Or DESC From System Tables?
Apr 29, 2003There is a index: CustomerInfo_1
with keys: customerId, EnteryDate DESC
I could not find where the order of index key (i.e. whether the key is ascending or descending) is stored?
I tried system tables such as sysindexes and sysindexkeys tables. But could not find it.
Any help in this regard will be truly appreciated.
Thank you.
Regards,
Anuj Goyal
Index Usage - Find Unused Indexes
Sep 13, 2004Can anyone tell me a good way to monitor which indexes are not being used? Over time, I'm sure there are extraneous indexes in our database, which I would like to get rid of.
Any ideas would be appreciated.
Thanks,
Rob
SQL 2012 :: Find All Index And Creation Date
Mar 27, 2014I need to find all the index and the creation date. I did cross apply of sys.objects & Sys.indexes on name column. I am getting some but the team is saying they created so many. Any other option to find Indexes and their creation date?
View 2 Replies View RelatedT-SQL (SS2K8) :: Find Best Index For Specific Query
Dec 28, 2014This is my table:
use tempdb
go
if object_id('Data', 'u') is not null drop table Data
go
with temp as (
select top 10000 row_number() over (order by c1.object_id) Id
from sys.columns c1 cross join sys.columns c2
[code]....
What index would be best for these three queries? With best I mean the execution time, I don't care about additional space.
This is the index I currently use:
create nonclustered index Ix_Data on Data (StateId, PalletId, BoxId, Id)
The execution plan is SELECT (0%) - Stream Aggregate (10%) - Index Scan (90%).
Can this be optimized (maybe to use Index Seek method)?
Urgent : How To Find Whih Table Has Unique Index
Jun 28, 2004I have many databses and we are trying to see how many can be replicated. Found out 90 on't have primary keys.
Next option, find unique indexed tables and convert them to PKeys. Now my question is how do I fin that a table has a unique index and column has "allow null" Please remember I am not asking to find Unique constraint.
In other words , folowing query
select TABLE_NAME from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE in('UNIQUE') won't tell you if a table has a unique index.
Please help.
SQL Server Admin 2014 :: How To Find Memory Usage By Index
Oct 4, 2015I want to create a lot of index for my database for performance.
But I need find memory usage by indexes.
How to find memory usage by index in sql server?
SQL Server 2014 :: Find Views Which Has More Than 16 Columns For Unique Index / Constraint
Oct 27, 2015We are on SQL 2014...we have a bunch of views in a database where we are trying to find the views which have more than 16 columns max for unique index/constraint...this is needed so we can convert them to indexed views...
View 1 Replies View RelatedDifference Between Index Seek && Index Scan && Index Lookup Operations?
Oct 20, 2006please explain the differences btween this logical & phisicall operations that we can see therir graphical icons in execution plan tab in Management Studio
thank you in advance
SQL In-Memory :: How To Find Memory Usage By Index
Oct 4, 2015i want to create a lot of index for my database for performance.but i need find memory usage by indexes.
How to find memory usage by index in sql server?
One Application With 2 DataBase
Aug 6, 2007Hai All ,
Iam having the one Application in DotNet2005.But iam using the two database(SqlServer2005).If user's login the application it will check credentials in first database, if he is not having the login credentials it will cheek the second Database. How can I handle in the configuration file?. How can I change the connection string depending upon the Database in my application for database operation (like insert and update).Any one kindly provide the solution.Thanks and regards,sureshK
How Asp.net Application Communicates With MS SQL Database
Jun 13, 2007Hi, I'm interested in how asp.net application communicates with MS SQL database. I mean, is communication encrypted or can it be? I have scenario where database and web application will communicate over Internet, they are not in the local network. Please share your opinions.
View 1 Replies View RelatedApplication With Critical Database
Nov 6, 2007Dear all
I am a pretty new in the development world fresh from uni. I am doing development on a system that has a security database. Access to the data in that database is pretty important. So in case the main server where the database is stored for soem reason fails or gets compromised i need to have a second copy with the most recent data in that database and keep the application up and running. The data i have is stored in a SQL 2005 database. What are the recomended aproaches for acheiving this needed reliability?
Would running the SQL Agent every 2 minutes do the trick? And replicate the database to another server and then have asecondary deployment on that server running as a backup? Or are there any other means?
Any advice is apreciated.
Sincerely
Tell If Application Is Writing To Database?
Jan 12, 2015I was all set to build some triggers on some modified date tables when in the last minute I found out that the application (built in C#) was controlling the after update trigger.
Is there a tool you can use in SSMS to see if there is a connection set up like this?
MSDE Database With VB Application
Jan 5, 2004I have a vb application that uses sql server database , I want to move from sql server to msde file , wanna be able to attach msde file with vb app ,and run setup program
It looks like there is not much good info how to start with it
can anyone guide me ?
Thanks
Connection Between A Win Application And Database
May 15, 2008hi
i m making a win application
for which i have used sql server 2005 .i faced a very big problem that i have made the database but i cannot able to connect the database with winn application .for this purpose i ned coding.so please help me.i need your help urgent.
sheraz
Distribute Database In Application
Mar 30, 2007How can distribute an SQL database with my application in VB, does clickOnce may me do that? Should the final consumer install SQL Express Before installing my application. Can I create a unique package which may me do that?...
View 1 Replies View RelatedHow To Deploy A Database With Application
Jan 27, 2008Hello,
We just converted one of our commercial applications over to using SQL Server. We have a database that is about 700megs in size, what I want to know is how is one suppose to actually deploy a database in an automated install? I have created T-SQL insert scripts, but it is 764M in size, and it takes forever to read the script in to send to the SQL Server. So I am looking for suggestions on how to actually do this.
Thanks
Bern
Standalone Database Application??
Mar 24, 2006Hey guys,
I'm really new to this so this might look dumb, but I need to know what all has to be done to develop a standalone database application.....The frontend is going to be on VC++...which are the best tools I'll need to use. I need to know if the user has to install the database app to use the program to make this possible......Also will he have to keep it running everytime to use the program.
Thanks a lot for you time and patience,
Dhaval
Connect A Report To An Application Database
Aug 3, 2006I added a database named appdata to the app_data folder to hold temporary application data. I want to show this data in a report. I created a dataset and an object to select the data. I then created an report.fdlc and a report.aspx with a ReportViewer on it pointing to the dataset object. If I right click on the report.aspx and View in Browser, it work perfectly. But when I upload it to the server I get and browse to it I get (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). The server does allow remote connections. So I am thinking it's my connection string of the fact that the server doesn't have Sql Server Express.?
Here's my connection string. What am I missing here?
<add name="appdataConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|appdata.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
Sql Server Database Administration Web Application
Sep 10, 2006Hi All, I will shortly (hopefully) begin devleoping an ASP.Net web application to let users manage a remote sql server 2005 database (kind of like the php myAdmin tool for MySQL databases). Were not talking a server managament tool for DBAs, more an end user tool for managing personal databases (it seems that web hosting companies provide tools for MySQL, but if you use SQL Server, you're stuck unless you have management tools on your PC - and what about mac users?).Given that premise, what features should i attempt to include? Creating and modifying tables structures and data is an obvious inclusion, but what else? I also haven't yet decided whether to go about this using scripts or using SMO. I've read that SMO is backwards compatible across versions of SQL Server...how true is this? are there issues or is it seamless? Please post any comments or thoughts you have, and thanks for taking the time.
View 4 Replies View RelatedCombine Aspnetdb With The Application's Database
Sep 19, 2006I have tried to find all the threads related to this topic. At this point I would like to find out what the best practices are for doing this. I plan to use Membership, Roles, and the login controls to handle my authentication and permissions issues. I want to use the same database for my application data as for Application Services, using a standard SQL Server. So far, the easiest way to set this up that I can think of is to:1. Use aspnet_regsql.exe to create the Application Services Database schema2. Edit the "LocalSqlServer" entry in <connectionStrings> to point to the above database3. Add the tables, views, stored procedures, etc., that I need for my application into the database created in step 1Is there any more configuration I need to do to get Membership and Roles working? When I did the Walkthrough, step 2 seemed to be the only requirement for getting Membership and Roles to work.Will I run into any trouble using LocalSqlServer for my application data updates?I would be interested in any other approaches to setting up a combined database, including opinions why and why not to do it.
View 1 Replies View RelatedConnection To SQL 2000 Database With .Net 1 Application
Nov 12, 2007Hi there,
Has anyone ever encountered problems making .Net applications connect to a SQL database on SQL 2000 with SP3a?
It's running on a virtual machine with a Windows Server 2000 Std with SP4, the .Net application is working with .Net Framework 1.1.4322.573. For some reason it can't connect to the SQL database using the specified username and password in the web.config file even though the user exists in the SQL database. I've tried using the SA password but this still doesn't work. I can logon to SQL Query Analyzer using the SA password but not using the other username.
The .Net application does work on other systems of mine all of which can run on Windows Server 2000 and 2003, I have compared them but can't find any differences.
Any ideas anybody?
Thanks,
Chris
Got Problem With Connecting Database To Asp Application
Mar 10, 2008I got problem connecting database to my asp application (in teh code of sign up button)
here's the code
SqlConnection con = new SqlConnection();con.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO Students (FirstName,LastName,Address,Birth_Day,Birth_month,Birth_year,Country,User_Name,Password,SecretQuestion,Answer,E_mail,Grade,Dep_Name) VALUES (@FirstName,@LastName,@Address,@Birth_Day,@Birth_month,@Birth_year,@Country,@User_Name,@Password,@SecretQuestion,@Answer,@E_mail,@Grade,@Dep_Name)";string firstname = this.FirstName.Text;
string lastname = this.LastName.Text;string address = this.Address.Text;
int bd = int.Parse(this.Birth_Day.Text);string bm = this.Birth_month.Text;
int by = int.Parse(this.Birth_year.Text);string cntry = this.Country.Text;
string UN = this.User_Name.Text;string pw = this.Password.Text;
string SQ = this.SecretQuestion.Text;string ans = this.Answer.Text;
string em = this.E_mail.Text;string grd = this.Grade.Text;
string dep = this.Dep_Name.Text;cmd.Parameters.AddWithValue("@FirstName", firstname);
cmd.Parameters.AddWithValue("@LastName", lastname);cmd.Parameters.AddWithValue("@Address", address);
cmd.Parameters.AddWithValue("@Birth_Day", bd);cmd.Parameters.AddWithValue("@Birth_month", bm);
cmd.Parameters.AddWithValue("@Birth_year", by);cmd.Parameters.AddWithValue("@Country", cntry);
cmd.Parameters.AddWithValue("@User_Name", UN);cmd.Parameters.AddWithValue("@Password", pw);
cmd.Parameters.AddWithValue("@SecretQuestion", SQ);cmd.Parameters.AddWithValue("@Answer", ans);
cmd.Parameters.AddWithValue("@E_mail", em);cmd.Parameters.AddWithValue("@Grade", grd);cmd.Parameters.AddWithValue("@Dep_Name", dep);
con.Open();
cmd.ExecuteNonQuery(); // the error appears here
con.Close();
could anyone Help me urgently???