TSQL to grant db_datareader and db_datawriter for MS SQL Server
- by consultutah
What is the exact SQL to assign db_datareader and db_datawriter roles to a user in SQL Server?
Say the user name is MYUSER and the DB in question is MYDB.
Thanks!
Search Results
Search found 29121 results on 1165 pages for 'sql 2000'.
Page 217/1165 | < Previous Page | 213 214 215 216 217 218 219 220 221 222 223 224 | Next Page >
-
-
Why is "Structured" in Structured Query Language?
- by Pavan
Hi, What does the "Structured" word means in SQL? Is it because this(SQL) language statements are organized into Clauses, expressions and predicates? Because of this organization, is it called "Structured" ? Kind Regards, Pavan.Read the article
-
SSIS DTS Package flat file error - "The file name specified in the connection was not valid"
- by MisterZimbu
I have a pretty basic SSIS package that is attempting to read a file hosted on a share, and import its contents to a database table. The package runs fine when I run it manually within SSIS. However, when I set up a SQL Agent job and attempt to execute it, I get the following error: Executed as user: DOMAIN\UserName. Microsoft (R) SQL…Read the article
-
Eclipse Debug Mode disrupting SQL Server 2005 Stored Procedure access
- by Sathish
We have a strange problem in our team. When a developer is using Eclipse in Debug mode, SQL Server 2005 blocks other developers from accessing a stored procedure. Debug session typically involves opening Hibernate session to persist an entity which could be accessing a stored procedure used for Primary key generation. Debugging is done in…Read the article
-
JPEG-2000: Can I dynamically resize an image without resampling?
- by Mark Harrison
One of the nice features of JPEG 2000 is that it's easy to downres an image -- just feed out fewer bytes. Is there a similar way to scale the image, such that I could send a thumbnail using bytes in the full-size file, without resampling?Read the article
-
Accessing SQL Data Services via ADO.NET Data Service Client Library
- by Mehmet Aras
Is this possible? Basically I would like to use SQL Data Services REST interface and let the ADO.NET Data Service Client library handle communication details and generate the entities that I can use. I looked at the samples in February release of Azure services kit but the samples in there are using HttpWebRequest and HttpWebResponse to…Read the article
-
What is "Structured" in Structured Query Language?
- by Pavan
Hi, What does the "Structured" word means in SQL? Is it because this(SQL) language statements are organized into Clauses, expressions and predicates? Because of this organization, is it called "Structured" ? Kind Regards, Pavan.Read the article
-
SQL CLR Stored Procedure and Web Service
- by Nathan
I am current working on a task in which I am needing to call a method in a web service from a CLR stored procedure. A bit of background: Basically, I have a task that requires ALOT of crunching. If done strictly in SQL, it takes somewhere around 30-45 mins to process. If I pull the same process into code, I can get it complete in…Read the article
-
How to do a join that removes values?
- by Georg
Customers Holidays id | name customer_id | start | end ---+------ ------------+--------+------ 1 | Peter 1 | 5 | 10 2 | Simon 1 | 15 | 20 3 | Mary 2 | 5 | 20 How should my SQL query look that out of start=11,end=14 I get…Read the article
-
Beginning with SQL
- by Natasha
Hey ALL; I am enthusiastic to enter the world of Databases through SQL , but i don't know if there's pre-requisits of any significance , i only know c# and java . Besides what tools do i need? i have visual studio 2008 and sql server management studio what else do i need? is it necessary to download a server OS? Bare with me…Read the article
-
Sync Framework: Can I syncronise Stored Procedure
- by Belliez
Does the sync framework allow me to synchronise (download only) the Store Procedures on a sql server 2008 server with the Stored procedures on the SQL Server 2008 client? i.e. overwrite the SP on the client when the server SP's have been modifed or new ones created? ThanksRead the article
-
is there any chance of sql injection through selectbox( dynamically created or static)
- by I Like PHP
Hello All, i want to know that is there any chance of SQL injection via selectbox options? if yes then will u please show some demonstration(or refer any link). and also tell me how do we prevent sql injection in selectbox.(using PHP MYSQL) one more: if i create a selectbox dynamically( based on options of…Read the article
-
Using Linq to Sql, does not update, but does not throw exception
- by Russell Steen
Running .net 2008, asp.net, Linq to sql, sql server 2008 express Foo f = db.Foo.First(x => x.ID == id); f.IsValid = true; db.SubmitChanges(); I have a very basic table, which has several fields, and no FK constraints. None of the data saves when I call .SubmitChanges(), but no error is thrown. Any ideas?Read the article
-
Pastebin-like app without sql
- by Vojtech R.
Hi, there is any pastebin-like php open source system without sql? I want to install it on localhost and dont want to backup sql. edit: Highlighting as much as possible languages (as pastebin.com).Read the article
-
Query Results Differ In SQL Mgmt and CFQuery
- by E-Madd
executing the following query in SQL management studio provides results, whereas it does not via cfquery... select distinct locationid, locationname, locationaliasname from vwLocationsWithAlias where 1 = 0 or (LocationName = N'the' or LocationAliasName = N'the') or (LocationName = N'the republic' or LocationAliasName = N'the…Read the article
-
SQL Group By Modulo of Row Count
- by Alex Czarto
I have the following sample data: Id Name Quantity 1 Red 1 2 Red 3 3 Blue 1 4 Red 1 5 Yellow 3 So for this example, there are a total of 5 Red, 1 Blue, and 3 Yellow. I am looking for a way to group them by Color, but with a maximum of 2 items per group (sorting is not…Read the article
-
Copying large amounts of data into a SQL CE database
- by Jekke
If I have a large amount of data in memory, what is the best way to copy it into a SQL CE table? The current technology stack is C#, ADO.net, and SQL CE. My initial idea was to do one INSERT statement for each row of data, but this is time-consuming. Is there an easier way?Read the article
-
Is Streaming Video possible with Sql Filestream?
- by Lieven Cardoen
We have stored all media in Sql Filestream, but now we'll need Video and Audio streaming... Will this be possible with Sql Filestream or will I have to take all of the Video and Audio out of the database? Which technology would you use to enable Video/Audio Streaming? WebORB FluorineFX Wowza (way better I think than the…Read the article
-
Inserting Multiple Records in SQL2000
- by Chris M
I have a web app that currently is inserting x (between 1 + 40) records into a table that contains about 5 fields, via a linq-2-sql-stored procedure in a loop. Would it be better to manually write the SQL Inserts to say a string builder and run them against the database when the loops completed rather than 30…Read the article
-
how/resources to compile a procedural language into [sql]
- by Philip
I am looking into the possibility/feasibility/resources for building a cross compiler which takes a procedural or Object Oriented language like C, or Java and compiling it into SQL. I understand that the advantage of SQL code is performing set operations which is fundamentally different from procedural…Read the article
-
How to convert EER to SQL Table?
- by Khajavi
I have no problem with converting ER to SQL tables, but I don't know how can I convert EER to SQL tables? as you Know that EER has "is a" specification and inheritance, but I don't know how relational databases can connect with inheritance specificationRead the article
-
Changing DBML, how to change SQL database?
- by Robbert Dam
Hi all, A have an app with that uses an SQL database. The application is already released, but now I'm working on an update. In the update I've added an extra column in a table of my database. I've create the database from my DMBL using DataContext.CreateDatabase() (not the other way around, as I…Read the article
-
Debugging stored procedure in SQL Server 2008 Management Studio
- by larryq
Hi everyone, I have a stored proc I'd like to debug in the SQL Server 2008 management studio. I see a number of tutorials about doing this, but the ones I've seen don't have any input parameters going into the SP. My SP has several, and an output parameter as well. Could someone show me how to…Read the article
-
Using IN with sets of tuples in SQL (SQLite3)
- by gotgenes
I have the following table in a SQLite3 database: CREATE TABLE overlap_results ( neighbors_of_annotation varchar(20), other_annotation varchar(20), set1_size INTEGER, set2_size INTEGER, jaccard REAL, p_value REAL, bh_corrected_p_value REAL, PRIMARY KEY (neighbors_of_annotation, other_annotation)…Read the article
-
Notification in case of data changes in SQL and Oralce
- by user171523
I am in the process of building a system where i need to notify a Window Service a .net based application in case of any change in the DB table (Insert , Update , Delete). I know this can be done with the ADO.NET Events in SQL. Is there any common solution for Oracle and SQL which can provide…Read the article
