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.
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?
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?
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
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.
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 ?
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
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 ?
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,
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.
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?
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 :)
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?
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.
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
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
I do have a BKS file which contains 15GB+ size. How do I extract the data and run queries on this? I was told that this is SQL Server data. Should I try to upload this to SQL Azure? Any ideas.
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).
Hi,
Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server.
thanks in advance.
Does any one know of an example on how to store an image in a SQL Server CE database?
What data type should the column be? (I am guessing binary.)
I use Linq-To-Datasets. Is it possible using that to put the image into the database and pull it out again later?
Thanks for any advice.
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
Which of the following three options would you choose for a column name in a SQL Server table, and why?
YearToDateWages
YTDWages
YtdWages
Follow up:
SSN
Ssn
SocialSecurityNumber
We have developers some developers who are developing against a SQL Server 2005 database, while others are using 2008.
We just discovered that generating the edmx against a 2008 database set the ProviderManifestToken to 2008, which means some queries won't work against a 2005 database.
While this is a known issue, is there any way to set this value at run time, based on a config file?