If you want to use Windows authentication with SQLCMD you can use the -E switch. This sets the security to 'integrated mode' and uses the current Windows account. You need...

With your CREATE LOGIN statement a SQL account is created.

If you can login as administrator but you can't login as 'sa' then it looks like the authentication mode of the...

Instead of selecting the specific counts by a sub-select you could also accomplish this by using the CASE statement. This will give better performance because it will be calculated within...

The code you have posted is working correct.

Are you able to login with the credentials using Manamgement Studio?

Does the SQL Error logging contain more information regarding these login failures? Please...

Take a look at the article by Paul White about APPLY. Half way the article he builds a function from an excisting query. You'll also get other interesting information about...

If you run your query from your post (today 12:15:40) on the database you attached, it will return the desired result. In the post in which you attached the database...

select suser_name()

Thanks for providing the table definitions. We'd be better off with correct SQL statement, but it's a start. Besides the DDL we also need the data itself (posted as INSERT...

There is a space in the folder path 'J:\MSSQL10_50.SLQnombert\MSSQL\Backup\Full_Backup\Nombertprod ombertprod_backup_2013_09_02_094915_1589136.bak'

Perhaps you need extra quotes arount the path/filename?

If you provide full sample data (all columns included and multiple rows that cover all situations) we can help you locate the problem.

Like Lynn Pettis allready pointed out: the additional...

You don't really learn anything from reading through the dumps.

Look on the internet for exam testing questions. Answer them and read BOL/articles/forums about the subjects you answered wrong.

Give this a try (included code to create sample data):

create table #TableTools (id int identity(1,1), name varchar(15), tools varchar(15))

insert into #TableTools values

('mike', 'walker')

,('mike', 'cane')

,('steve', 'walker')

,('mitchel', 'cane')

,('dave', 'cane')

,('mitchel', 'none')

-- actual query

SELECT...

Hi,

It will be easier to read if you also put the error message in the post itself (instead of only as subject). From the error message it seems like you...

There are better ways if all you need is the total record count of a table. Instead of returning all the data you could return just the number of rows...

dokledon (8/29/2013)

If you want to connect without using the instancename, you need to connect using the IP-address (or servername) and portnumber. The ip-address/servername is NOT from the hostserver/cluster, but from...