all groups > sqlserver server > august 2006 > threads for sunday august 6
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Can 2005 mirroring be temporarily 'turned of' programatically?
Posted by togbabe at 8/6/2006 11:24:07 PM
In 2005 there is a new'ish' kind of replication called Mirroring which
is only available in SQL 2005 sp1. When you create a mirrored database
on another server, the 'Principal Database' stays online, while the
'mirrored database' goes into a constant state of restoring. My
question is can 2005... more >>
How to get result of Expression which builds dynamically?
Posted by Kaushik Gadani at 8/6/2006 11:04:01 PM
I am using SQL Server 2000 and in SP or Function, my problem is as follows:
I have one expression in variable of varchar. I want result of that
expression into another variable which is of numeric. For that code look
likes:
----code is as follows----
--Declaration of variables
declare @s... more >>
SQL Data entry, deletion and modification problems.
Posted by kongjecklee NO[at]SPAM gmail.com at 8/6/2006 7:11:51 PM
hi,
Currently, i am doing an asset management with asp and the microsoft
access database. the operating system environment is windows XP
professional edition, service pack 2.
However, after i finish the database design part and testing it, (at my
company's computer), it only can retrieve th... more >>
backup and restore to different db name
Posted by Keith G Hicks at 8/6/2006 3:28:57 PM
I'm reading over the Backup and Restore sections of BOL in an effort to see
how I can backup a database and restore it to a new database. For example, I
have a database named "WidgetsInc." I'd like to back it up and then restore
it to a db with a new name of "WidgetsInc_Test"
BACKUP DATABASE W... more >>
Multiple column primary key
Posted by ibiza at 8/6/2006 8:06:35 AM
Hi,
I'd like to know what is a good reason to use a primary key on more
than one field. In a many-to-many relationship, where I have these
tables :
ITEMS
item_id (pk)
....
....
PROPS
prop_id (pk)
....
....
ITEMS_PROPS
item_id
prop_id
For the table ITEMS_PROPS, is it a good i... more >>
Model Database Log Huge - Can I delete?
Posted by heebe NO[at]SPAM hotmail.com at 8/6/2006 6:55:03 AM
My disk space is full on my server. My SQL Server modellog.ldf and
modellog$4IDR are both over 8 GB each and growing exponentially. Can I
delete these files safely?
... more >>
SQL server express 2005 intermittently slow
Posted by Steve at 8/6/2006 3:48:01 AM
2005 Hi All
I have SQL server express on several test machines and all running XP SP2
Some machines have SQL Express and others SQL Express SP1
On all machines I regularly experience slow connections and data retrieval
from my applications and also from SQL express manager
Is there a k... more >>
database in standby mode
Posted by VSS at 8/6/2006 12:00:00 AM
How to find using tsql, that the current database is readonly or in warm
standby mode ?
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
