Unable to create linked servers using SQL Server Management Studio
Apr 15, 2016 · I am unable to created Linked Servers using SQL Server Management Studio on SQL Server 2008 R2 as I get the error Cannot find table 0 . (System.Data) and I also get ...
can calculation be defined in SQL Server Management Studio?
Aug 18, 2006 · If your only alternative is SQL Server Management Studio, you can add a calculated member by running an ALTER cube script. In SSMS connect to the AS server where your cube is …
DBA needs to justify Local Admin access on SQL DB server to …
Oct 1, 2010 · My network & servers manager wants me to document why I, the DBA, need to have Local Admin access to the production database and reporting servers. Part of the problem is that I sit with …
Cannot create a database (user does not have permission)
Nov 29, 2012 · I have created a SQL server user test, and tried local connection with the server with this user, it works. I have enabled remote connections. And enabled IP connections with dynamic ports. I …
Equallent Application dbms_application_info""in SQL Server
Aug 19, 2010 · If so, you can definitely use sp_who2 or some of the DBCC commands to retrieve this information in the SQL Server. However, you can get more information from a few of the Dynamic …
2016 Express Setup Error 0x800736B3 - social.msdn.microsoft.com
Feb 24, 2017 · Title: Microsoft SQL Server 2016 Express Advanced SP1 Knowledge Based Article: KB 3182545 Version: 13.1.4001.0 Architecture: x64 Language: 1033
Unable to serialize the session state - social.msdn.microsoft.com
Jan 7, 2008 · Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef …
Extract .ispac file from IS catalog - social.msdn.microsoft.com
Feb 19, 2015 · You can create your own procedure to extract .ispac files from SSISDB. In your own procedure, use " SSISDB.catalog.get_project" stored procedure to retrieve project_stream, then turn …
What is the difference between db_accessadmin ROLE and …
May 16, 2008 · The problem is that SQL Server 2005 defines several default ROLES such as db_accessadmin, db_backupoperator, db_datareader, etc. and at the same time it also defines …
The INSERT statement conflicted with the CHECK constraint
Jan 19, 2014 · Run the stored procedure/query in sqlserver management studio or query analyzer and see if it succeeds (with same paramaters) IF it fails, post the statement that you used.