Viewing 15 posts - 43,111 through 43,125 (of 49,571 total)
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic603443-357-1.aspx
November 16, 2008 at 10:25 pm
You can switch a database into norecovery using the backup log statement. It's not possible to switch it into standby the same way.
backup log SomeDB to disk = 'd:\someDB.trn'...
November 16, 2008 at 10:19 pm
Wayne West (11/13/2008)
Woohoo! Very much looking forward to the party and meeting lots of regulars here! :hehe:
Likewise.
November 16, 2008 at 9:08 pm
Jim in Arizona (11/13/2008)
What actually takes place at one of these 'parties'?
Couple of hours of meeting people that you usually interact with online only, gambling monopoly money and generally having...
November 16, 2008 at 9:01 pm
J (11/14/2008)
A developer used code like this, before SQL Injection was exposed:[font="Courier New"]DECLARE @sql varchar(200)
SET @sql = 'SELECT somefield FROM sometable WHERE PersonName LIKE '%' + @data + '%'[/font]
As a...
November 16, 2008 at 8:25 pm
Generally you'd use a composite key if there is no single column that uniquely identifies the row.
November 16, 2008 at 8:20 pm
viji (11/14/2008)
It doesn't take much time when it runs from SQL Server.
Could be a parameter sniffing issue, could be a few other things. Best thing to do here is run...
November 16, 2008 at 8:04 pm
Restore the database from a backup taken before you deleted from the system tables. There's no other way to put the row back.
By modifying the system tables you have severely...
November 14, 2008 at 9:15 am
sp_helpindex for indexes on a table, or use sys.indexes and sys.index_columns to get all of the indexes in the DB
November 14, 2008 at 9:11 am
One thng to bear in mind. In SQL Server triggers are not fired for each row that's inserted/updated. They fire once for an insert/update/delete operation and the inserted and/or deleted...
November 14, 2008 at 9:10 am
Schadenfreude-Mei (11/14/2008)
Does that sound right to you Gail?
Wouldn't know. As I said, you'll have to ask someone who knows sharepoint well, and that someone is not me.
November 14, 2008 at 9:06 am
No need to disable any distribution agents.
SQL with or without replication can handle expected or unexpected shutdowns without data loss.
With replication, the data to be replicated is copied from...
November 14, 2008 at 9:04 am
Depends on where I am and what I'm doing. If I'm away on business and working with a client, I can often do 9 or more hours of work a...
November 14, 2008 at 9:00 am
Viewing 15 posts - 43,111 through 43,125 (of 49,571 total)