How to Grant limited permissions to create views in another schema?
How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...
2015-07-08 (first published: 2015-07-01)
3,091 reads
Prakash K
- Website: http://sqlserversdba.wordpress.com
SQL SERVER REPORTING SERVICE MIGRATION
Last week as part of job I had to migrate the Databases and Reporting Service of SQL server 2005 To...
2015-06-22 (first published: 2015-06-11)
3,186 reads
SQL Server 2016 features to look for -2
In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...
2015-06-11 (first published: 2015-06-08)
4,953 reads
SQL Server 2016 features to look for -1
At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...
2015-06-03
1,137 reads
SQL server 2014 Service Pack is available (AGAIN ) !!!!!!!!
Yes after its initial release and pull out Microsoft has again made the Service pack 1 for SQL SERVER 2014...
2015-05-20
451 reads
Editing Table Rows in SQL
When you create a database driven website, you actually write SQL scripts to insert data into the database. You also...
2015-05-10
702 reads
SQL SERVER Interview Questions
All you who wants to pursue professional life as SQL SERVER DBA, its always hard to crack the interview . But...
2015-05-08
1,430 reads
SQL Server Migration Plan
As a DBA , migration of database is a part of day to day activities. sometime its a quite hectic task...
2015-05-05
16,163 reads
Microsoft SQL Server RELEASES
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database its primary function is to...
2015-05-02
784 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
Works on all other sql2022 servers but not on production. - must be dropped
HI We have a small utility that is giving us a "#table is missing...
Convert common Separated number to # table
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Things to be considered before implementing database auditing
Hi All, As part of security compliance, we are told to audit DML &...
Ask SSC