Viewing 15 posts - 391 through 405 (of 1,536 total)
There's no problem with what you are trying to do.
ARCServe (and most backup solutions) have an open file agent which allows you to backup files that are in use by...
February 2, 2009 at 12:19 pm
The # of tempdb files you should use is dependent on the number of CPU's in the system, and it won't necessarily protect against issues.
The first point of attack should...
February 2, 2009 at 12:10 pm
I don't know about performance, it's something worth testing.
Could you add a column (let's say VendorKeyValue) on GICSPFVendor with a value of 1/2/3 depending on the value of VendorKEYColumn.
Then...
February 2, 2009 at 11:51 am
You can certainly do that. Use your standard html tags and use the html format when sending the email.
January 30, 2009 at 7:07 pm
Firstly check the system databases and the resource database files are in the same location.
And could you post the entire log file?
January 30, 2009 at 5:23 pm
What do you need to do?
Architecture is very much dependent upon the results you are trying to achieve.
January 30, 2009 at 5:16 pm
Sounds like a perfect case for a single database with table partitioning across multiple disks and data compression on that older, less used stuff.
January 30, 2009 at 5:01 pm
If you aren't running programs on there go with the system cache mode.
January 30, 2009 at 4:52 pm
Check out the forum on certification.
If you can't decide what you want to be what would be the point in taking any cert? Of course a cert really means little...
January 29, 2009 at 12:29 pm
It depends.
32 or 64bit?
Amount of memory in the machine.
What other processes might run on the machine (ie file copying, ssis packages, replication)
January 28, 2009 at 11:39 am
If you have a standard naming convention for the SQL logins you could run a linkedserver query using ADSI and bring the data into SQL, and then match the SQL...
January 28, 2009 at 8:32 am
Here's and example that just installs the client tools.
The whole syntax is in BOL, this should help you get started though.
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
; Specifies a Setup work flow, like INSTALL,...
January 28, 2009 at 8:25 am
Upgrade to SQL 2005 or 2008 😉
You can't really create a pull subscription as such from Oracle to SQL Server in this version. You have a couple of options, you...
January 28, 2009 at 7:49 am
Alternatively set execute permissions on the procedure to the user.
January 26, 2009 at 5:30 am
Viewing 15 posts - 391 through 405 (of 1,536 total)