cschlieve (7/8/2013)

---

So here is my problem. We have a development Database that has tables that are in the middle of some long term changes that won't be done for...

Jason both your suspicions are correct:

1 you cannot backup a database that is set offline;

you simply get this error:

Msg 942, Level 14, State 4, Line 2

Database 'MyDatabase'...

Rakesh.Chaudhary (7/8/2013)

---

I am returing data into TableVariables using Cursors .So I am having data for Each date of month .

I want this data to be exported to existing EXCEL and...

sharonsql2013 (7/5/2013)

---

Hi

I declared the primary key as identity int.

Now everytime a value(code) is selected from the grid , I want a corresponding character to be concatenated to the primary...

i don't see in what you posted where you granted ABCD\svcaccount permissions in msdb to the procedure sp_start_job; you might have glossed over it, but did you do something like...

you missed Sean's snippet where you have to use a DAC(Dedicated Admin Connection) in order to see the statsblob; if you do that, the dmv sys.sysobvalues would be accessible.

select POWER(convert(bigint,2),31) as val into #temp

he was referencing another thread, where someone asked for the max size of a varchar(max);

that thread is here:

http://www.sqlservercentral.com/Forums/Topic1470699-391-1.aspx

i reused my same code example...

it's not the url itself, it's the target attribute of the a href tag that determines wether it replaces the current palce, or opens a named window or a new...

haha! cannot put anything past you! at least i didn't...

what you can do, however, is create the same trace as the default trace, and modify it from there.

an additional caveat: As far as I know,

a user created trace...

masoudk1990 (7/5/2013)

---

Ive noticed dudes in this forum uses # for the first letter of their table names.

Does it have any special meaning?

Does SQL Server have different behavior with them?

Or its...

the limit's found in BOL, but its basically

select POWER(convert(bigint,2),31) -1

so a Varchar(max) stores a maximum of 2 147 483 647 characters.

yep, i'm confirming the same thing you are seeing,

i cannot map a domain group to a remote login, even if i know it exists as a login on the server.

i...

you also have to check for empty strings when converting to decimal as well

SELECT * FROM tbl WHERE ltrim(rtrim(col)) NOT LIKE '%[^0-9]%' OR ltrim(rtrim(col))=''

empty string converts to zero for...

because this seems a lot like homework, i only offered a partial SQL to help you think about the issue;

this doesn't pass a syntax check...