Viewing 15 posts - 3,181 through 3,195 (of 9,720 total)
mattech06 (7/23/2014)
I have a table BankRef with a BankID column that was populated from the first 24 characters of a column TransDesc from another table BankTransactions.
I wish to repopulate the...
July 23, 2014 at 5:28 am
There are two ways you could do this. The first is using the MERGE keyword. I have not used MERGE, though, because it hasn't yet been useful to me. So...
July 23, 2014 at 5:22 am
How many of those data files are read-only files that could be moved to another disk to free up space for the read-write files?
How much of the data in...
July 23, 2014 at 4:45 am
Ah-HA!
While scripting the securables from the database role, I found this interesting piece of code that I don't see in BOL. This, apparently, is the syntax for adding a specific...
July 17, 2014 at 8:06 am
I think I've found a possible solution. I'm going to create a database role with these permissions in Production and then just assign the user group to that role in...
July 17, 2014 at 6:52 am
Methinks this post by broywin might be marketing spam since that tool has nothing to do with SQL Server.
July 17, 2014 at 5:05 am
So I found HttpWebRequest.Timeout and HttpWebRequest.ReadWriteTimeout. ReadWriteTimeout defaults at 300000, so I'm going to set it at twice that to see if it works (600000). I can't seem to find...
May 14, 2014 at 5:13 am
So this job has been running for a few weeks and for the first week I had to make changes to the package to account for scenarios I hadn't considered....
May 14, 2014 at 4:33 am
So I fought and fought with this, ultimately going back to one of the sample scripts I was given. Here's where I ended up with (two read variables, one write...
May 2, 2014 at 11:48 am
Ditto to that.
Some days I just LURV SQL. If you know what I mean. @=)
May 2, 2014 at 10:51 am
After several attempts of resolving the "security issue," I pulled the package and config file down to my desktop. When I loaded the package into my solution, BIDS complained about...
May 2, 2014 at 9:05 am
Oh, my. I think I found the problem. Will post in a moment if I'm right.
May 2, 2014 at 8:15 am
I remoted into the app server (not web server, I keep saying that wrong) with the login in question. I logged into SSMS using windows authentication and opened up the...
May 2, 2014 at 7:54 am
Did you verify your linked server permissions on the secondary database server to make sure it can actually access the database / table and write to it?
EDIT: And are you...
May 2, 2014 at 7:13 am
Royce Blanks (5/1/2014)
...
thanks if you reply. wouldnt be surprised if after all these years you have moved on and are no...
May 1, 2014 at 11:24 am
Viewing 15 posts - 3,181 through 3,195 (of 9,720 total)