Search Results

Search found 99652 results on 3987 pages for 'sql server 2005 sp4'.

Page 159/3987 | < Previous Page | 155 156 157 158 159 160 161 162 163 164 165 166  | Next Page >

• DBA - SQL Server 2005 - Backups

  - by subhash.pant

  I am trying to figure out how SQL Server DBAs are doing their backups and verify in 2005. I use the Idera's free stored procs (which is no longer available to download btw) to backup and verify and have gotten around 65% compression. If there any other free alternative? Thanks in advance, -Subhash

  Read the article

• SSIS 2005 - How to check a file to see if a files does not exist

  - by GordyII

  How do you check to see if a file does not exist in SQL Server Integration Services 2005? Is there a native SSIS component which will just do this for you?

  Read the article

• Visual Studio 2005 C++ Application Wants To Run As Admin

  - by workinprogress

  I wrote a simple c++ application in Visual Studio 2005 but when I compile it, the executable wants to run as admin. I tried deleting the manifest but it still wants to run as admin. I am running Windows Vista Home premium. Any help would be appreciated!

  Read the article

• Create a new table and import data from csv file into SQL Server 2005

  - by Madhu Kiran

  Hi, I have several files about 15k each of CSV data I need to import into SQL Server 2005. What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 180 fields in it, this would simplify things.

  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

• Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it fro

  - by Craig Johnston

  Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it from a file? If I don't do this, I get a "User login failed" when trying to access the database using this username from apps.

  Read the article

• How to change this mysql select into sql server select statement?

  - by Pandiya Chendur

  I use this mysql statement for concating description which has a length greater than 30.. select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30), '.....'),description) as description from table How to change this mysql select into sql server select statement?

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• In SQL Server, how to quickly get a general idea of an instance?

  - by Yousui

  Hi guys, If you are a new sql server dba and you just get an account of an instance. What would you do to know the instance and databases? How to quick get a general idea of this instance and databases? Great thanks.

  Read the article

• Visual C++ 2005 and Windows 7 64-bit

  - by Phenom

  Can Visual C++ 2005 be run in Windows 7 64-bit? I tried installing it, and came up with some problems.

  Read the article

• Sql Server xml column with Entity Framework - how to keep insignificant whitespaces

  - by Saravanan

  Sql server 2005 (even 2008) strips the insignificant whitespaces by default. To keep one can use the CONVERT funtction with the last argument as '1' (Ref. Article). How can we do the same thing in Entity Framework? thanks

  Read the article

• Connecting Visual Studio 2005 to Team Foundation Server 2008

  - by Mini

  As of now we are using vs2005. We are newly setting up TFS 2008. How do I connect TFS 2008 client to vs 2005 without upgrading it to vs2008 in my system? When I installed TFS 2008 client the options are appearing in VS2008 but not in vs2005.

  Read the article

• Where does sql server stores the stored proecdure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great thanks.

  Read the article

• Migrated SQL Server database suddenly in "Restoring" state

  - by Pete Montgomery

  I backed up a SQL Server 2005 database and restored it to a new SQL 2008 instance. The restore was quick and successful. Everything was fine for an hour or so. Suddenly, the database is now stuck in "(Restoring...)" state in Management Studio and has a green arrow icon, and my application login is failing! Any advice? :-)

  Read the article

• alternative to sql server 2005

  - by csetzkorn

  Hi, I got used to the xml support and recursive common table expressions of sql server 2005. I am just wondering whether any free dbs like mysql support these requirements nowadays? Thanks. Christian

  Read the article

• In SQL Server, how can I execute a piece of tsql against all databases in an instance?

  - by Yousui

  Hi guys, In SQL Server, how can I execute a piece of tsql against all databases in an instance? Great thanks.

  Read the article

• Filter assemblies/namespaces out of Visual Studio 2005 Documentation index

  - by PunctuallyChallenged

  Is there any way to remove certain assemblies or namespaces from the index of (or entirely from) the Visual Studio 2005 Documentation? System.Web.UI and System.Windows.Forms contain many identical class names and I'd like to eliminate those in System.Web.UI that are irrelevant to me.

  Read the article

• In SQL Server, how can I separate a large number of tsql statement into batches?

  - by Yousui

  Hi guys, In SQL Server, how can I separate a large number of tsql statement into batches? Should I use the GO statement in stored procedures or functions? Should I use the GO statement in explicit transaction management situation(between BEGIN TRANSACTION and ROLLBACK TRANSACTION or COMMIT TRANSACTION)? Are there some best practice about this topic? Great thanks in advance.

  Read the article

• How to take a backup of database of sql server 2005 in VB.net Using Code

  - by Darshan Dodiya

  Hi I want to know how to take a backup of database using programatically in VB.net of SQL Server 2005. if you are having and idea about it then pls send me the code for that.

  Read the article

• Visual Studio 2005- 2008 IDE Editor Tools

  - by GutierrezDev

  Hi everyone. I'm looking for some Vs 2005-2008 Editor Tools like those one in NetBeans or Eclipse that auto insert a close bracket '}' or auto insert a line after an opening bracket '{'. In general a tool that enhance the Editor. I know that resharper does some of the tricks but it is expensive for me.

  Read the article

• How to get total number of hours between two dates in sql server?

  - by Pandiya Chendur

  Consider two dates 2010-03-18 22:30 and 2010-03-19 03:30 .... How to get the number of hours in between the two dates in sql server.....

  Read the article

• windows 2003 server : can't find a primary authoritative dns server for the name srv.domain1.local [

  - by phill

  I originally tried to rejoin a computer to a network which led to a "cannot find domain" error. The username/password box don't even come up. some tests i ran: I can ping the server, however I can't ping the domain name domain1.local. nslookup can't find the domain either. It looks to the isp's dns instead of my own to resolve the local machines. So i go to the dns and run netdiag.exe and gives me this error. DNS test . . . . . . . . . . . . . : Failed [WARNING] Cannot find a primary authoritative DNS server for the name 'stmartinsrv.stmartin.local.'. [RCODE_SERVER_FAILURE] The name 'srv.domain1.local.' may not be registered in DNS. [WARNING] The DNS entries for this DC are not registered correctly on DNS se rver '68.94.156.1'. Please wait for 30 minutes for DNS server replication. [WARNING] The DNS entries for this DC are not registered correctly on DNS se rver '68.94.157.1'. Please wait for 30 minutes for DNS server replication. [FATAL] No DNS servers have the DNS records for this DC registered. Redir and Browser test . . . . . . : Passed List of NetBt transports currently bound to the Redir NetBT_Tcpip_{04BB0F6B-06AE-4D60-80C8-2A7A24C1D87B} The redir is bound to 1 NetBt transport. List of NetBt transports currently bound to the browser NetBT_Tcpip_{04BB0F6B-06AE-4D60-80C8-2A7A24C1D87B} The browser is bound to 1 NetBt transport. from previous postings, I've tried adding the domain suffix to the nic ip properties to both the client machine and the dc server which didn't help. any ideas? thanks in advance

  Read the article

• List all hotfixes applied to windows server

  - by Nick Kavadias

  There used to be a command line tool called QFECheck in Windows Server 2000 that would list them out. Is this the preferred method on windows server 2003/2008? I know they're listed in Add/Remove programs, but it's hard to capture them for an audit this way. Can i do this without having to install an add-on executable?

  Read the article

• What antivirus software is recommended for Windows Server and Small Business Server?

  - by Sanoj

  I wounder what antivirus software is recommended for a Windows Server 2008 or a Small Business Server 2008. I would like to have one that: Is easy to maintain. Has good performance I don't need anyone that is complex and has support for clients. It's a small office with just a few computers.

  Read the article

< Previous Page | 155 156 157 158 159 160 161 162 163 164 165 166  | Next Page >