Viewing 15 posts - 91 through 105 (of 370 total)
There are some options besides dropping a table and recreating it for snap shot replication (at least there is for SS 2000). You can "Delete all data in the...
June 24, 2009 at 7:57 am
You could try deleting the job and / or package and recreating it. Sometimes code get special characters in them that are not visible. The intermitent nature of...
June 24, 2009 at 7:36 am
Just curious, is this a homework assignment or do you work for a school?
Steve
June 23, 2009 at 9:01 am
You could also just restore a full backup from your production database into a new test database. You would just need to enable the logins for the new database....
June 19, 2009 at 12:19 pm
What are the total number of records? If the total number is not much more than the number you want to delete, then copying only the records you wish...
June 19, 2009 at 11:37 am
This it what I use nightly from a job in SS 2000 to create a script file that will rebuild the logins.
osql -E -Sservername -Q"sp_help_revlogin" -o\\Sharename\DirName\rebuild_logins.sql -w512
Like a...
June 15, 2009 at 8:54 am
Isn't sp3 service pack 3? Or are you talking about a Windows service pack and a Sql-Server service pack? It doesn't make sense.
Steve
June 9, 2009 at 7:48 am
If you mean Administrator a windows login that is part of the Administrators group and in Sql Server the BUILTIN\Administrators group still has the default permissions of being a Sql...
June 1, 2009 at 3:13 pm
The main reason for breaking something like address into seperate fields would be validation, things like street names, street types, etc. can be in lookup tables. I see no...
May 12, 2009 at 1:25 pm
One similarity is that they are both acronyms that begin with A, end with I and have an S somewhere in the middle.
Steve
April 20, 2009 at 7:27 am
It is still a little unclear what you require.
Do you want rows that have a particular status (for example, status = 'changed') or do you want rows that...
April 17, 2009 at 8:59 am
If I remember correctly from my Informix days (which can be a little suspect since it has been a while and I am getting older), OUTER JOIN defaulted to LEFT...
April 7, 2009 at 7:50 am
Who installed Fortis for you? If it was a vendor or consultant, you should be asking them some of these questions.
Clearly identify to them that you need...
March 30, 2009 at 7:33 am
Another option:
I execute xp_fixeddrives from a stored procedire and put the results in a table. I run this once a day from with a scheduled job. This table...
March 27, 2009 at 7:37 am
Have you checked into creating a stored procedure that is owned by sysadmin the executes XP_FIXEDDRIVES and give the user execute permission to the procedure you created. I'm not...
March 27, 2009 at 7:25 am
Viewing 15 posts - 91 through 105 (of 370 total)