|
|
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 "Cannot access the specified path or file on the server..." Posted by Michael Weyant at 5/26/2006 10:48:31 AM Hello all,
I am at my wits end here and hoping someone can lend some wisdom to this
sql-noob.
I have SQL 2005 on a Windows Server 2003 cluster:
I am receiving the following error whenever I try to do anything with a DB
(move, copy, backup, even create a new).
"Cannot access the speci...more >>
literature for starting SQL users/ book to use SQL server as a backend for a MS Access frontend? Posted by Philip Leduc at 5/25/2006 5:48:09 PM Does anyone have know a good book for SQL starters 2000/2005 , not too
teoritical with handson examples and sample code.
I am an experienced Access VBA programmer.
Would like to know how make 1) SQL VB.net applications including setting up
the database.
Upgrade Access applications to SQL back...more >>
Help for an Idiot Posted by Some Dude at 5/25/2006 3:44:27 PM I need to dislpay a table from an SQL database on a web page. I know how to
make web pages and I have downloaded SQL Server Express and Vidual Web
Developer Experss but don't know where to start. I just need a very simple
display of a table that allows sorting by clicking on the column heading...more >>
Create Database Posted by Taoge at 5/25/2006 11:12:01 AM Hi, all
When we need a new database , we use the following SQL statement:
Create Database database_name...
In this statement, we can not use a string variable as database_name.
Is there a way to use a string variable as database_name when we create
database?
Thanks
...more >>
creating a direcory by Transact-SQL Posted by Sam at 5/25/2006 8:02:04 AM is there a way for creating a direcory in a given path by Transact-SQL ?
somthing like : MDIR C:\MyFold
...more >>
Will it is possible to set a login in sql server for 10days Posted by csesaravana NO[at]SPAM gmail.com at 5/25/2006 5:05:40 AM Hi ,
I am working as a Database Adim
I am providing support Application projects
Here is my issue,
Can we able to provide access for a login only for 10days
Is there is any other way apart from Windows Authentication ?
Please help me
Thanks in Advance
Saran
...more >>
find out by Transact-SQL the path to a certain db data file Posted by Sam at 5/24/2006 11:43:16 PM how can i find out by Transact-SQL the path to a certain db data file
(mdf)?
...more >>
ODBC connect SQL 2000?? Posted by Danny at 5/24/2006 4:39:47 PM Hi, I just install SBS 2003 with SQL 2000 on my server, but when I try to
use another PC (OS is WinXP) connect the SQL server throgh ODBC, it pop up a
error msg:
connection failed
SQL state '28000'
SQL server Error: 18452
Login fail for user 'XXX', reason : Not associated with a trusted SQ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Download MS SQL Server CLIENT services Posted by excel_hari NO[at]SPAM yahoo.com at 5/24/2006 1:33:03 AM Hi,
We have MS SQL Server installed in a remote serve location. I need to
run some queries on it. One of my colleagues in US uses Client services
version to connect to te server and run queries.
I also want to install the Client services in my computer (Windows XP
Pro). The local IT asked m...more >>
Convertin Text -> Nvarchar Posted by Carlos Albert at 5/23/2006 6:55:52 PM Hello group,
I have to convert some strings that I had on a Text field to Nvarchar. I
don't care if some data gets lost.
I tried this, but doesn't work because it's too long and complains about it:
UPDATE mytable
SET mynVarChar= cast(myInfo as nvarchar(4000))
...more >>
SQL Jobs Posted by Mo at 5/22/2006 9:41:41 PM Do you guyz know what rights are needed to run a SQL job (SQL Server 2000)?
I have a friend that took away SA rights to a user and that user has dbo
access to the database, but can't run the job anymore.
What I think it is, they don want to give full SA rights back to the user.
Any sugge...more >>
Sql weird behavior Posted by csmba at 5/22/2006 6:04:56 PM Hi all. I got the next very simple and strange problem. When running the
following 2 slqs, one runs very fast, and one very slow. I looked at my
indexes time and time again, and cannot figure out why. The table has about
8 million rows.
Very fast:
Select top 1 keyA from tableA where fiel...more >>
Find Utility In SQL Server Management Studio Posted by G. Ray Giacalone at 5/22/2006 10:36:30 AM Is there anything in SQL Server Management Studio that will allow you to
find text within tables, stored procs and views...not the data itself but
within the data definition language? For example, I need to find all of the
database objects that are using link servers.
Thank you very much! ...more >>
Performance issues Posted by Gouri at 5/22/2006 12:00:00 AM One of the company's marketing department wants to measure the value of the
data on potential participants that is purchased from business partners .The
marketing department requires a view of the data that contains all potential
participants to whom surveys were distributed and the names of s...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |