Viewing 8 posts - 1 through 8 (of 8 total)
Interesting. Try this and see what you get.CREATE DATABASE TestDB
GO
USE [master]
GO
CREATE LOGIN [test] WITH PASSWORD=N'test', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [TestDB]
GO
CREATE USER [test] FOR LOGIN [test]
GO
CREATE SCHEMA BI
GO
GRANT SELECT ON...
April 6, 2018 at 2:49 pm
Have you granted object level permissions?GRANT SELECT ON View TO Login
I just created a login on my test box with no permissions; just mapped to...
April 6, 2018 at 12:57 pm
You may want to consider implementing Ola Hallengren's Index and Statistic Maintenance solution and streamline these operations, as is mentioned in the URL Scott posted above.
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
April 5, 2018 at 2:50 pm
April 2, 2018 at 9:27 am
Can you connect to the remote server as the user?
If so, can you run the query under those credentials?
USE LinkedDB
GO
SELECT *
FROM dbo.TableA
March 29, 2018 at 4:24 pm
As others have mentioned, use #temp tables. A general rule of thumb I go with is 1000 records. If it's considerably more than 1000 rows, a #temp table is generally...
March 27, 2018 at 1:00 pm
Thanks Micky! This is spot on.
May 22, 2013 at 7:59 am
This is not a homework assignment. I work at a community college and this is a report that is currently manually edited and distributed via word documents to all...
May 20, 2013 at 2:52 pm
Viewing 8 posts - 1 through 8 (of 8 total)