Search Results

Search found 27342 results on 1094 pages for 'sql denali'.

Page 511/1094 | < Previous Page | 507 508 509 510 511 512 513 514 515 516 517 518  | Next Page >

• ASP.NET MVC Stored Procedure

  - by Pinu

  I am using a ms sql stored procedure to get a set of records , when i am adding this stored procedure to my LinqToSql class and using it my repository it shows like it is returning a int value but it should be returning a set of rows. Is there some thing wrong with my stored procedure or some thing else???

  Read the article

• Running a simple VBA script to test a connection

  - by brohjoe

  I'm trying to test the connection of a GoDaddy SQL Server database. I'm getting an 'invalid connection string attribute.' What's wrong with this script? Dim cnn As ADODB.Connection Dim canConnect As Boolean Public Sub TestConnection() Set cnn = New ADODB.Connection cnn.Open "Provider=sqloledb;Data Source=GoDaddyServer.com;Initial Catalog=dBase1;UserID=userID; Password='password';" If cnn.State = adStateOpen Then canConnect = True cnn.Close End If MsgBox canConnect End Sub

  Read the article

• How to force username and password entry in C# / VS web app?

  - by salvationishere

  I am trying to force user to enter username and password when they run my C#/SQL web application. This was developed in VS 2008 on a 32-bit XP. The current connection string I'm using in my web.config file is: But it still doesn't prompt for a username and password. What am I missing?

  Read the article

• Determine if an Index has been used as a hint

  - by Joe Bloggs

  In SQL Server, there is the option to use query hints. eg SELECT c.ContactID FROM Person.Contact c WITH (INDEX(AK_Contact_rowguid)) I am in the process of getting rid of unused indexes and was wondering how I could go about determining if an index was used as a query hint. Does anyone have suggestions on how I could do this? Cheers, Joe

  Read the article

• Removing Database References from an ASP.NET MVC Site

  - by Maxim Z.

  I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance. Can I completely remove this dependency? If so, how do I get rid of all this database stuff?

  Read the article

• Visual Studio Setup Project Installer Prerequisite for SQL Server CE

  - by blu

  I have a Setup Project in my solution in Visual Studio 2008 SP1. The application installs fine but it is not loading my prerequisite of SQL Server CE. I have the following configurations set: Do I need to do anything else, like with a Custom Action or anything like that? Thanks.

  Read the article

• text search with two parameters

  - by stck777

  The user should input two strings and the script will performe a text search: $sql = "SELECT * FROM table_one WHERE name='%$str1%' AND MATCH (street, city, pin) AGAINST ('$hrtg'IN BOOLEAN MODE)"; somehow the % does not work, but it alwas did actually. please help?

  Read the article

• Connecting to MS sql through hibernate

  - by Rima

  Hello All, I want to connect to MS SQl server 2005 using hibernate in java. i am unable to find the jars and the hibernate.cfg.xml file for the same. can someone help me with the same Thanks in Advance Regards, Rima

  Read the article

• Refresh tables in Visual Studio?

  - by Curtis White

  How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express. The clear results does not seem to refresh.

  Read the article

• Conditional SQLite check constraint?

  - by Rezzie

  I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status text NOT NULL, enddate date, /* Checks */ CHECK (status IN ("Current", "Complete")) ); I'd like to add a constraint that requires enddate to be non-null if the status is "Complete". Is this possible? I am using SQLite v3.6.16.

  Read the article

• Reset AutoNumber(Identity Field) in DataBase

  - by hosseinsinohe

  Hi All I Use a Sql Server Compact DataBase File For Store the Data in My Windows Application Software.In this DataBase I have A Table With Identity Field.When I Insert A Record To the Table, identity Code increment Automatically.But When I Delete All Records From Table,And Insert Records Again,Identity Field don't Start From 1. I Want Reset this Value to 1. Please Help Me

  Read the article

• Sql script, create a database

  - by Blanca

  Hi! I have the next file: create_mysql.sql DROP DATABASE IF EXISTS playence_media; CREATE DATABASE playence_media; USE playence_media; GRANT ALL PRIVILEGES ON . TO 'media'@'localhost' IDENTIFIED BY 'media' WITH GRANT OPTION; But I don't know how to create this database. I would like to do it with my terminal, no other graphics interfaces. Thanks

  Read the article

• why restoring database never finishes?

  - by LingAi

  Hi all, I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring. Does anyone know what's the problem? Thanks, Ling

  Read the article

• How to create sql insert query dynamically in mysql

  - by nectar

  I am creating an application where I am generating pins dynamically based on user's input and storing them into mySql database. $sql = "INSERT INTO tblpin ('pinId', 'ownerId', 'usedby', 'status') VALUES for($i=0;$i<$npin;$i++) { ('$pin[$i]','$ownerid', 'Free', '1'); } ;"; how can I do that?

  Read the article

• Should I invest time in learning about OR\M or LINQ?

  - by Peter Smith

  I'm a .NET web developer primarily who occasionally writes console applications to mine data, cleanup tasks, etc. Most of what I do winds up involving a database which I currently design via sql server management studio, using stored procedures, and query analyzer. I also create a lot of web services which are consumed via AJAX applications. Do these technologies really help you in speeding up development times? Do you still have to build the database or object code first?

  Read the article

• Storing JSON in an msSQL database?

  - by JKirchartz

  I'm developing a form generator, and wondering if it would be bad mojo to store JSON in an SQL database? I want to keep my database & tables simple, so I was going to have `pKey, formTitle, formJSON` on a table, and then store {["firstName":{"required":"true","type":"text"},"lastName":{"required":"true","type":"text"}} in formJSON. would this slow down the DB server too much to set live? Any input is appreciated.

  Read the article

• CLR SQL Assembly: Get the Bytestream?!

  - by OMG Ponies

  I have a SQL CLR dll I want to deploy, but have found you can embed the byte stream/varbinary_literal/ varbinary_expression/assembly bits into a text file to get around the messy hassle of packaging a DLL and making sure it's accessible for the CREATE ASSEMBLY command. But what I have yet to find is how to get that byte stream/varbinary_literal/ varbinary_expression/assembly bits value. I haven't found any consistent terminology, and what I keep finding in using Load(). Help?

  Read the article

• Get list of elements and their values from an untyped xml fragment in T-SQL

  - by Kevin

  Similiar to question: http://stackoverflow.com/questions/2266132/how-can-i-get-a-list-of-element-names-from-an-xml-value-in-sql-server How would I also get the values for the list of elements. For example: a1 b1 c1 Would return Element | Value A | a1 B | b1 C | c1

  Read the article

• Access: strange results with queries against MDB file

  - by Craig Johnston

  I am running the following SQL against an MDB file, a copy of which is located here: http://hotfile.com/dl/40641614/2353dfc/test.mdb.html (perfectly clean file, no macros or viruses) SELECT datediff("d", MAX(invoice.date), Now) As Date_Diff , MAX(invoice.date) AS max_invoice_date , customer.number AS customer_number FROM invoice INNER JOIN customer ON invoice.customer_number = customer.number GROUP BY customer.number If the the following was added: HAVING datediff("d", MAX(invoice.date), Now) > 365 would this simply exclude rows with Date_Diff <= 365? What should be the effect of the HAVING clause here?

  Read the article

• Strange UPDATE syntax in MS Access 2003

  - by Sven

  Hi, I've got an Access application with an update query with the following syntax: UPDATE TABLE1, TABLE2 SET TABLE2.VALUE1 = TABLE1.VALUE1, TABLE2.VALUE2 = TABLE1.VALUE2, TABLE2.VALUE3 = TABLE1.VALUE3, TABLE2.VALUE4 = TABLE1.VALUE4 The query is working but I do not understand what's going on here. I'm trying to convert this query to SQL Server. Can somebody please explain what this query does? My guess is that it's a special Access syntax. Thanks, Sven

  Read the article

• [ADO.NET ERRROR]: CREATE DATABASE permission denied in database 'master'. An attempt to attach an au

  - by Mark Cidade

  Anyone seen this before? CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:\Documents and Settings\..\App_Data\HelloWorld.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. I'm asking on a friend's behalf. I've sent him these links: http://blog.benhall.me.uk/2008/03/sql-server-and-vista-create-database.html http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=702726&SiteID=1

  Read the article

• Increase the size of sql compact 3.5 .sdf file using C#

  - by Jankhana

  I'm using Sql Compact3.5 as my DB with C# .NET what is the maximum size of sdf that I can give??? Is there any way to programatically increase the maximum size of the sdf file??? if so how???

  Read the article

• Free DBMS with encryption support and without size limitations

  - by Sphynx

  I really need a free database which supports encryption, but doesn't have size limitations like 4 GB in SQL Server Express. Suggestions welcome!

  Read the article

• Is there any better search method instead of string.Contains("keyword") using asp.net?

  - by Mike108

  For example, the users of our app want to search products by entering a keyword of productName. The Products table of the sql server database contains about 10 million records. Is there any better and higher-performance search method implement instead of productName.Contains("keyword") using asp.net C# ?

  Read the article

• Rename SSRS Subscription GUID's

  - by Registered User

  When you create a job schedule in SSRS 2008, the server creates a SQL Server Agent job with a GUID name. Is there a script that can be run to rename the shared job schedule in the ReportServer database to another name? I would like to do this to make it easier to organize subscriptions in the Job Activity Monitor since I have a very large number of subscriptions mixed in with other jobs on my database server.

  Read the article

< Previous Page | 507 508 509 510 511 512 513 514 515 516 517 518  | Next Page >