Viewing 15 posts - 211 through 225 (of 2,268 total)
mjbkm (9/26/2011)
Also, do I need to "DO" anything with indexes to keep them running good?
you need to make sure they do not get too fragmented lookup index maintenance
also the...
September 26, 2011 at 3:09 am
I would check the permissions that your Agent is running and ensure that correct permissions to run the SSIS package have been applied.
September 26, 2011 at 2:34 am
deepak.a (9/23/2011)
Can't a dynamic package just be a package that is configured through package configurations/variables/parent configurations/...?
yes , because of this doubt i posted the question , what is dynamic package...
September 23, 2011 at 7:35 am
the records would have remained in the transaction log until the mirror was backup and running.
September 23, 2011 at 5:00 am
I would always use IF exists in the DDL scripts as it avoids getting into errors or creating a mess in the database.
There is also an option that you can...
September 22, 2011 at 10:01 am
kramaswamy (9/22/2011)
No you can't. Flat File doesn't support the tilda character ("~") as a delimiter.
This is incorrect, SSIS does support the tilda character and pretty much most characters...
September 22, 2011 at 9:58 am
TheOxblood (9/22/2011)
steveb. (9/22/2011)
September 22, 2011 at 9:00 am
I wouldn't store the room status (if status is meant to indicate if the room is avialable or not) I would store the rooms and the reservations and...
September 22, 2011 at 8:37 am
Flat File Data source connection will be able to do this, you will just need to change the column delimitter to match your delimitter
September 22, 2011 at 7:46 am
one thing that strikes me as odd is;
why do you have RoomStatusId on both the reservations table and the room table?
and the RoomStatusId on the reservation table is not linked...
September 22, 2011 at 7:43 am
forsqlserver (9/22/2011)
Thanks,Actually their applications SFS does not installing without sa priviledge.
Then it is a poorly developed application,
find out exactly what the applicaiton needs to do with the SQL server and...
September 22, 2011 at 4:34 am
forsqlserver (9/22/2011)
Is it not possible from the proxy account of sql server?
Seriously do yourself a big favour, and sort out the correct permissions for the developers and forget about implementing...
September 22, 2011 at 3:49 am
if they have sa permission then there is not much you can do, and anything you did do they could undo.
best solution is to assign the developers the correct...
September 22, 2011 at 2:33 am
Ninja's_RGR'us (9/21/2011)
steveb. (9/21/2011)
The INFORMATION_SCHEMA views should give you all the information you need.Not for a specific select statement that is not in a view.
No not directly obviously, but...
September 21, 2011 at 6:02 am
The INFORMATION_SCHEMA views should give you all the information you need.
September 21, 2011 at 5:07 am
Viewing 15 posts - 211 through 225 (of 2,268 total)