Viewing 15 posts - 1,036 through 1,050 (of 1,222 total)
Mmmm, for me the issue usually occurs when reviewing/maintaining someone else's code and that code has dodgy null usage. When used correctly, nulls are a good thing. Overall,...
April 9, 2007 at 10:56 pm
Integration services runs as a service called "SQL Server Integration Services". Remember that you can install SQL Server 2005 components on your workstation as well as on your server(s)....
April 9, 2007 at 7:19 pm
The question mark "?" in my post was not a typo - the string needs to be
Exec StoredProcedureName @WeekNumber = ?
To pass the week number in from...
April 4, 2007 at 1:42 am
Yes
First you need to create a global variable to hold the week number. To do this, select "properties" from the "Package" menu. Select the Global Variables tab and...
April 4, 2007 at 12:10 am
I think that DTS can be used to improve the performance of the load process you are doing. You are probably loading a single row at a time which...
April 3, 2007 at 10:29 pm
Replication does not replicate permission changes - and it never sets them in the first place. You will need to implement these yourself.
Replication creates tables etc when...
March 25, 2007 at 10:01 pm
Did you specify the @local parameter - this is needed when adding the name of an instance to itself
sp_addserver 'myServerName', 'Local'
If you do not include this parameter, SQL Server assumes...
March 25, 2007 at 9:53 pm
Why not stop the replication agents (distribution/logreader etc), backup the database and then restore it specifying the new location for the data file and then start the replication agents again....
March 25, 2007 at 9:43 pm
Have a look at the output from sp_linkedservers - I think it gives you some but not all of the info you need on linked servers
DTS can transfer logins -...
March 18, 2007 at 9:13 pm
I would not expect any significant change in performance because of any additional RAM being available. Yes, your cache hit ratio might improve because there it is more likely...
March 14, 2007 at 8:45 pm
Yep - same application give or take features added/changed with the change from Notification Services 2000 to Notification Services 2005
March 5, 2007 at 8:54 pm
By default, when you save a DTS package it is saved to location "SQL Server". I am assuming that this is what you did with your first SQL Server...
February 25, 2007 at 7:44 pm
The second question is easy - add an operator (this is under SQL Server Agent in Enterprise Manager) and then configure the Replication Agent Failure alert to send a message...
February 21, 2007 at 9:35 pm
If the changes (to tables that are already published) have already been made, it is too late. You will need to drop the article and then re-publish it.
If the...
February 21, 2007 at 9:30 pm
You can use the DB_NAME() function to get the database name
e.g. Select db_name(11)
The object id is specific to the database that the object is in (and the same...
February 21, 2007 at 9:21 pm
Viewing 15 posts - 1,036 through 1,050 (of 1,222 total)