Search Results

Search found 27339 results on 1094 pages for 'sql dmv'.

Page 206/1094 | < Previous Page | 202 203 204 205 206 207 208 209 210 211 212 213  | Next Page >

• Query access database from SQL management studio without using linked servers

  - by cfdev9

  How do I query a MS Access database directly from SQL Management Studio, without using a linked server? Ie. something like SELECT * FROM ["C:\Data\Accessdb.mdb"].[SomeTableInAccessDB] Obviously this won't work but is there a away to specify the access database details within a sql query?

  Read the article

• Missing Microsoft.SQLServer dlls

  - by coffeeaddict

  Ok, I installed the Microsoft SQL Server 2005 Backward Compatibility Components here file:///C:/Users/davids/AppData/Local/Temp/instructions_enu.htm but I guess these dlls are not in this. Anyone know where the heck I can get these? Yes, I'm running SQL 2008 so they are missing because they're for 2005. Microsoft.SqlServer.ConnectionInfo.dll…

  Read the article

• VS2010 ultimate DataBase Project + SQL Server 2008: Updating Project from Database

  - by josecortesp

  Hello everyone, this is a quick question: I have this Database Project in a Web app solution with the real database. I want to update the database using SQL server managment studio, and then update the corresponding VS project. This can be done? I know that you can update the scripts in the project, but I'm not the SQL kind of guy, i…

  Read the article

• Cocoa Touch & Sql Server

  - by kim3er

  Is it possible to connect to Sql Server for the purpose of executing simple Sql commands within a native iPhone app? If so, how does one go about it? I'm stumped. More generally, I would at least like to see how this is done with GCC. Thanks in advance, Rich

  Read the article

• Where can I find SQL Profiler 2005?

  - by Kevin

  Is there a way to get the profiler without installing SQL server? If the answer is no, which edition do I need to get the SQL Profiler? Do I need the Developer Edition?

  Read the article

• 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!

  Read the article

• 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 …

  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…

  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…

  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

• Am I Leaking ADO.NET Connections?

  - by HardCode

  Here is an example of my code in a DAL. All calls to the database's Stored Procedures are structured this way, and there is no in-line SQL. Friend Shared Function Save(ByVal s As MyClass) As Boolean Dim cn As SqlClient.SqlConnection = Dal.Connections.MyAppConnection Dim cmd As New SqlClient.SqlCommand Try …

  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

• 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…

  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…

  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

• 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? Thanks

  Read 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…

  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…

  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…

  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

• 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…

  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

• 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

< Previous Page | 202 203 204 205 206 207 208 209 210 211 212 213  | Next Page >