Viewing 15 posts - 361 through 375 (of 610 total)
I only really use tibbling on views and stored procs names and have moved right away from it on tables. My application development work is totally through stored procs and...
January 25, 2010 at 1:32 am
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do anything...
Bet that's the dreaded Act! by...
January 22, 2010 at 2:50 am
we don't ride elephants and lions don't wander the streets.
I'm the one with lions wandering nearby - living next to Lord Bath's Longleat house and safari park in rural Wiltshire....
January 22, 2010 at 1:47 am
I keep a restore script for each main database and include at the end the lines
USE databasename
EXEC sp_change_users_login 'Update_One', 'username', 'username'
where databasename is my database and username is a sql...
January 19, 2010 at 7:10 am
See identical topic http://www.sqlservercentral.com/Forums/Topic849017-146-1.aspx
January 19, 2010 at 7:04 am
Never mind new installations as long as you have a sql 2005 instance somewhere. The package can sit on any 2005 server, the sql agent job on any 2005 server...
January 19, 2010 at 6:49 am
VB.net takes things to a whole new level. I'm a VB.net developer as well as the DBA and I never write that sort of code any more. So much is...
January 12, 2010 at 5:23 am
I'm another 53 year old female DBA/Developer who's just caught up on this thread. I decided I wanted to go into computing at age 14 and then wasn't allowed to...
January 7, 2010 at 6:03 am
Also by default yes, unless I have an appointment elsewhere. I'm on proper flexitime so staying late will add to my credit and be time off later. We tend to...
December 8, 2009 at 9:05 am
As a boat owner myself I can understand the importance of a name. Sailing boats have a character of their own and the name contributes to that.
I've only had one...
November 27, 2009 at 2:46 am
Just found this one. Friday's word was Triskadecaphobia. Stuck in my head all day and prevented me testing a new SSIS package that updates Active Directory from HR system as...
November 19, 2009 at 2:44 am
When working with variables it can be useful to set the Delay Validation option to True on components as they then don't need values until run time. Otherwise set default...
November 19, 2009 at 2:40 am
I would use the SQL Command from Variable option on the Excel data source - the standard query is Select ... From ['Sheet1$'] so you could use a script component...
November 19, 2009 at 2:31 am
I've come to .Net having done loads of languages over the past 30 years from assembler, fortran and cobol to pascal, delphi and now VB.Net. Yet I've always managed to...
November 13, 2009 at 4:13 am
When the software is a major application designed and tested by a third party, that third party is required to install it on our servers and prove it working before...
November 12, 2009 at 4:24 am
Viewing 15 posts - 361 through 375 (of 610 total)