managed objects

Hello people :-)

I'm doing some development work with Visual Studio 2005 and SQLServer 2000. My SQL DB is running on a Windows 2000 Server box in the office, and I'm doing the development on my XPPro workstation. Now I've been trying to connect to the Win2000 box though VS and although I can see the server and the DB when I hit ok I get this error

"The SQL server specified by these connection propertise does not support managed objects"

What the heck does that mean?

any help would be great :-)Well when you are using VS2005 it assumes you are connecting to SQL Server 2005, quick fix I think is to install .NET framework 2.0 in the Win2k server and make sure IIS is running even if you are not using it. Hope this helps.

Manage Permissions Script

How can I create a script that will set all the permissions for a specific user for some objects in a database?
Thx in advance.How can I create a script that will set all the permissions for a specific user for some objects in a database?
Thx in advance.

What kind of permissions are you trying to set? Are you trying to copy permissions from an existing user? Or are you trying to grant specific privileges on all objects? Or specific privileges on specific objects?

Please amplify your question a bit.

Regards,

hmscott|||I want to grant (or not) someprivileges on specific objects.
I made something like that:
GRANT SELECT ON [dbo].[AGENT] TO [web]
GO
DENY UPDATE , INSERT , DELETE ON [dbo].[AGENT] TO [web] CASCADE
GO

Actually, my problem is that I have to deploy my stored procedures on another server where these settings should be set up.
But it looks when I made my export to that server I lost the grants for my user.
That's why I thought it will be nice to have a script that will make the job automatically.
Anyway, I should change the way I made the export because I have checked up the option "Drop destinaton objects first".

Manage changes in SQL object.

1. How do I manage changes in SQL Server objects? Not schema.

SQL Server does not have built-in version control. so can we manage or not.

Use an external source control provider to store the sql server object scripts in.|||

Help me understand what you mean by

SQL Server objects? Not schema

SQL Server objects ARE schema...

|||

Hi Arnie,

I have many databse.

Schema means- like procedure or function etc.

I want to use data in VSS not schema.

|||

VSS is typically NOT for data. VSS is source control for schema objects, i.e., table definitions, view definitions, stored procedure and function code, etc. In other words, source control for the schema objects source code.

If you want a tool to manage data, then perhaps you should examine some of the third party products that will be able to compare databases and provide you reports and scripts about the differences in data.

Comparison Tools
Object Comparison:
AdeptSQL Diff
AlfaAlfa Software - SQL Server Comparison Tool
ApexSQL – SQL Diff
Best SoftTool – SQL DBCompare
e-Dule - DB SynchroComp
PrimeLogics - DataVision 2007
Quest – SchemaCompare
RAC4SQL's QALite (Free)
Red Gate – SQL Compare
SQL Effects Clarity
TASC - SQL Delta
Teratrax Database Compare
TulsaSoft - SQL Examiner
Voltex Data Systems - SQLDBcontrol
XpressApps - sqlXpress Diff
xSQL Software - xSQL Object
Data Comparison
ApexSQL – SQL Diff
Best SoftTool – SQL DBCompare
Quest - DataCompare
Red Gate – Data Compare
TASC - SQL Delta
TulsaSoft - SQL Data Examiner
xSQL Software - xSQL DataCompare
DTS Comparison
Red Gate – DTS Package Compare
Server Comparison
Quest - ServerCompare
Free Tools
RAC4SQL's QALite (Free)
SQL Effects Clarity CE Edition