Search Results

Search found 88553 results on 3543 pages for 'hp mediasmart server'.

Page 324/3543 | < Previous Page | 320 321 322 323 324 325 326 327 328 329 330 331  | Next Page >

• SQL Server Query Question

  - by Lp1

  Running SQL Server 2008, and I am definitely a new SQL user. I have a table that has 4 columns: EmpNum, User, Action, Updatetime A user logs into, and out of a system, it is registered in the database. For example, if user1 logs into the system, then out 5 minutes later, a simple query (select * from update) would look like: EmpNum User Action Updatetime 1 User1 I 2010-01-01 23:00:00:000 1 User1 O 2010-01-01 23:05:00:000 I'm trying to query the Empnum, User, Action, I(in time), O(out time), and the total time.

  Read the article

• Create table on linked server?

  - by vatsalit

  Is it possible to create table on linked server? If yes then how? I really appreciate your help. Thank You.

  Read the article

• SQL Client for Mac OS X that works with MS SQL Server

  - by Patrick McElhaney

  What's a good SQL client for Mac OS X that works with MS SQL Server? I don't really need a GUI, but it's nice to have for the color coding and resultset grid.

  Read the article

• How to get numeric random uniqueid in MS sql server

  - by Rajesh Rolen- DotNet Developer

  i am using sql server 2005, please tell me how can i get 6 digits (unique numeric which should be random) value for every row in table. i have a field in table in which i needs 6 digit numeric value (random and unique). please help me to do this.

  Read the article

• The server response was: mail server permanently rejected message (#5.3.0)

  - by kredok32

  Hello , I send email on GoDaddy site ( from my .NET application): mail.From = new MailAddress("[email protected]"); mail.To.Add(emailadmin); mail.Subject = "Subj"; mail.IsBodyHtml = true; mail.Body = Body; ... smtp.Host = "relay-hosting.secureserver.net"; smtp.Port = 25; smtp.EnableSsl = false; smtp.Send(mail); but I have received the error : The server response was: mail server permanently rejected message (#5.3.0) else I have tried this code : smtp.Host = "relay-hosting.secureserver.net"; smtp.Credentials = new NetworkCredential("[email protected]", "password"); smtp.Port = 25; smtp.EnableSsl = false; but get same error. Please advice.

  Read the article

• Imported system.web, I don't see server.mapPath?

  - by Blankman

  I imported system.web into my class lib project. Trying to find: system.web.httpserverutility.server.mappath But I dont' get the method in intellisense? It is a .net 2.0 build.

  Read the article

• How do I create a table in SQLite using the VS2008 Server Explorer

  - by fishhead

  Hello, I would like to create a table in a SQLite database using the Server Explorer in VS2008. I am able to do other operations on the database but when it comes to creating a table using the query builder I get Not Supported messages. is there another way other than writing code just for the sole purpose of creating the table? CREATE TABLE myTable ( ID INTEGER PRIMARY KEY AUTOINCREMENT, Name VARCHAR(100) ) .NET Framework Data Provider for SQLite 3.6.16

  Read the article

• SQL Server Index Naming Conventions

  - by Eric Ness

  Is there some standard way to name indexes for SQL Server? It seems that the primary key index is named PK_ and non-clustered indexes typically start with IX_. Are there any naming conventions beyond that for unique indexes?

  Read the article

• Java Servlet connecting to SQL Server tutorial?

  - by phill

  Can anyone recommend a tutorial on how to write a Java Servlet which connects to MS SQL server and manages data? I'm trying to write something which pulls products out of one database and inserts them into a stored procedure located on another database. Thanks in advance.

  Read the article

• Sql server messed up degree symbol

  - by user228058

  Some of the degree sysmbols in my sql server database are displaying like this: 173-¦F. When I do a search for that - SELECT * FROM PRoduct WHERE description LIKE '%-¦%', it does not bring them up. How can I find (and replace) such characters?

  Read the article

• SQL Server 2005: Invalid object name exception

  - by Craig Johnston

  In VS2005, I am using a DLL which accesses a SQL Server. The DLL returns a SQLException Invalid object name 'tableXYZ' but tableXYZ is a table in the database. Should it be looking for dbo.tableXYZ instead? Is this a permissions issue with the login being used?

  Read the article

• SQL Server - Test the result of a stored procedure

  - by Melursus

  In SQL Server, it is possible to test the result of a stored procedure to know if the result return rows or nothing ? Example : EXEC _sp_MySp 1, 2, 3 IF @@ROWCOUNT = 0 BEGIN PRINT('Empty') END ELSE BEGIN PRINT(@@ROWCOUNT) END But @@ROWCOUNT always return 0 so maybe is there another way of doing this ?

  Read the article

• Remote running program from server

  - by Armen Khachatryan

  Hello, I have Windows serrver 2008 and more computers in it domain. all i need is to run program from server in all comps , for example install kaspersky for all comps. can i do it? thanks

  Read the article

• Sample Employee SQL Server database with data

  - by Tom

  Hi I need some sample SQL Server Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample. Can any body help ?

  Read the article

• Windows server Task Scheduler, close after?

  - by Probocop

  I have a scheduled task on my server which runs a PHP script every minute. In the 'Run' part of the scheduled task I have the following: "C:\Program Files\Internet Explorer\iexplore.exe" "http://www.example.co.uk/script.php" So when it runs it opens Internet Explorer and browses to that URL. Is it possible to get it to close Internet Explorer after running the script?

  Read the article

• Sql-server Database query help

  - by menacheb

  Hi, I have a project in C# with a Sql-server Database. In that database I have a table named 'Process' and columns named 'process_name', 'Full_Name' and 'Version' (all of the type:nvarchar(50)). I want to write a query wich will add the new process, only if it doesn't exist in the table yet. How can I do that? Many thanks,

  Read the article

• SQL Server Compact Edition - Create Database Tables

  - by Lennie De Villiers

  Hi, I got it right to create a SQL Server CE database table using the code below: string connectionString = "DataSource=\"test.sdf\"; Password=\"mypassword\""; SqlCeEngine en = new SqlCeEngine(connectionString); en.CreateDatabase(); But how do I create my database tables and insert data? I've got the SQL created statements stored in the application Resource location.

  Read the article

• Find out the calling stored procedure in SQL Server

  - by Craig HB

  Is it possible to find out who called a store procedure. So if you get an error in proc3, I know if it was called by proc1 or proc2. I'm using SQL Server 2005.

  Read the article

• SQLInForm.com like plug-in for SQL Server 2008

  - by Vishal Seth

  Is there a plug-in like the java applet @ SQLinForm.com for MS SQL Server Management Studio 2008? I tried SSMS tools based on someone's answer to my previous question but I don't find any functionality to format (beautify/tabify) SQL. If somebody could please point out that in SSMS tools or suggest some other tool (preferably free) Thanks :)

  Read the article

• ports to pass from firewall in windows 2003 server

  - by air

  is this OK to on the firewall on windows 2003 Domain & DHCP server? if yes then which ports should be passed from firewall to use full feature of Active directory domain controller file & Printer Sharing DHCP & Dns thanks

  Read the article

• 32bit to 64bit sql server 2008 database conversion

  - by Eric

  We are in the process of moving databases from older 32 bit hardware running sql 2005 to newer hardware with sql 2008 64 bit. My question is if the database is automatically converted to 64bit after it is reattached on the new server or if it is running in 32bit mode on a 64bit instance. Is there a way to tell?

  Read the article

• Build server polling vs. event-driven builds

  - by Daniel T.

  Why do build servers poll for changes instead of SVN firing off an event (or a post-commit step) that tells the build server to start a build? It seems terribly inefficient to poll for changes, especially when the number of projects increases and the polling period is set to a very low value (for example, 30 seconds).

  Read the article

• ERP system written in SQL Server, Trigger job not running

  - by user333809

  We are a manufacturing plant that runs off an ERP system written in SQL Server. I have never worked with SQL and therefore do not know the language. What I do know is that a trigger job that was running and updating data for us, is now NO longer running. Is anyone familiar enough to answer any questions about this for me??? Any help would certainly be appreciated! Thanks, Jana

  Read the article

• How to use split in SQL Server 2005?

  - by meenakshi

  Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in SQL Server 2005.

  Read the article

• is there any different in Connection string between SQL server Authentication and Windows Authentic

  - by Gold

  hi is there any different in Connection string between SQL server Authentication and Windows Authentication if yes, can i get a sample connection string for this ? thank's in advance

  Read the article

< Previous Page | 320 321 322 323 324 325 326 327 328 329 330 331  | Next Page >