Viewing 15 posts - 34,456 through 34,470 (of 39,793 total)
When you say change the recovery model, from what to what?
I don't think you need to mess with replication. If you are moving from simple to full, you need to...
November 8, 2004 at 8:13 am
Shouldn't that be server=?
November 7, 2004 at 9:03 am
You can redistribute the DTS DLLs onto the client machine if you need to. If you just want to run the program on the server, but initiate from teh client...
November 7, 2004 at 9:03 am
A security alert was issued because the way SQL Server works is to respond to 1434 with the port of the instance and what it is. Since you are disclosing...
November 7, 2004 at 8:59 am
If you have date feilds in your tables, you can delete based on dates, but you cannot "rollback" all changes based on a date with the SQL Server product.
If you...
November 7, 2004 at 8:56 am
I swear that I've had this working before. We had all kinds of servers attaching to the AS/400, but perahsp the SQL tools were installed last. I'd try a reinstall...
November 7, 2004 at 8:55 am
What if two rows are inserted?
You need someway to determine what the "order" of the rows i n tank is. Perhaps the date? (assuming this is datetime)
create trigger ...
insert...
November 7, 2004 at 8:54 am
What version of client tools are you using? I can register my SS2K servers, SP3a on W2K from my W2K3 server.
November 7, 2004 at 8:51 am
What error are you getting? # and msg?
I'm not sure if this helps the server, but dbcc freeproccache will clear the cached plans from SQL Server. Might allow some memory...
November 5, 2004 at 11:08 am
Once SQL Server has the memory, unless the operating system requires it, it will not get released. How much memory on the server and what does SQL grow to?
QA and...
November 5, 2004 at 10:57 am
select * from information_schema.columns. Sort, rearrange as you like, then save the data into a file. (CSV) and open in Excel.
November 5, 2004 at 10:50 am
T-SQL, or Transact-SQL is from Sybase and I've been working with it since 92, when it was SQL Server 4.2 on OS/2, ported from Sybase v4.2 on *nix. I'd suspect...
November 5, 2004 at 10:27 am
select
case when t.type = 'D' then t.amount
end 'Debit'
, case when t.type = 'C' then t.amount
end 'credit'
from Transactions t
gets you them...
November 4, 2004 at 10:26 am
You should have your maint plans create a jog. The error code in the job is worthless, check the log.
November 4, 2004 at 10:25 am
Viewing 15 posts - 34,456 through 34,470 (of 39,793 total)