Viewing 15 posts - 1,141 through 1,155 (of 1,995 total)
i used to do this to prevent my devs running as "SA" - we were required to audit schema changes , so if an object was modified by "SA" then...
May 22, 2012 at 6:01 am
'Table_1' table
- Unable to create table.
you are not allowed to alter the Table
profile name is not valid
The transaction ended in the trigger. The batch has been aborted.
this...
May 22, 2012 at 5:59 am
if it's in an nvarchar column then soembody forgot to put the N' identifier in the insert statement and you have non-ascii characters stored in your string in unusable format
May 22, 2012 at 5:33 am
We run a system that is a hybrid.
local hardware for our internal needs, cloud hosted servers for computational grunt and cloud services (such as ddb, EMR and SQS) for all...
May 22, 2012 at 5:31 am
i really don't think, we should continue this - the original poster seems to be just taking the mick. - and our responses are proboably becoming inappropriate - also i...
May 22, 2012 at 3:47 am
nsi (5/21/2012)
we have a table that has 714k rows. The table takes up 850Gb, where each rows actual data is no more than 2-4k. It has a few int, nvarchar...
May 22, 2012 at 2:57 am
Koen Verbeeck (5/22/2012)
Or Bing!(or even Yahoo if you must)
hey - what's wrong with askjeeves.com
May 22, 2012 at 1:49 am
there are 2 ways
right click on the database and choose properties and then in one of the screens there will be a recovery mode box (i don't have sql...
May 21, 2012 at 10:30 am
Steve Jones - SSC Editor (5/21/2012)
Is that database in recovering or restoring mode?
from the sp_helpdb it looks as if they are all ONLINE
May 21, 2012 at 10:14 am
yep - you need to drop and add the subscription for that table only. - although the article has the same name i think it gets a different internal identifier
May 21, 2012 at 10:09 am
I think the use of the word profile in the error might be relating to some jet 4 components.
if you only need to import this data once then you could...
May 21, 2012 at 10:08 am
looking at that you definatly have a couple of DB that are in simple (WRHL for one) and that will cause that statement to potentially fail..
i think you should really...
May 21, 2012 at 10:05 am
pjl0808 (5/21/2012)
I need to remove an older table (article) from a publication and add a new table back in using 'exec sp_addarticle'.
The new table is Very large and is...
May 21, 2012 at 9:28 am
shani19831 (5/21/2012)
I'm having trouble on finding out what causing this error on one of out sql servers.
Date: 5/21/2012 Source: MSSQLSERVER
Time: 3:00:00 AM Category (6)
Type: Error Event ID 17055
User: NT...
May 21, 2012 at 9:23 am
i'd be tempted to build a small loop (pseudo code below)
while records affected>0
begin
merge oldest record for each widget
remove oldest records from staging for each widget
end
in that...
May 21, 2012 at 9:19 am
Viewing 15 posts - 1,141 through 1,155 (of 1,995 total)