Viewing 15 posts - 2,236 through 2,250 (of 7,187 total)
Indeed. The double-hop issue means you can't use Windows authentication for your linked server unless you have Kerberos configured on the remote server. Have a read about it....
October 31, 2016 at 10:42 am
It sounds as if you're suffering from the double-hop problem. You need either to create a SQL login on the remote server for the linked server object to use,...
October 31, 2016 at 10:20 am
Yes, I did say "it may". It depends what you're familiar with and what the wider requirement is. I'm more comfortable with a single DOS command and the...
October 31, 2016 at 7:58 am
If you have xp_cmdshell enabled, it may be simpler to run a dir command and put the results into a staging table. You can then count the number of...
October 31, 2016 at 6:47 am
Your error has severity 16 - that will only abort the current statement, which means that your batch will continue to run after the error. Higher level errors (19...
October 21, 2016 at 6:00 am
Does the exception in the trigger raise an error message? What is its severity number?
John
October 21, 2016 at 4:19 am
My question is this: if you have 90GB of memory and more on your server, why not let SQL Server use it? But I agree, let's see the execution...
October 19, 2016 at 8:26 am
Guras (10/18/2016)
The database DOES exist. I have queried the sys.databases as well to verify that it exists.
That's one thing eliminated, then. All that's left is either you don't...
October 19, 2016 at 3:00 am
The only way you can know is by actually restoring the databases. You can give yourself a headstart by using the CHECKSUM option in your backups, and doing RESTORE...
October 17, 2016 at 3:24 am
There's a big risk of SQL injection if you do it that way. Can you not have your presentation layer (Excel spreadsheet, SSRS or whatever) do the sorting? ...
October 14, 2016 at 8:41 am
If I've understood correctly, you want to load from one database and then from another and then from another. A config file is only for specifying properties of a...
October 14, 2016 at 8:18 am
You haven't provided much detail, but would something like this work?SET XACT_ABORT ON -- either use this setting or handle errors for the INSERT in your code
BEGIN TRAN
INSERT INTO DB2.dbo.TargetTable...
October 14, 2016 at 2:13 am
This should get you started. You'll need to tweak it, even if only to get the 0 for the first date.WITH NumberedDates AS (
SELECT
Customer
,PurchaseDate
,ROW_NUMBER() OVER (PARTITION BY Customer ORDER...
October 13, 2016 at 9:55 am
Are the two tables in the same database? If so, have you considered putting the INSERT and UPDATE statements in a transaction?
John
October 13, 2016 at 9:48 am
Perhaps the statistics on your tables are out of date. Try updating them with FULLSCAN.
John
October 13, 2016 at 2:23 am
Viewing 15 posts - 2,236 through 2,250 (of 7,187 total)