Viewing 15 posts - 2,611 through 2,625 (of 3,738 total)
I just tried to provide a very simplistic example of a Primary Key and Foreign Key scenario to convey the concept based on the question.
July 20, 2011 at 11:56 am
You may have one or multiple projects, it depends.
Reports, Stored Procedures, Functions etc. should be checked in and out of a Source Control Program.
July 20, 2011 at 11:52 am
airparkroad (7/20/2011)
So in essence, you cannot have a PK that is getting a FK value from another table?
For example you could have Order_ID as the Primary Key in the Orders...
July 20, 2011 at 11:42 am
As was suggested category_db_id by itself is not going to be unique and you need a composite key.
I do not know what the definition of categoryid and category_scheme_db_id are...
July 20, 2011 at 10:58 am
Your decision should be based on the requirements? Is the intended platform a PC?
What edition do you plan on installing? This requires some research.
Not enough information to provide a solution.
Personally...
July 20, 2011 at 10:39 am
The query that you are using to populate the code table has more than one category_db_id .
You will want to alter it to eliminate duplicates.
July 20, 2011 at 10:14 am
jshurak (7/20/2011)
July 20, 2011 at 9:23 am
If you can consolidate the two databases into one that would be the way to go.
You may have some issues in doing so depending upon a number of variables.
How much...
July 20, 2011 at 9:02 am
You will need to set (or check) share and NTFS Permissions.
The best example that I saw was on the Microsoft Book Managing and Maintaining a Microsoft Windows Server 2003 Environment...
July 20, 2011 at 8:28 am
Have you verified that Testtech\sqldbadmin has permissions to the share?
\\Testserver1\sql_backup\FULL_BACKUP\TESTDB\
July 20, 2011 at 7:57 am
opc.three (7/19/2011)
Booo... 😛 Do they know that PowerShell 2.0 is bundled with SQL Server 2008 R2 installations? You do have to enable script execution though..maybe its a security thing.
Here is...
July 19, 2011 at 9:02 pm
WebTechie38 (7/19/2011)
Well I did look for a SSIS forum for SQL Server 2008.I may have missed it.
Opps, Sorry about that...
July 19, 2011 at 9:00 pm
SQLkiwi (7/19/2011)
July 19, 2011 at 8:44 pm
WebTechie38 (7/19/2011)
However, after writing a script, I find you can't debug a script.
Now, I'm not sure if this is the best way to delete old files in SSIS.
I just have...
July 19, 2011 at 8:27 pm
WebTechie38 (7/19/2011)
Hello,Thanks for the example. Unfortunately, corporate policy won't allow me to do any powershell coding.
That is why I was trying to do this in SSIS.
Thanks,
Tony
I have done this...
July 19, 2011 at 8:23 pm
Viewing 15 posts - 2,611 through 2,625 (of 3,738 total)