Viewing 15 posts - 61 through 75 (of 144 total)
Looks like you just need a FETCH NEXT statement in the loop.
For troubleshooting purposes, you can log the key value(s) to some other table, so you can see if it...
April 24, 2019 at 6:36 pm
Start with this monstrosity. It will generate all of the individual ALTER TABLE statements, but you will want to check them thoroughly. You will need to drop/rebuild any indexes that...
April 23, 2019 at 3:16 pm
If you developed the package as part of a solution, there will be a run button in the ribbon at the top, or in the debug menu.
If you create/modify a...
April 10, 2019 at 8:47 pm
You may need to give read-only rights on the data sources (I think I remember having to do this on a SharePoint embedded instance), but it should work. we have...
March 28, 2019 at 2:14 pm
You can try SQL Prompt from Red-Gate. It may not be able to tell you if joins are not optimized, but it should be able to tell you if you...
March 28, 2019 at 2:11 pm
In my experience, applications do not usually need sa rights. This sort of request, really just means that the application team has not done any sort of permissions testing. For...
March 27, 2019 at 10:57 am
the result is you would get an error from the login not existing. If you need the user, you can always create the user without a login
March 21, 2019 at 10:45 am
From what I remember of doing mirroring (it is a deprecated feature, these days), is that the mirroring will pick up just fine after a failover. A failover is really...
March 18, 2019 at 11:07 am
Are you supplying a server name in your command line (-S)? If not, it will likely look to the local machine, where you may have a SQL Express instance running. ...
March 15, 2019 at 2:30 pm
The minimum permissions the user will need will be:
Select on the view itself.
Select permissions on any tables referenced by the view, that are not in the local...
March 1, 2019 at 11:29 am
Schedule these two procedures to run at different non-overlapping times:
sp_ecommerce_maintenance_pricing_amazon
usp__ecommerce_BulkProcess_Inventory_Batch_Process
January 22, 2019 at 12:16 pm
Ultimately, it depends on the error message. My guess would be that the stored procedure is accessing more than just the local database, especially if you are calling it by...
January 16, 2019 at 1:28 pm
I am assuming here that you are getting some sort of "Date out of range" error? If not, what is the error you are getting? Does the Export Data wizard...
January 8, 2019 at 10:20 am
Just to check, are the IP addresses for the private network on a separate subnet from the public addresses? After that, all I can think of is WINS is trying...
December 10, 2018 at 9:40 am
What is the problem in rebuilding them? Are you running into blocking issues? Or does the process error out? Are these very large indexes?
December 4, 2018 at 12:57 pm
Viewing 15 posts - 61 through 75 (of 144 total)