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 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
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
i wrote the following but the file gets created but no ip address is written to it..
any suggestions??
thanks
-----------------------------------
set fil = wscript.CreateObject("scripting.filesystemobject")
set txt = fil.opentextfile("c:\xxx\ip_address.txt", 8, true)
txt...
i want to simply write the ip address of my computer to a hardcode text file (already existing on my PC) on my computer when i click a .vbs file located somewhere on my PC.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.