Viewing 15 posts - 2,476 through 2,490 (of 2,636 total)
Here's a quote from Books OnLine:
The Unicode specification defines a single encoding scheme for most characters widely used in businesses around the world. All computers consistently translate the bit patterns...
October 26, 2004 at 3:29 pm
Check this site for a list of data modeling books. In particular, look at books by Date, Darwen, and Codd.
Greg
October 26, 2004 at 12:28 pm
timestamp - used to version stamp table rows. It is automatically incremented every time the row is modified
nvarchar - used for variable character data that will translate to the same characters...
October 25, 2004 at 9:22 am
sswords,
I'm curious as to why you run hourly log backups 24 hours a day if your database is being used "9 to 5".
Greg
October 21, 2004 at 4:13 pm
Do you have a full database backup from before the last transaction log backup? You can't restore a log backup until you've restored a full backup.
If you do have a...
October 20, 2004 at 10:07 am
Ricardo,
Check cross database ownership chaining as Aaron suggests and also make sure that dbo is mapped to the same login in both databases. I make a point of making SA...
October 19, 2004 at 1:06 pm
I'll second that. See my reply to Michael's question in this forum. You might also verify that any parameters you are passing to the child package are correct.
Greg
October 19, 2004 at 12:34 pm
Select only the package name, not a version, when you define your Execute Package task. If you specify only the name, DTS will always use the latest version.
Greg
October 19, 2004 at 12:30 pm
Yes, you can when using outer global variables because they're available in both packages.
If you just want to know if the child package succeeded or not, you can use workflow...
October 18, 2004 at 10:11 am
This has been discussed several times in these forums and the consensus seems to be that sp_server_info selects from a system table that doesn't always get updated by hotfixes and...
October 15, 2004 at 10:01 am
More information, please. What goes wrong? Is there and error message?
Greg
October 15, 2004 at 9:33 am
In the parent package, create the global variables that you want to pass, then create an Execute Package Task. On the 'Outer Package Global Variables' tab, select the global variables...
October 15, 2004 at 9:26 am
The reason the testdatabase users are missing after the restore is they aren't in the production database that is being backed up and restored. When you restore a database, even...
October 14, 2004 at 10:00 am
End of support depends on release date of next version. Here's the link:
http://support.microsoft.com/gp/lifesrvr
Greg
October 11, 2004 at 5:31 pm
There's no way I know of to change the default in the wizard. If you move data between the same databases often, you could save as a package with delete...
October 8, 2004 at 10:20 am
Viewing 15 posts - 2,476 through 2,490 (of 2,636 total)