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.
When using arabic language, data is stored in database with ? (question mark) sign instead of real arabic characters in SQL server. Suggest me solution if anybody have idea.
Is there any sort of non-SQL API for talking to SQL Server? I'm curious if there is a more direct way to retrieve table or view data.
(I don't have a problem with SQL, just curious if any of the layer between the SQL parser and the underlying data store is exposed.)
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.
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?
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.
I make a application, which has to interfaces. one is desktop and other is web application. both have their own databases (which are same is structure).
I want to sync the database from desktop to remote server and also from remote server to desktop but i have no idea that how it does.
I use the MYSql database. and my desktop application is in .NET
NOTE: There are more than one destop systems who update their databases and also sync databases.
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.
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,
I need to extract data from my SQL Server database into multiple text files.
I have a table with 4 columns: UserID, UserName, Tag, Score.
I need to create a text file for each Tag (so basically I need to group by Tag and order by score).
Before to start I would like to know what's the fastest way to create several text files:
File titles = TAG field
each line = userID
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
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
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?
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
Hello,
We have an .NET client app working against SQL Server 2005 (clustered), do I need to do something special in the client app to make it cluster aware?
Thanks.
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.
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 :)
Hi
Is there any way to massively alter primary keys(uid) to all tables with no primary primary keys in sql server database ? I have a lot of tables and most of them don not have primary keys.
Thanks in advance.
Hi,
I have a database (SQL server express 2008) which has a column that is defined as text. When we try to store some text which is in chinese, it is not saved. I read that the field should be ntext. I will now have to a conversion to my table to create the column as ntext.
Would I have to do anything with the collation of the database which is set to Latin?
JD
Question: The new SQL Server 2008 database returns me values formatted English (date/float).
Is there a way I can set the return format ?
For example temporarely switching the database language?
Or just set the language for the current query ?
I need a way to make my database mdf file secure from any adminstrators in SQL Server Express. Because I am developing application with C# connected to SQL Express database.
I've got two database servers,
(1) production
(2) test
on the production database I get frequent deadlocks and I'm trying to find out what is causing it.
I take a backup of the database in production and restore it in test and when I perform the exact same scenario that yields deadlocks on the production server I am unable to reproduce in test.
any ideas/tips/hints would be much appreciated.