Hi,
In SQL Server 2000 ( or above), is there a way to find out users last login date and time? Which system table keeps the record of users last login?
Thanks for your help.
Regards,
K...
I have a clustered SQL Server 2005 configuration. SP2 is installe3d and i've just applied the KB934458 patch.
I am trying to create a maintenance plan and when I get to the end of the wizar...
I have to dynamically build a table name based on the current date and load data from it. However, before doing so, I want to make sure the table exists, but be able to control program flow in...
I have a report that I am writing in SSRS and I need to declare a global variable so that I can set a value from a sub group and use that value in it's parent group.
Here is what I have:
...
Hey guys,
Doing something that I've done thousands of times...importing a simple text file. However...I keep getting a bomb out in the process...please see the error message below.
Erro...
I'm getting almost 100% consistently from my sql server with sp4 standar edition n task mgr pointing me to sqlserver.exe ok from the sysprocesses how do I know which process is using more cpu ...
I want to add Joomla to my server. We are on SBS so it has our SQL server and webserver and everything. I wanted to know if I had to use mysql or if I could just use MSSQL. I can't find a d...
error code 8007000E
We were trying to load data into a new Financial datamart being developed using DTS and we hit the error code 8007000E.
Basically, this error says Not enough stora...
In Sproc how is best to determine if an Id exists in a datatable in SQL database and return true/false?
I have a sql job (which uses Idera SQLSafe to backup our databases) with 60 steps. Each step is a CmdExec command like the following example:
"C:\Program Files\Idera\SQLsafe\SQLsafeCmd" Ba...
I need to create a trigger on insert or after insert that will allow me to check to see if a record already exists in a table in the database. This will prevent us from inserting duplicate re...
Good morning experts,
I have a problem that has been driving me nuts for 2 days. I figure it's time to ask for help.
This is my sql insert string in a vb.net app
SQLFString = "Insert ...
Hi, I have a temporary table in sql server 2000. Sample data:
Course Email
20082.CIS.2010.01N someemail@hotmail.com
20082.MATH.2030.01N per...
Hello,
I have just migrated a server with SQL to a new machine, and I've noticed that a job that used to completed successfully is now returning an error: "Msg 446, Sev 16: Cannot resolve ...
First let me quickly say that after years of knowing about experts exchange i have finally decided to purchase support, my first question was answered in 20 minutes. This next issue has been ...
Is there any way we can disable a ms sql user from doing selects (or any interaction) on the sysobjects table?
Thanks
~B
I renamed my laptop which has a copy of SQL Server 2005 running on it. When I rebooted after renaming the machine I tried running an app which uses the ODBC connection to the SQL Server databa...
Hi
I would like to write on a table called ctcontract, this table contains all of our contract infomation. The table conatins a start date and an end date of all contracts and also the numb...
I want to know how to read MS SQL .ldf file,
I want to get the user, time, sql statment executed and any more details.
I know that there is a lot of 3rd party tools doing so, but i need ...
My database contains patient data. The table structure is like this:
Episode_ID StartDate EndDate
-------------------------------------------
1 Jan 1, 08 ...
When I create the stored procedure below, then run it by supplying the 2 parameters, I get the following Errors:
Msg 2812, Level 16, State 62, Procedure CEM_BulkOpsInsert, Line 15
Could not...
I have the following query - which produces 3 columns, one valid value in each col and the others with a NULL value - would like to collapse all of the rows into a single row:
Trying to use LIKE in the CASE statement but not working for some reason (won't execute). Any tricks to using LIKE within a CASE expression?
Hi i have a stored procddue please see attched
to execute the procedure i need to use
execute empcount 'Dec 1 2007', 'dec 31 2008'
the problem is the application that send the execut...
i have an important database that was hosted from a server in a datacenter, we were having problems with the machine so sql on it was backup up and it was reformatted. When we got it back onli...
