Search results for query: *

can anyone give me the plsql for retrieving data that is for the previous month; what i want is something like this; WHERE data_month = previous month thanks

how can i determine the hard disk location of the transaction logs using tsql? thanks.i use sql server 2000

how can i prevent the refresh of a single full client document published in webi? thanks

there is no log shipping option in my sql server 2000 database maintenance wizard. is there any other way i can achieve log shipping?. thanks

is it possible to create a web service on a unix/linux PC that can be consumed by a .NET Application? If so how can i do this? Thanks

how can i change the authentication mode via query analyzer. right now it is set to windows authentication and i want it to be sql server authentication only. i use sql server 2000 and i could only connect via my windows login. i am an administrator on my PC. Thanks

After building my solution in vs.net 2003, i cannot find the .exe in my project folder. is there another command to create the .exe. i have created a smart client and i want to call run it via a URL but i need to point to the .exe Thanks

i have vs.net 2003 installed on my pc..how can i find out which version of .net i am running on my pc? thanks

i have 26022005 09:34:18 in avarchar field. how can i format this to a date? thanks.. it came from an oracle database.

Is it possible to create a web service to access oracle data on a unix server? If so how can i do this using .NET ?

can anyone suggest how to move data away from a very sensitive sql server 2000? the application runs several transactions and any extra load on it tends to affect its performance. the data is to be moved away for data warehousing purposes...i thought of replication but would that not put extra...

how can i script the changes (in tsql) that i make in EM? For example, if i change the length of a varchar field from 20 to 30, i want to see the tsql for it. I use sql server 2000. thanks

hello alll, i need a script that will write an ip address to text file. can anyone help? thanks.

i am trying to create a default value for the column activevac using the following tsql; ALTER TABLE vacancies alter column activevac nvarchar DEFAULT -1 ---------------------------------------- but i keep on getting the following error; Microsoft OLE DB Provider for ODBC Drivers error...

how can i copy files across the network from one PC to another using TSQL? Thanks

i have a server called ACD10122843Z. on it i have 2 databases db1 and db2. i want to import data from db1 into db2 how can i do this? thanks

is there a success code after sp_attach? or is there any way i can know if the attach was successful.. thanks

i want to attach a db and only when that is successful, will i pull data from an oracle linked server into the newly attrached db.. my question is how can i query the state of the db before i pull data from oracle? what i want to do is ONLY pull data if the attach was successful.. if the attach...

how can i quickly clone a table? thanks

i want to perform a particular action on a file if it is empty (filesize is 0kb) from a stored procedure.. how can i do this? thanks