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.
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?
I'm running an application from supervisord and I have to set up an environment for it. There are about 30 environment variables that need to be set. I've tried putting all on one big
environment=
line and that doesn't seem to work. I've also tried multiple enviroment= lines, and that doesn't seem to work either. I've also tried both with and without ' around the env value.
What's the best way to set up my environment such that it remains intact under supervisord control? Should I be calling my actual program (tornado, fwiw) from a shell script with the environment preloaded there? Ideally, I'd like to put all of the enviroment variables into an include file and load them with supervisor, but I'm open to doing it another way.
Currently I have this:
function parse_string($string, $variables){
extract($variables);
return eval('return "'. addcslashes($string, '"') .'";');
}
So I can input this string:
'Hi {$name}, my name is {$own_name}'
Together with this array:
array('name' => 'John', 'own_name' => 'Tom')
And get this back:
'Hi John, my name is Tom'
I've never liked this eval() approach but it works and it's fast (faster than regex at least).
Question: Is there a more elegant way to do this (faster than using regex) in PHP5?
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 ?
I'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically?
the error i keep receiving in the app is:
An error has occurred while
establishing a connection to the
server. When connecting to SQL Server
2005, this failure may be caused by
the fact that under the default
settings SQL Server does not allow
remote connections. (provider: Named
Pipes Provider, error: 40 – Could not
open a connection to SQL Server)
however I can connect to it when I create a system dsn to the sql server instance and through VS2005's Tools Connect to Database.
Here is the code I'm using to connect:
dim strC as string
strC = "data source=bob; database=subscribers; user id=bobuser; password=passme"
dim connection as New SqlClient.SqlConnection(strC)
try
connection.open()
catch ex as Exception
msgbox(ex.message)
end try
connection.Close()
I have half a million records in a data set of which 50,000 are updated. Now I need to commit the updated records back to the SQL Server 2005 Database.
What is the best and efficient way to do this considering the fact that such updates could be frequent (though concurrency is not an issue but performance is)
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 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.
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 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?
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.
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.
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.
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
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.)
I am trying to pass some JavaScript variables that I have assigned to form variables into a query string used by a jQuery plug in called fancybox. If I hard code in the string that I want lightbox works great, however I need it to pass some form values in there to make it work as desire.
<script type="text/javascript">
$(document).ready(function(){
var item = document.itemFinder.item;
var zip = document.itemFinder.zip;
var radius = document.itemFinder.radius;
var dataString = "item=" + item + "&zip=" + zip + "&radius=" + radius;
$("#various3").fancybox({
ajax : { type : "POST", data : dataString},
'scrolling' : 'auto',
'overlayOpacity' : '0'
}
);
});
</script>
What am I doing wrong?
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
I am trying to capture some magento success page variables to pass to our advertising company.
So far I have got this but the variables are not outputting anything:
<?php
$items = $order->getItemsCollection();
foreach ($items as $item)
{
$price="'".$item->getPrice()."', ";
$qty="'".$item->getQty()."', ";
$sku="'".$item->getSku()."', ";
}
?>
The data needs to be in the format:
'price1', 'price2', 'price3'
'qty1', 'qty2', 'qty3'
'sku1', 'sku2', 'sku3'
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.