Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Logging users in Terminal Services
If using Citrix..you could purchase the RMS product. But for a quick easy home-grown solution. One, obtain a shareware program named sleep.exe and now.exe Then write a batch file with the following: :Begin now.exe >> c:\temp\logins.txt quser >> c:\temp\logins.txt sleep 60 goto begin...- skertz
- Post #2
- Forum: Microsoft: Windows servers
-
using a variable for a table_name in select
Thanks Chris!! You got me going down the right path. The EXEC works, but you must enclose it in () like the following. exec ('select * from' + @my_var) THANKS AGAIN!!!- skertz
- Post #3
- Forum: Microsoft SQL Server: Programming
-
using a variable for a table_name in select
It is possible to declare a variable, set it and then use it in a select statement like e.g: declare @my_var varchar(31), @db varchar(31) set @db = 'TEST' set @my_var = @db + '..sysobjects' select * from @my_var I'm looking to query other database tables from inside a procedure.- skertz
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
