Viewing 15 posts - 4,921 through 4,935 (of 7,191 total)
Cadavre (11/23/2011)
This is untested, so test before you run it.
DECLARE @sql AS VARCHAR(MAX)
SELECT @sql = COALESCE(@SQL, '') +
CASE WHEN ROW_NUMBER() OVER (PARTITION BY...
November 23, 2011 at 8:22 am
compare tables, if new records, insert, if no longer exist, delete, if exist but some columns are different, then update.
So you want to compare every column in every row? ...
November 23, 2011 at 7:22 am
Connect to the target server with SSMS, open Security and then Logins. Do you see a login there either for the service account, or for a domain group of...
November 23, 2011 at 6:55 am
Puneet
Two possibilities
(1) The account under which SQL Server Agent is running does not have access to the server to which you're trying to connect
(2) You are using Package Configurations, and...
November 23, 2011 at 4:17 am
Either put the two logins in the same Windows group, or if they're SQL logins, use roles within the databases to assign permissions. This won't help you with the...
November 23, 2011 at 3:43 am
If you're allowed to modify the package, you could enable logging and see where it's up to when it hangs. Otherwise, you'll probably need to keep a close eye...
November 21, 2011 at 8:16 am
What is the overall size of your database? How often do you do full and log backups?
John
November 21, 2011 at 6:05 am
Read about Package Configurations. If you have all your changeable properties in variables, all you have to do is set the value of those variables in your configuration file...
November 21, 2011 at 4:32 am
Or you can do it like this. I've used spt_values in master for my numbers, but if you prefer you can generate a numbers CTE on the fly or...
November 21, 2011 at 4:25 am
I would cheat and create a table with StartDate and EndDate that listed all the periods.
John
November 18, 2011 at 9:38 am
Debbie
Create a table in your database that holds the years you are going to use as parameters. In your package, select from this table into an Object variable. ...
November 18, 2011 at 8:57 am
It's what you get when you press the "Return" or "Enter" key on your keyboard.
John
November 17, 2011 at 9:42 am
Looks correct. The only thing I can think of is that you have a carriage return character in your command.
John
November 17, 2011 at 9:39 am
Probably best to export from a SQL statement instead of directly from the table. Include a case statement that converts the Boolean values into 'True' and 'False'. You...
November 17, 2011 at 9:37 am
Remove the path from the target name for the file, so that you specify only the file name itself.
John
November 17, 2011 at 9:32 am
Viewing 15 posts - 4,921 through 4,935 (of 7,191 total)