Viewing 15 posts - 5,221 through 5,235 (of 6,400 total)
what is the goal?
to have 63 different copies of the MDF file on the archive server?
to have 63 different copies of a backup of the database on the archive server?
to...
April 30, 2012 at 8:31 am
way 1
SELECT
Ref
,MAX(TransactionDate) AS [Transaction Date]
FROM
Transactions
JOIN
BFlights
ON
BFlights.TransactionID = Transactions.TransactionID
WHERE
(Ref = '129577')
GROUP BY
Ref
way2
SELECT
Ref
,MAX(TransactionDate) AS [Transaction Date]
FROM ...
April 30, 2012 at 6:51 am
where does the column TransactionDate come from, its not in any of the two tables?
is there more at play here than the snippit you provided?
April 30, 2012 at 6:38 am
can you please post the create table statements for each table, will hopefully help us understand a bit more to whats going on
also are BFlights and Transactions in the same...
April 30, 2012 at 6:06 am
what is the error message and error details?
eg
error 18456, serverity 14, state 11
failed to login due to a problem
April 30, 2012 at 6:01 am
capn.hector (4/27/2012)
SQLRNNR (4/27/2012)
EL Jerry (4/27/2012)
Lynn Pettis (4/26/2012)
Freedom!Wallace?
Gromit
tie down
kangaroo
April 30, 2012 at 5:54 am
you granting them as an administrator on the server for RDP access? if so you are also giving them SA access as BULTIN\Administrators in SQL 2005 is a system...
April 30, 2012 at 5:43 am
yes SQLCMD does allow Windows Authentication, are you using the -E switch to force a trusted connection?
can you login to the server using SSMS to the same server ok?
April 30, 2012 at 5:18 am
Qutip (4/30/2012)
The multi-part identifier "BFlights.TransactionID" could not be bound.
I'm getting the above error on the...
April 30, 2012 at 5:12 am
it seems that this is one of the things in 2005 you cannot create a DDL trigger for.
take a look at this topic, it details using extended events and service...
April 30, 2012 at 5:10 am
as long as you are restoring the backup to a server where litespeed is installed then yes, other wise you will need to use the extractor tool then use the...
April 30, 2012 at 4:26 am
if you dont want people to see things your going to have to start changing the security settings on the objects instead of just hiding the things you dont want...
April 30, 2012 at 3:04 am
no that is correct, you can only hide objects in tile view
April 30, 2012 at 2:59 am
dont know if you could do something fancy in dns, where if they go to
http://servername/reports it forces them to http://servername/reports/pages/folder.aspx?ViewMode=Detail
otherwise you could use something like group policy to push...
April 30, 2012 at 2:54 am
following on from this, we had our quarterly maintenance window this weekend and made this change.
so far so good, no deadlocks have been reported so far.
April 30, 2012 at 2:49 am
Viewing 15 posts - 5,221 through 5,235 (of 6,400 total)