I am relatively new to SQL Server.
I have a command file with the following contents :
osql -E -i%1.sql -d%2 -oq:\%1.log
The sql script file has a number of insert/update statements.
The log file produced looks something like this :
1> 2> (1 row affected)
1> 2> (1 row affected)
1> 2> (0 rows...
I am trying to update some rows in a table using Query Analyzer.
Using the Object Browser and selecting one of the User Tables,I then right click on this table.
I can click on the Open option to view all rows but I want to choose the Edit option but it is dimmed.
Is there some setting that needs...
I am running SQLServer 2000.
I have a database which is in Simple recovery mode.
There is a DTS package which I run everynight which copies
data from an external data source.
However, it tells me that the transaction log for the
database is full.
I have put the following SQL task as the first...
We have a situation where we have a database on an
enterprise server which needs to be replicated onto a number
of laptops.
These laptops go out into the field and may need to be updated
from the enterprise server database several times each day.
The enterprise database is approximately 2 Gig...
I am relatively new to SQLserver and I am putting together
some TSQL code to backup our databases and transaction logs.
I want to also include some code which will delete backup
files older than a specified number of days.
Has anyone written some code to do this ?
TIA
I am new to SQLServer so please be gentle ;)
I have set up a DTS package in SQLServer200 to populate tables in a database. The recovery mode is simple yet
I am getting the message:
The log file for database 'bwtest' is full.
I was lead to believe that transaction logging did not
occur in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.