Viewing 15 posts - 976 through 990 (of 1,409 total)
Perhaps you can use the import/export wizard to create an initial SSIS package. Save this package in the last step of the wizard instead of executing it. Modify the saved...
July 2, 2013 at 7:12 am
nikunj_lodhi (7/2/2013)
I wanted to know that can we have a single instance on two different databases?
I am till now aware that it is a one to one relation(correct me...
July 2, 2013 at 6:32 am
techmarimuthu (7/2/2013)but i wanna extra add distinct for C_recid
Do you mean there are more records in the resultset with the same value for "C_redid"? And you want just 5 unique...
July 2, 2013 at 5:39 am
If "Backup Exec" is really SQL aware then it should be able to do a complete point-in-time recovery, but maybe you can better ask this on a forum of the...
July 2, 2013 at 5:26 am
I'm sorry, I didn't understand you wanted the order of the resultset be the same as the sequence order entered in the IN clause.
That requirement is not a standrd function...
July 2, 2013 at 4:25 am
Just add an ORDER BY clause:
select *
from customer
where C_recid in (50200,50194,50430,50191,1)
order by C_recid
July 2, 2013 at 4:07 am
Toreador (7/2/2013)
July 2, 2013 at 4:04 am
HildaJ (7/1/2013)
I also tried running sp_changedbuser 'userB' and the query never seems to finish.
Run the action again and look in the activity monitor (or use sp_who or something else) for...
July 2, 2013 at 2:08 am
When it happens again, you could try to connect to the SQL instance using a "Dedicated Admin Conection (DAC)". If you even can't connect to the Windows server when the...
July 2, 2013 at 1:59 am
ramanathan.raman88 (7/2/2013)
c# - Insert data from DataTable to database table
I see you have edited your original post, but it is still not telling us much. Do we need to guess...
July 2, 2013 at 1:11 am
raghuldrag (7/1/2013)
create table users(
users_id int primary key,
[...etc...]
)
insert into users values('0001','Ram','ram@123','IT','programmer')
insert into users values('0002','Ra','ra@123','IT','Designer')
insert into users values('0003','Raju','raju@123','Sales','Area Sales Manager')
Because your table is created with the column "users_id" with datatype INT, you...
July 2, 2013 at 12:56 am
No trigger needed!!
Just use an INSERT command. The thing you need to take care of is that the value of "users_id" you enter in the [travel_request] table must allready exists...
July 2, 2013 at 12:43 am
Take a look at the free e-book of Grant Fritchey: Disecting SQL Server Execution Plans
http://assets.red-gate.com/community/books/assets/sql-server-execution-plans.pdf
July 2, 2013 at 12:26 am
Please explain your question, it is very unclear. Please be more specific and give more information about your situation and what you want to do.
July 2, 2013 at 12:22 am
Gail Shaw has said it all.
It doesn't sound like you hhave a maintenance plan implemented. Do you take regular SQL backups of the databases?
Take a look at the maintenance scripts...
July 2, 2013 at 12:18 am
Viewing 15 posts - 976 through 990 (of 1,409 total)