Tag Info

New answers tagged

1

Please enable this setting: http://msdn.microsoft.com/en-gb/library/ms188694.aspx http://msdn.microsoft.com/en-us/library/bb669059(v=vs.110).aspx This allows the security permission between databases to propagate. Additional details described well in this blog: ...


1

Version 10.1.2531.0 is for SQL Server 2008 Service Pack 1. The following table lists the major releases of SQL Server 2008. Release Product version SQL Server 2008 Service Pack 3 10.00.5500.00 SQL Server 2008 Service Pack 2 10.00.4000.00 SQL Server 2008 Service Pack 1 10.00.2531.00 SQL Server 2008 RTM 10.00.1600.22 Check more ...


1

It is because you need to create the breakpoint using the database name and object id rather than setting a breakpoint in a random SQL file which is what you get by choosing modify. See: https://sqlserverfunctions.wordpress.com/2014/09/12/setting-breakpoints-in-ssms/ Ed


0

You have to enable xp_cmdshell on the remote machine using sp_configure. Also make sure that the SQL server instance allows remote connections.


2

Network server discovery via SQL Browser Service is done via UDP broadcast. Broadcasts are subject to local network segment rules (as in network mask, default gateway etc), so it may be that your server is on a different segment and the broadcast does not reach the desired servers. If that is not the case then the obvious culprit would be Firewall rules.


10

Don't just use the whole table. Instead choose the option to write a query. Then simply write a select statement that doesn't use that Identity Column. Alternatively, when you map columns, if you click "Delete rows in destination table", it will truncate the target table before loading data. If the opportunity exists for data to be removed from the ...


0

Granting db_owner to a user (the database level principal) is a very high level of permissions and should only be granted to database administrators. You should probably consider only granting those permissions needed by the individuals. Members of ddl_admin for example can make DDL changes (create/alter tables, create/alter SPs etc) to the database ...


1

As per this question want to be able to access it and change anything in it within reason (Tables, Procs, Views, Schemas etc.) You can create a login using below acript and map it to user and then grant necessary privileges to user. Granting privilege to SQL server user is complex topic and you must read this article and this for understanding ...


0

Hi Please assign permission for that user and run following statement. use database grant select on view_name to login_name after executing this command your problem will resolve.


4

To clear things up, language-wise: In SQL Server, the login is global for the SQL Server instance (a "server principal") and allows a client to log on to the server with very limited permissions. Once you've set up a login, you can assign users to this login. A user is the login's security principal in a specific database ("database principal"), which means ...



Top 50 recent answers are included