Search Results

Search found 134806 results on 5393 pages for 'file server'.

Page 100/5393 | < Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >

• SQL query in SQL SERVER 2005 - Comparing Dates

  - by YeomansLeo

  I'm having a hard time doing this query. I want to compare dates in my query, dates from my DB are in this format: (MM/DD/YYYY HH:MM:SS AM) I want to compare this date with tomorrow's day, today plus one. My questions are: How do I declare tomorrow's date in sql server? How would you compare these two dates? Thank you!! =D EDIT : DATES in DB are…

  Read the article

• How to create File with the FILE_ATTRIBUTE_TEMPORARY in C#?

  - by Ole Jak

  How to create File with the FILE_ATTRIBUTE_TEMPORARY in C#? (So to store Data in Ram but be able to use it as normal file)

  Read the article

• .tex file remains in use by process when batch file is triggered by .Rnw Sweave processing.

  - by drknexus

  This is a pretty specialized question. I'm using the Eclipse IDE in a Windows XP environment with the StatET plug-in so I can write R code as an R/Sweave document. This produces a .tex file that is then post processed by pdflatex.exe. When I create the file as normal everything works great (except maybe my file named russfnc2.Rnw seems to result…

  Read the article

• How can I install SQL Server 2005 on Windows 2008 R2?

  - by Jim Geurts

  Is it possible to install SQL Server Express 2005 SP3 on Windows 2008 Server R2? If so, is there anything special that needs to be done to get it to install properly? I ran into some issues with the installer and wasn't sure if it could be installed with 2008 R2.

  Read the article

• Windows 2003 Storage Server Hanging on Large File Transfers

  - by user25272

  In one of our offices we have a Dell PowerVault 745N NAS device which acts as the main file server. Its running 32bit Windows 2003 Storage Server SP2 with 3GB RAM. The server holds around 60 users HOME folders, which are mapped via AD. The office clients are a mix of XP SP3, Vista and Windows 7. Occasionally the server will completely hang…

  Read the article

• Export a data table in CSV format sql server 2008

  - by manivineet

  I need to create a stored procedure which queries a table and creates a CSV file for that data in a specified directory location. how do i do it?

  Read the article

• SQL Server 2005 red herring error "The user does not have permission to perform this action"

  - by Sylvia

  We're getting the error "The user does not have permission to perform this action" during times of heavy load (regularly, when a trim job occurs). The error clears up when the service accessing sql server is restarted, so it's obviously not a real permissions problems. What kind of situations could cause an error like this, when it's not…

  Read the article

• What are the things to look out for when adding other domain user to your IIS?

  - by Jack

  I have a Windows Server 2008 R2 called Jack11 that joined a domain called Watson.org. It has IIS 7 installed. From my understanding, we need to add the following into the web.config file <system.web> <identity impersonate="true" /> </system.web> Also, we need to ensure that the server Jack11 can ping to the domain…

  Read the article

• Meaning of Primary Key to Microsoft SQL Server 2008

  - by usr

  What meaning does the concept of a primary key have to the database engine of SQL Server? I don't mean the clustered/nonclustered index created on the "ID" column, i mean the constraint object "primary key". Does it matter if it exists or not? Alternatives: alter table add primary key clustered alter table create clustered index Does…

  Read the article

• Do Instances Share Same Services? - SQL Server

  - by peace

  Lets say i installed two named SQL Server 2008 instances e.g. A and B, will i have two services of each type e.g. two analysis service, two reporting service and so on, one service for A and the other for B? If yes, then it is known a service listens on a port number, how two same services going to listen on the port? I hope this is…

  Read the article

• How to configure an isa server to allow a OPENvpn client to connect to an outside server?

  - by rmarimon

  I'm trying to configure an ISA server (not really my area of expertise) to allow an openvpn client (in the lan) access to an outside openvpn server (in the wan). The openvpn configuration I'm using has worked everywhere. In fact if I take the client outside the lan where the isa server is located, it works perfectly. Inside the…

  Read the article

• Other language string in SQL Server 2005

  - by balachandar

  I am trying you insert some string which is not in English (other language). when i fetch back they are not correct. They comes like "?????". But at the same time when I enter the string through the SQL Server UI (SSMS) to enter the string, it works OK. What could be the solution please?

  Read the article

• SQL Server Transactions how can I commit my transaction

  - by codingguy3000

  I have SQL Server 2005 stored procedure. Someone one is calling my stored procedure within a transaction. In my stored proc I'm logging some information (insert into a table). When the higher level transaction rolls back it removes my insert. Is there anyway I can commit my insert and prevent the higher level rollback from…

  Read the article

• How to find column names for all tables in all databases in SQL Server

  - by Salman A

  I want to find all column names in all tables in all databases. Is there a query that can do that for me? The database is Microsoft SQL Server 2000.

  Read the article

• How to define ENUM in SQL Server 2005?

  - by KuldipMCA

  Is there any way to define ENUM in SQL Server 2005? I have fixed values which I need to use in procedures and functions.

  Read the article

• Windows File Access Denied

  - by Tom

  I seem to have a general problem with "access denied on Windows". It manifests itself every time if e.g: My bat file calls a compiler creates a file on disk My bat file renames a file But I also have files downloaded (FireFox) to Windows desktop where Windows is giving me "access denied" if I try delete the file. Tried…

  Read the article

• No write access on Windows 2008 workgroup share

  - by Serge - appTranslator

  Hi All, I'm trying to access network shares on my new Windows 2008 server (workgroup) using my server's local admin account. I can read files but not modify them. Permissions (sharing + file system) say: Users = Read only. Admins = Full Control. Even though I connect using my admin account (net use x: \\server\share…

  Read the article

• SQL Server 2008 Express Grant User Permission

  - by Brett

  What is the appropriate SQL commands (not through the GUI) to add a windows user account to permissions on a SQL Server 2008 Database? ie.. I want to give someone read access and another person read/write..

  Read the article

• Where does a Server trigger save in SQL Server?

  - by Mostafa

  A couple of days ago , I was practicing and I wrote some triggers like these : create trigger trg_preventionDrop on all server for drop_database as print 'Can not Drop Database' rollback tran go create trigger trg_preventDeleteTable on database for drop_table as print 'you can not delete any table' rollback…

  Read the article

• Rollback SQL Server 2012 Sequence

  - by VAAA

  I have a SQL Server 2012 Sequence object: /****** Create Sequence Object ******/ CREATE SEQUENCE TestSeq START WITH 1 INCREMENT BY 1; I have a SP that runs some queries inside a transaction: BEGIN TRAN SELECT NEXT VALUE FOR dbo.TestSeq <here all the query update code......> ROLLBACK TRAN If the…

  Read the article

• Multiple SQL Server Integration Services (SSIS) database instances on one machine

  - by kumar

  Hi, i want to configured the configuration file to use more than one MSDB database, which are stored in separated database instances in Stored packages of SSIS database. if any body knows let me know ? write in steps how to do..? Regards. kumar

  Read the article

• Get Asp.Net username from SQL Server 2008?

  - by jlnorsworthy

  With windows and sql server accounts, I can access the logged in user with functions like: user_name() or suser_sname(). Can I access the user that is logged into asp.net in the same way?

  Read the article

• Forward RDP Connection from Server to Client

  - by Theveloper

  What I'm trying to achieve is in the following infrastructure: Server A running ADDS, DNS, DHCP, NPS LAN -Computer Client I -Computer Client II Server A NIC 1 goes to LAN Server A NIC 2 goes to Internet Server A provides DHCP and Internet access for Computer Clients How do I connect to Computer Client I…

  Read the article

• sql server - select top and bottom rows

  - by Adrian Faciu

  Hi, I'm using Sql Server 2005 and i'm trying to achieve something like: In the same select statement i want to get the first x rows and the last x rows. SELECT TOP(5) BOTTOM(5) Of course 'bottom' does not exist so i need other solution. I believe there is an easy and elegant solution that i'm not…

  Read the article

• distributed transaction between two MS SQL Server 2005

  - by Lukas Šalkauskas

  I need to make DISTRIBUTED TRANSACTION between two MS SQL Server 2005, it drops an error that NO ACTIVE TRANSACTION IS PRESENT or smth like this. DTCTESTER programs drops an error that transaction could not be done. btw 135 port is open on the firewall. Maybe anyone knows what a problem, or have a…

  Read the article

< Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >