Viewing 15 posts - 1,411 through 1,425 (of 1,838 total)
oops, sorry for the version confusion, forgot I was answering a question in SQL Server 2005 forum
March 12, 2013 at 2:58 pm
if you have DBMail and an operator setup, then it's simple since 1105 is a logged error:
USE MSDB
EXEC sp_add_alert @name = 'Error 1105: Filegroup Full', @message_id=1105, @Severity=0, @enabled=1, @delay_between_responses=900, @include_event_description_in=1
EXEC...
March 12, 2013 at 12:48 pm
if you actually have a .dtsx file, you can work with it by doign the following:
in Visual Studio 2008 (BIDS) create a new Integration Services Project.
In the Solution Explorer, right...
March 12, 2013 at 12:03 pm
ron.grace (3/9/2013)
March 11, 2013 at 1:08 pm
monilps (3/6/2013)
2 tables involved here...Same database...
One big gulp...
OK, trying to move a large number of records in one big batch is probably why it looks like no records have been...
March 6, 2013 at 11:08 am
dbx (3/6/2013)
...the stored procedure only takes 4 parameters, so i wouldn't say that's too many...
The number of parameters isn't as much an issue as if any of the parameters are...
March 6, 2013 at 10:12 am
If you create a temp table before the 3 stored proc calls, you should be able to do an INSERT INTO (column_list) EXEC execute_statement on each of the 3 stored...
March 6, 2013 at 10:00 am
The easiest way to see that is through the dynamic management views. CLIENT_INTERFACE_NAME in SYS.DM_EXEC_SESSIONS
SELECT s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name, s.status AS session_status,
db_name(er.database_id) AS database_name,
...
March 6, 2013 at 9:33 am
monilps (3/5/2013)
CREATE TABLE [dbo].[pp]...CREATE TABLE [dbo].[pp_staging]...
ALTER TRIGGER [dbo].[patient_property_arrival] ON [dbo].[patient_property]...
let me know if you need any additinal info. thanks.
so we have 3 tables involved here, what is the source and...
March 6, 2013 at 8:56 am
An index stays in synch with the table it's on. If the table already had rows in it when you create the index, then that index will have the...
March 4, 2013 at 1:55 pm
tshad (3/1/2013)
Why would the table that I am deleting a 3rd as many records take a ton of time longer?
I thought about disabling the FKs but not sure what happens...
March 1, 2013 at 2:10 pm
Database Mail in SQL Server uses the Service Broker functionality. As mentioned before, the sp_send_dbmail command just queues up messages. As part of the service broker functionality, when...
March 1, 2013 at 1:51 pm
I think the answer to question 11 is a bit subjective. First, in many companies, there isn't a distinction between database developers and application developers, the same person typically...
February 28, 2013 at 11:24 am
Rod Early (2/22/2013)
I got a TI-99/4A computer in 1982 when I was a sophomore in high school...
I also started with the TI-99/4A, I was in 7th grade at the time...
February 22, 2013 at 11:02 am
TravisDBA (2/14/2013)
February 14, 2013 at 10:36 am
Viewing 15 posts - 1,411 through 1,425 (of 1,838 total)