Lost Tables And Queries

Aug 14, 2007

I appologise if this is dumb to anyone but I need a lot of help. I had a large program with over 50 tables and over 100 queries written in access. I upsized to SQL into a server windows 2003. Everything was cool and I made all corrections such that the program was working fine. The program resided in a D: accessory drive which was going bad. I copied my program to a different drive and replaced the D drive and returned my program to the new drive. I amde sure all shares and securities were the same. Lo and Behold My program now is missing all the queries and tables and when I run it it says it is disconnected. What happened to my tables I am currentely sobbing right now.

View 3 Replies


ADVERTISEMENT

Export Some Tables From One DB To Another WITHOUT Lost Of Primary Key?

Jun 7, 2005

Hi,
i am using the enterprise manager of our sql server 2000. i want to
export some (not all) tables from one DB to another one with all the
data inside these tables AND the primary keys. if i do i only receive
the tables with the data but all primary keys and indexes will be lost.
how to do it?
thanks, tobi

View 7 Replies View Related

ODBC Connection - Lost Tables

Jan 8, 2004

I have a SQL Server database that I connect a front end to using an ODBC connection. Our LAN folks upgraded the server recently and now I can no longer see any of the tables through the ODBC connection that the user used for login has permission in SQL Server Enterprise Manager to see - throught the ODBC connection the user can only see things like:

dbo.spt_datatype_info
dbo.spt_datatype_info_ext
dbo.spt_fallback_db
dbo.spt_fallback_dev
dbo.spt_fallback_usg
.
.
.
INFORMATION_SCHEMA.CHECK_CONSTRAINTS
INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE
etc.

I've tried deleting the user for the connection and re-establishing it with owner permissions. I've tried deleting the dsn and re-establishing that as well but nothing so far.

Please help!!!

View 9 Replies View Related

Lost SQL 2005 Tables And Stored Procedures

Apr 21, 2006

I converted a program from SQL 2000 to SQL 2005 all went well. I created a number of tables and stored procedures after the conversion. I backed up my .mdf and .idf files. I was having problems with SQL so I uninstalled and re-installed it. Once I re-installed it I could no longer display some tables and files. Since I am the dbo, I think I should be able to access them. There obviously is something I am missing, hopefully not the tables and sps.

I would appreciate any suggestions.

Thank you.

LitePipe

View 4 Replies View Related

Saving Tables That Are Generated By Queries As HTML File Or Sub-tables

Oct 17, 2006

I have a trade data tables (about 10) and I need to retrieve information based on input parameters. Each table has about 3-4 million rows.

The table has columns like Commodity, Unit, Quantity, Value, Month, Country

A typical query I use to select data is "Select top 10 commodity , sum(value), sum(quantity) , column4, column5, column6 from table where month=xx and country=xxxx"

The column4 = (column2)/(total sum of value) and column 5=(column3)/(total sum of quantity). Column6=column5/column4.

It takes about 3-4 minutes for the query to complete and its a lot of time specially since I need to pull this information from a webpage.

I wanted to know if there is an alternate way to pull the data from server ?

I mean can I write a script that creates tables for all the input combinations i.e month x country (12x228) and save them in table (subtable-table) with a naming convention so from the web I can just pull the table with input parameters mapped to name convention and not running any runtime queries on database ??

OR

Can I write a script that creates a html files for each table for all input combinations save them ?

OR

Is there exists any other solution ?

View 1 Replies View Related

Cannot Access Any Tables In Queries

Nov 7, 2007



I am using SQL2005 (Installed on VISTA). It was running smoothly until today....for some reason I cannot access any tables in queries that I try to run in Management Studio. I can open the tables and see the information, but all queries I try to run result in the following error:


Msg 208, Level 16, State 1, Line 1

Invalid object name 'DBO.BEYLEVEL16'.


I tried to run simple select queries on other tables but I get the same error message. Do not understand, eveything was working fine yesterday.

Any suggestions greatly appreciated.
Thanks

View 9 Replies View Related

Queries In Productions AND History Tables

Jun 18, 2004

I've got a large and growing database in SQL Server 7.0. I'd like to utilize a monthly stored procedure that will search various tables for records that are older than 3 months and copy this data out to corresponding history tables. Typically, most production queries are run only on the new data, but occasionally (like at year-end, for example), we will need to run some queries on data extending back 12 months -- that is, on data in the production tables AND in the history tables. Notwithstanding the fact that I've never done stored procedures*, I would like to know if it is possible to run a query that can search for data in both production and history tables at the same time. I know this sounds like a stupid question, but I read somewhere that doing this qould require some kind of Joining function that is complex...?

Thanks,
Whill96205

* Also, any good resources I could use for developing stored procedures?

View 4 Replies View Related

Create Tables From Sql Queries In A .txt File

Apr 22, 2008

Hello,

I am new to SSIS. I have a scenario:

I am creating a database using 'Execute SQL Task'. Then i have to create few tables in that database. where,I have my create table SQL queries for 5 tables in a .txt file.

How to approach this task...

View 1 Replies View Related

Queries On Recursive Self Join Tables

Oct 24, 2007



Good morning!
Or good "whatever daytime you read this"!

SQL Server 2005 has this nice new feature Common table expression or CTE, which allows quite easy to define a "drill down" in recursive self join tables.

By recursive self join tables I mean this common example:
idPerson INT <--------|
idReportsTo INT ---------|
PersonName VARCHAR


A CTE to "go down" the tree from any entry point and find all subs to a parent entry is well documented. I managed to make myself a CTE and use it a lot!

What I find myself needing too often is:
a) Look up from a deep position and find the entry that is for example 3 steps above my reference in the branch
b) Look up from a deep position and find the one that is 2nd or 3rd level (absolute) from top of the tree in the branch


I did try quite some versions, but I cannot get it to work. Any idea how you do the "drill up" with a CTE or another SQL solution.
Of course performance is always needed, so I'd like to avoid the cursors I got it working with and use now. (It is not working good I admit...)

Cheers!
Ralf

View 7 Replies View Related

Print List Of Queries, Tables, Views And Sp

Oct 29, 2007

I just started a new job and 1st time on sql server, how can i print list of queries, tables, views, stored procedures and functions?

View 6 Replies View Related

Queries Using Tables From Diffrent Databases Or SQL Instances

Aug 10, 2007



Hello,

I am new in SSIS.

I am using an OLEDB source and setted as SQL Command.

The Query is a JOIN between different databases.

How can I make the QUERY with different source (different databases or SQL Servers)?

I mean, any solution is OK, the important is to make queries against different databases with SSIS.

Thank

View 9 Replies View Related

Large FullText Tables - Slow Queries

May 31, 2007

Hi,



I currently have a large table (35 million rows, over 80GB). I have one varchar(max) column on the table that is used in the fulltext index.



To query the complete index is fast, for example:



SELECT 'ipod', COUNT(*)

FROM CONTAINSTABLE(MyDB.dbo.Contents, [Body], 'ipod') CT



This took 70 seconds (which I can live with). However, I seldom run queries like this, most are more like:



SELECT 'ipod', COUNT(*)

FROM CONTAINSTABLE(MyDB.dbo.Contents, [Body], 'ipod') CT

JOIN Pages ITP ON ITP.PageID = CT.[Key]

JOIN Feeds ITF ON ITP.IPID = ITF.IPID

JOIN Buyers ITB ON ITB.IBID = ITF.IBID

WHERE ITB.ID IN (1342,246)



These queries are much slower (this example took 17 minutes). I understand that FT searches the index and returns all rows that match the query to SQL. SQL then performs the joins and counts only the correct results. (Correct me if I'm wrong here).



One solution I've seen to this to put data or "tags" into the FT column - so my Body column would become something like:



'{ID:1342}' + [Body]



That sounds like a very good idea. I could then change the 2nd query above to be:



SELECT 'ipod', COUNT(*)

FROM CONTAINSTABLE(MyDB.dbo.Contents, [Body], '("ID:1342" OR "ID:246") AND "ipod"') CT



That all works well until I want to select 1000 different ID's because the FT query will become very long and complex. Also I'm only including one column (ID) in this example - but I have about 7 or 8 columns that I would need to include in these "tags". Quering multiple columns become very complex quickly and no doubt I will reach a query limit at somepoint.



If anyone has any other suggestions to the above I'd love to hear them. Another thought I'm having is to partition the table. I can find very little online about how FT behaves on partitioned tables - I fear it behaves exactly the same, what I'd like to think is that I could partition the table on an ID say 100 per partition or something, and then fulltext would only search the relevant partitions. If it behaves like this it may work. If no-one knows then I'll give it ago, but this will take me a while due to the table size - so I'm hoping one of you clever lot know!



Many thanks for any advice.



Simon





View 2 Replies View Related

SQL 2012 :: Queries Based On ER Diagram And Joining Tables

Feb 22, 2015

I need to create a few select queries based on an er diagram.

These are my Create Table statements and import statements:

Create Table Agent (Aid integer primary key, Pid integer, aName text);
Create Table Product (Pid integer primary key, pName text);
Create Table Supplier (Sid integer primary key, sName text);
Create table Supplies (Sid integer, Pid integer, price decimal(8,2));

.import agent.txt Agent
.import product.txt Product
.import supplier.txt Supplier
.import supplies.txt Supplies

I think I got all my create table statements are correct.

I need to Find the number of agents for each supplier that has at least one agent. The result should be tuples of the form (sid, sName, number of agents)

-Select Sid, sName, count(Aid) from Agent A join Supplier S on (S.Sid = A.Sid) group by S.Sid, S.sName, Aid;
But it gives me this error: no such column: A.Sid

Im thinking I might have a problem with my create table statement and/or primary key statements?

View 9 Replies View Related

Execution Of Queries On Tables Without Table Owner Specified Fails.

Feb 7, 2006

Hi

Having some issues with our apps.
We are trying to get our applications to work with sql2005.

Ive got the databases "setup", and all our apps run fine...
...except for when queries are made without the owner of the
table being specified in the query.

The connection is opened with the username that is associated with that owner.
And it fails in Manager as well. Is there something im missing, because you should
be able to do this.

eg:
select * from <table_name>

Gives the error:


Msg 208, Level 16, State 1, Line 1

Invalid object name '<table_name>'.

However if i were to query like this:
select * from <owner>.<table_name>

it works fine.

View 11 Replies View Related

T-SQL (SS2K8) :: Joining Results Of Two Queries Without Creating Temporary Tables?

Nov 16, 2014

In the T-SQL below, I retrieved data from two queries and I've tried to join them to create a report in SSRS 2008 R2. The SQL runs, but I can't create a report from it. (I also couldn't get this query to run in an Excel file that connects to my SQL Server data base. I've used other T-SQL queries in this Excel file and they run fine.) I think that's because I am creating temporary tables. How do I modify my SQL so that I can get the same result without creating temporary tables?

/*This T-SQL gets the services for the EPN download from WITS*/

-- Select services entered in the last 20 days along with the MPI number and program code.

SELECT DISTINCT dbo.group_session_client.note, dbo.group_session_client.error_note, dbo.group_session_client.group_session_id,
dbo.group_session_client.group_session_client_id, dbo.group_session.signed_note, dbo.group_session.unsigned_note
into #temp_group_sessions
FROM dbo.group_session_client, dbo.group_session
WHERE dbo.group_session_client.group_session_id = dbo.group_session.group_session_id

-- Select group notes

SELECT DISTINCT
dbo.client_ssrs.state_client_number, dbo.delivered_service_detail.program_name, dbo.delivered_service_detail.start_date,
dbo.delivered_service_detail.start_time,
dbo.delivered_service_detail.service_name, dbo.delivered_service_detail.cpt_code, dbo.delivered_service_detail.icd9_code_primary,

[code]....

-- Form an outer join selecting all services with any group notes attached to them.

select * from #temp_services
LEFT OUTER JOIN #temp_group_sessions
on #temp_services.group_session_client_id = #temp_group_sessions.group_session_client_id
;

-- Drop temporary tables

DROP TABLE #temp_group_sessions;
DROP TABLE #temp_services;

View 9 Replies View Related

SQL Server 2014 :: How To Systematically Manage Big List Of Queries And Tables

Sep 12, 2015

Suppose someone has to work on a lot of different SQL Server Databases which have got a lot of Tables and Queries / Views inside them.

After a period of time, it becomes very difficult to remember exactly what kind of columns are present within a given Table and View.

Any method by which one can keep a systematic list of all the Tables and Views that are present within a SQL Server Database, along with the columns that are present within them.

Are there any Add-on products or services etc. available in making this type of work systematic?

Currently I add comments to each queries inside SQL Server to remind me of what this query is doing, but this method is not great.

View 2 Replies View Related

Bad Performance In Queries With Jet4.0 And Linked ODBC-tables To SQL-Server 2000

Jul 20, 2005

I changed from Access97 to AccessXP and I have immense performanceproblems.Details:- Access XP MDB with Jet 4.0 ( no ADP-Project )- Linked Tables to SQL-Server 2000 over ODBCI used the SQL Profile to watch the T-SQL-Command which Access ( whocreates the commands?) creates and noticed:1) some Jet-SQL commands with JOINS and Where-Statements aretranslated very well, using sp_prepexe and sp_execute, including thesimilar SQL-Statement as in JET.2) other Jet-SQL commands with JOINS and Where-Statements aretranslated very bad, because the Join wasn´t sent as a join, Accesscollects the data of the individual tables seperately.Access sends much to much data over the network, it is a disaster!3) in Access97 the same command was interpreted wellCould it be possible the Access uses a wrong protocol-stack, perhapsJet to OLEDB, OLEDB to ODBC, ODBC to SQL-Server orJet to ODBC, ODBC to OLEDB and OLEDB to SQL-Server instead ofJet to ODBC and ODBC direct to SQL-ServerDoes anyone knows anything about:- Command-Interpreter of JetODBC, Parameters, how to influence thecommand-interpreter- Protocol-Stack of a Jet4.0 / ODBC / SQL-Server applicationThanks , Andreas

View 6 Replies View Related

Integration Services :: Get Data From Source By Executing Set Of Queries That Have Temp Tables

Jul 29, 2015

I need to grab data from teradata(using odbc connection).. i have no issues if its just bunch of joins and wheres conditions.. but now i have a challenge. simple scenario, i have to create volatile table, dump data into this and then grab data from this volatile table. (Don't want to modify the query in such a way i don't have to use this volatile table.. its a pretty big query and i have no choice but create bunch of volatile tables, above scenarios is just mentioned on simple 1 volatile table ).

So i created a proc and trying to pass this string into teradata, not sure if it works.. what options i have.. (I dont have a leisure to create proc in terdata and get it executed when ever i want and then grab data from the table. )

View 2 Replies View Related

SQL Server 2012 :: Find Queries That Lock Tables Or Not Using Primary Key While Running Update

Jul 20, 2015

I need to search for such SPs in my database in which the queries for update a table contains where clause which uses non primary key while updating rows in table.

If employee table have empId as primary key and an Update query is using empName in where clause to update employee record then such SP should be listed. so there would be hundreds of tables with their primary key and thousands of SPs in a database. How can I find them where the "where" clause is using some other column than its primary key.

If there is any other hint or query to identify such queries that lock tables, I only found the above few queries that are not using primary key in where clause.

View 2 Replies View Related

JOINS To Sub-Queries -vs- JOINS To Tables

Aug 11, 2005

SQL Server 2000Howdy All.Is it going to be faster to join several tables together and thenselect what I need from the set or is it more efficient to select onlythose columns I need in each of the tables and then join them together?The joins are all Integer primary keys and the tables are all about thesame.I need the fastest most efficient method to extract the data as thisquery is one of the most used in the system.Thanks,Craig

View 3 Replies View Related

Help!!!!!!! Lost DB!

Aug 19, 1999

I need help ASAP!

For some reason, we lost a dozen of our tables with valuable data. could be a virus or something that cleared out our data.

The last backup we have is last night at 11PM. If we recover from that backup, all the users lose all of today's work!

Is there a way I can just roll back the transactions from today?????!

I'd really appreciate any help urgently
Joyce

View 1 Replies View Related

Lost :-(

Nov 15, 2005

Hi all......well ill try and explain what I dont understand :-(

I am completely new to SQL. I have downloaded SQL Server Express 2005. I guess I need to download another program now like SQL Query Analyaer so that I can query a database - can anyone recommend a free download that will do the job?? I had a play around with one that I downloaded but to be honest, I have no idea on how to get the two programs talking.

Is someone able to guide me through how to initially set up SQl Server and how to get evrything working??

Much appreciated :-)

Gavsta

View 1 Replies View Related

Lost

Jan 17, 2008

I get multiples of one record. i dont want multiples. but i need to have all the records that are the latest and i dont know how. can you help me.
thanks


SELECT TOP 1 [sn].[WrkstaId]
,[sn].[Computer Model]
,[sn].[Serial Number]
,[sn].[Asset Tag]
,[sn].[Computer Type]
,[id].[Name]
,[id].[Domain]
,[id].[OS Name]
,[id].[OS Type]
,[id].[Last Logon User]
,[id].[Last Logon Domain]
,[id].[Client Date]
,[pu].[_id]
,[pu].[Month]
,[pu].[User]
FROM [Altiris].[dbo].[AeXInv_AeX_HW_Serial_Number] sn INNER JOIN [Altiris].[dbo].[AeXInv_AeX_AC_Identification] id
ON [sn].[WrkstaId]=[id].[WrkstaId]
INNER JOIN [Altiris].[dbo].[AeXInv_AeX_AC_Primary_User] pu
ON [sn].[WrkstaId]=[pu].[WrkstaId]
WHERE [sn].[WrkstaId]=(SELECT MAX([WrkstaId]) FROM [Altiris].[dbo].[AeXInv_AeX_HW_Serial_Number]
WHERE [Serial Number]='68659')
ORDER BY [pu].[_id] DESC



68659Latitude D62028LGGD1Data not accessiblePortableWL-28LGGD1AZCORPMicrosoft Windows 2000Professionaluswclh04AZCORP2008-01-16 17:20:37.000864649Januaryuswclh04

68659Latitude D62028LGGD1Data not accessiblePortableWL-28LGGD1AZCORPMicrosoft Windows 2000Professionaluswclh04AZCORP2008-01-16 17:20:37.000864648Decemberuswclh04

View 7 Replies View Related

New To SQL &&amp; Lost

Apr 11, 2008



After much hard work and effort I finally got SQL Server downloaded and opened. I am at a lost since the "Dummies" books, SQL & SQL Servier 2005 Reporting Services, I have don't (I can't find or understand) explain what I am trying to do. I have been able to create a couple of table, but can't see them. I can see the queries but not the actual table unless I run a query. How can I open the table it self?

Would to import an Access table in the SQLEXPRESS but can't figure out how. Can I get some guidence?

Any help I can get would be helpful. Thank you in advance.

CarLost48

View 5 Replies View Related

Lost In The Land Of SQL....

Jun 8, 2007

 Hello,I am using visual studio express edition.  I making a nice website that uses the ASPNETDB.MDF for all those cool asp 2.0 membership and roles stuff..   This uses a SQL express database.  OK so far.  I have tried and tried to get my website live so I can further test it, but I can't People have been helpful, escpecially Bruce from this forum.  I need more than help I guess.  I really need to get this website up. Can someone please tell me where I can go to hire someone who will talk me through this process.  I am not a programmer, I am a hobbyist.  I understand SQL to select and update my database, but I can't do the stuff I read in FAQ's.  It seems to be written for professionals.  I have tried 3 different hosting services none seem to work.  Please someone send me a private msg.  we can work out terms.   I am sure with someone over the phone that knows sql express and visual web developer expres will have me up and running in a jiffy.  I can send payment via paypal.Jason  

View 1 Replies View Related

Lost In Procedures

Sep 18, 2007

This procedure is missing one importent piece is I need to have a customerID added to the invoice table.  The CustomerID comes from another table called Customer_Invoice_cart.  I don't know how to convert Customer_Invoice_Cart.CustomerID to a @CustomerID to add to the table. If there is anyone out there who is good at stored procedures (unlike me who is learning) could help me out.  FYI I realy cannot get the CustomerID for the .aspx page, it is not called any where.

procedure [dbo].[InvoiceAdd](    @EmployeeID int,    @CartID     nvarchar(50),    @OrderDate  datetime,            @OrderID    int OUTPUT)AS
BEGIN TRAN AddInvoice
/* Create the Order header */
INSERT INTO invoice(    employee_number,    invoice_date)VALUES(       @EmployeeID,        @OrderDate)
SELECT
    @OrderID = @@Identity          /* Copy items from given shopping cart to OrdersDetail table for given OrderID*/
INSERT INTO invoice_books(    invoiceID,     ProductID,    TaxID,    Quanatity,    UnitCost,    UnitPrice   )
SELECT     @OrderID,     Inventory_Invoice_Cart.InventoryID,     Inventory_Invoice_Cart.TaxID,    Inventory_Invoice_Cart.Quanity,    products.UnitCost,    products.UnitPrice    FROM     Inventory_Invoice_Cart   INNER JOIN products ON Inventory_Invoice_Cart.InventoryID = products.ProductID   
WHERE     Invoice_CartID = @CartID
INSERT INTO invoice_books(    invoiceID,    ServiceID,    Service_TaxID,    Service_Quanatity,    ServiceCost)
SELECT    @OrderID,    Service_Invoice_Cart.ServiceID,    Service_Invoice_Cart.TaxID,    Service_Invoice_Cart.Quanity,    services.price_leval1FROM     Service_Invoice_Cart   INNER JOIN services ON Service_Invoice_Cart.ServiceID = services.serviceID   
WHERE     Invoice_CartID = @CartID
/* Removal of  items from user's shopping cart will happen on the business layer*/EXEC Customer_Invoice_Cart_Empty @CartIDEXEC Inventory_Invoice_Cart_Empty @CartIDEXEC Service_Invoice_Cart_Empty @CartID
COMMIT TRAN AddInvoice

View 15 Replies View Related

Lost All SQL Data, Help !!

Aug 18, 2004

I used sql 2000 create a data base at home call 'Mysite' several months ago, there are about eight tables and 30 stored procedures. When I run my asp.net program at home yesterday, and found can't connect to database. The error as follow: "Cannot open database requested in login 'Mysite'. Login fails. Login failed for user 'MINGYANG-MSONXHASPNET'. "

When I open the database, very surpriced to found that my database was suspect and not any item inside it. The suspect database include CommunityStarterKit. But Northwind and pubs database still there?

What happen? Last week I just download new Norton antivirus software, does have any relationship with it? Does data really gone? How to solve this problem?

Please help me if you have these experience.

View 2 Replies View Related

Lost With SQL2005 Exp

Dec 31, 2005

What is the quivalent of EM for SQLExpress2005? With the old SQL 2000 I used EM to manage tables, SPs and such. Now, I cannot even find the databases - I installed the Club Starter Kit and I want to view and modify some tables. How do I do that?

View 3 Replies View Related

Am Completely Lost

Jun 10, 2006

Hello all let me first start out by saying I suck at SQL.  I can do quite a bit with ASP.NET but SQL Server is on area that has haunted me and I have finally decided to bite the bullet and figure this behamouth out.Well here is my first problem, which is the biggest reason I can't seem to understand SQL Server or dataases in general.To have a realtional database you set up tables with foriegn keys and primary keys referenceing the id's like product table has a product name and one of the columns is a user_id displaying the id number of the user in the user table.  From what I can tell you are supposed to set up the user_id in the products table a foriegn key to the Primary Key in the user table.   I may be totally wrong on this though.Now my biggest question is how do you retrive this information the proper way to get it ready to be displayed in a gridveiw or a datalist?  I have been reading SQL Server 2005 for developers and reading online tutorials and it seems like they say you need to set up a relationship and because of the realtionship you don't need to do a join, but I never hear how to use the relationship at all.Please someone help I am so totally lost that i feel like i will never understand. I have spent the last week trying to figure this out and I guess I am just googleing this wrong completely or i am incompentent one of the two.Thank you.

View 1 Replies View Related

LOST SA PASSWORD HELP!!

May 8, 2001

Hello all,

My company took over a project that another company was building. The other company switched all the passwords for the system and the database right before they left. No one has the passwords to the system or the database. Is there a way I can dump the data, or re-mount the drives into a different machine and get the data? Or am I just screwed? I have physical access to the machine and I can do anything needed I just need this data asap!!

TIA

Sean Silvius

View 3 Replies View Related

What If The Logfile(s) Are Lost?

Nov 27, 2000

Hi, maybe someone has some clues to the following situation. Suppose from a SQL 7 database, only the log .ldf files are lost. All datafiles are present. Suppose there is no backup of this database. SQL Server will put the database in the SUSPECT status. The following question is very interesting to me: Can one recover from this situation??? I ask this, because when datafiles are lost, it's obvious that you have lost data, but since the transaction log files are a "bit special", I just wonder how one can survive such a situation.
I know that IF a database has only ONE log file associated with it, and this one log file gets lost, SQL Server will create on startup a new log file. But with multiple log files, it does not behave in this sympathic manner. Is there perhaps any way to recover (for example, an undocumented dbcc command or so) ?
I surely will appreciate any tip or suggestion !! Thanks!!!

View 1 Replies View Related

Data Lost

Oct 22, 2000

We lost all the data we had in a table. We restored the db and the transaction log up to a point in time, but could still not recover the table. We eventually only do db restore without the transaction log. We recovered the data in the table in question, but lost all the data entered that particular day. Does any body have a solution or suggestion that can help? I will be greatly appreciated.

View 2 Replies View Related

Lost Identity Value On

Mar 19, 1999

Hi,
I face a different behaviour between SQL Server 6.5 and 7.0 regarding
the global variable @@identity.
I insert a row into a table with an identity column. This table has
an insert trigger attached which performs another insert into a second table.
Now I seem to lose the identity value (@@identity is NULL).

Example:
Take the following 2 tables:

create table a
(aaintnot nullidentity,
bbintnot null
)

create table b
(bintnot null
)
go

Table a has a trigger attached:

create trigger a_trigger
on a
for insert
as
insert b
select aa
from inserted
go


After this I execute the following SQL statement:

insert a (bb) values (1)
select @@identity


On 6.5 I get the result:
------------------------------------------
1

On 7.0 I get:
------------------------------------------
(null)

Which means that outside the trigger I have lost my identity value.
This feature of Version 6.5 I usually use to maintain
event logs. Using a trigger hides this maintenance nicely from the
application.
My question is now, is this a new feature of Version 7.0 or is it a bug?
BTW: The books online describe this behaviour in the case when the trigger
inserts value into a table with an identity property, which is not the case
in my example.

Regards
Marco

Marco Ruggli
ruggli_m@simultan.ch
Simultan P&I
Kantonsstrasse 1
6246 Altishofen, Switzerland

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved