Hello experts,
My database 'LeoAlpha' became too large. So I detached LeoAlpha and copied the files LeoAlpha.mdf and LeoAlpha_log.ldf aside, then re-attached LeoAlpha and deleted enough recor...
I am trying to avoid writing a stored procedure to acomplish this so I need help writing a statement.
Cust Value1 Value2 Datetime
1 1 1 ...
I am moving several clients from one shared hosting service to another one. Part of this move involves transferring MSSQL databases from one shared MSSQL server to another.
I have tried do...
I have a table I need to populate with data currently in a text file (csv format). I have little experience with scripting and would like to know how I can import data into a SQL table. I have...
I'm looking code that can find the right Price for a call. I've MS SQL 2005 database all the call information and price information.
Does somebody has an options / suggestion?
Table Pr...
I have records and need filter some
EG:
Student No Exam-Cycle Results Subject
0001 2009-03 D 22
0001 2009-03 A 2...
Hello all experts;
I have design this db with 3 tables for articles and now i want add another table/tables for putting relevant tags and i define these tags ,and in end of each aricle i rete...
I just learned this concept about Boyce-Codd Normal Form and just want to know if the following is in BCNF?
It's in BCNF if every determinant is a candidate key...
I am having a hard time...
I have drawn up a table for my web application I will be making that the users will be able to pull up troubleshooting templates based on the filters they select for example category - hardwar...
I need to perform data migration for a doctor's office. Their current software package uses a MySQL database with no schema available to use in the extraction. I need to convert that data to...
Are there any rules on if you should do your math on the database when queried or on the result set via php? Ive read that database time is more valued than server time so I was just wonderin...
Looking for information regarding defrag (compact) of exchang info store databases in a clustered environment. Realizing that it is not a reccommended practice for regular maintenance I do nee...
Hi Guys,
i have one backup file ( .BAK) taken from 2008 SQL server. i try to restore the same on 2005 sql server. i tried both though wizard and restore database query.
every time, i am ...
Dear Friends:
i am having a confusion on the overhead of two things
can any one guide me and tell me which option is better?
1- merging two tables of same type or
2- keeping tables indivi...
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/blood/register.asp, line 46
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Wi...
I'm working on small project that will require to fetch and save a fair amount of data.
The app is written in Delphi.
I need a database to store this and if possible, this database should ...
I have to draw a context diagram and I was wondering whether to group all the suppliers together as a single external entity called suppliers or whether to break them up into seperate ones. A...
How can I set an alert to tell me when my transaction logs (which are not set for autogrow) are nearing full?
I need to develop a database system with sql server 2000 on the back end and access 2003 on the front end.The nature of the system is such that you should capture a form twice (double entry) ....
Hello friends
I'd like to ask you if it is possible to upgrade embedded SQL database in Sharepoint product to some of full SQL versions
(keeping existing data present within embedded SQL)
...
Help!
I'm part of a team designing an intranet site for our company. I've come to find that Google Analytics will not work without a fully qualified domain name. Bummer. I'm frantically ...
Hi,
We're considering upgrading one of our SQL Servers from 2005 to 2008. This server is mostly used for reporting.
We're using SSIS to transfer data from production to this sever and i'...
I want to join two oracle tables which include all the missing of the left table. Can you please let me know how can I join?
Also can you please let me know How can I join 2 tables which incl...
You have been working with me on the Call/Issue Application. I got everyhting pulling correctly now. You have been a great help. The problem I have now is when an update is done to an alrea...
Hey guys.
Need some help figuring out this problem of order. I want to make a site that can have someone insert a piece of info in between 2 things. But the database needs to be able to sa...
