Hi

Are you running that query on the same box as SQL is installed? Try it on another box and see if you get the same effect. Have...

Hi,

Yes it is ran in the database where dbo.company is located, but the error message 'object is not found' happens because the database context is switched to master because of...

Hi

Yes it is on the DELETE statement. I always use CREATE TABLE, never use SELECT INTO as there have been historically issues with that syntax. I must...

Hi All,

After some more digging around I have isolated it to the fact when the database was originally created they had mix collations in the table creation scripts (these are...

Better still put the SQL into a stored procedure, which can be encrypted as well. So you can put in a salt value as well. Therefore the external...

Hi

I am afraid foreign keys can only be applied within the same database. If you wish to enforce data integrity across databases then you will have to

write...

Hi,

You cannot specify the OR operator in a CASE statement, but you can do this.

SELECT *

FROM sysinfo

WHERE integrity = CASE WHEN @integrity = 'all classified' THEN 1 ELSE 0...

Hi

Here is a possible answer, I am not saying it is optimal but it will return the last six months for you.

DECLARE @Months TABLE (Date VARCHAR(20))

DECLARE @Count INT

SET @Count...

Hi All,

Sorry for giving out bad advise there. I did some more research in BOL and found out why I did not use WITH LOG option on RAISERROR. ...

Hi

Try chaning the severity to 11. I know that 10 gets convert to 0 internally (see BOL) and the system does not raise any errors for severity 0...

Hi d_gomes2

Using the ISNULL function only would not work in this instance as the nulls are creating because of missing records in the catories table. If it was null...

Hi All,

Quick question the service account you have SQL server running under is a domain account and not local service?

If you check BOL one of the requirements is that it...

Hi

Nice article. From a developer point of view I like the new data types (FILESTREAM, DATE etc), sparse columns and Change Data Tracking feature which are available...

Hi,

It looks like BULK INSERT does not support variable names. Try something like this instead.

declare @db nvarchar(15)

declare @dbo ...

Hi Dugi,

You need SUM instead of COUNT here. The reason is that COUNT returns the number of rows found and the CASE statement will always return 1 row, but...