you can never restore a higher version db to a lower version;

looks like your db is 2008 but you are installing/using SQL2005. check to see if you installed an isntance,...

evansrf (1/30/2014)

---

I'm having trouble understanding the requirements for this.

I'd like to have a stored proc that selects/updates a distributed partitioned view.

I really don't want to have to grant rights to...

I think you simply want SET @Day = cast( getdate() as date)

you have a DATENAME function that would reurn 'FRIDAY", which you tehn try to cast as a date, and...

ok i got a lot more data than the ten or so rows you displayed, but this seems to do it.

you might need to grab a vopy of DelimitedSplit8K

http://www.sqlservercentral.com/articles/Tally+Table/72993/

;WITH MyCTE([clndr_id],[clndr_data])

AS

(

SELECT...

interesting; so you need to find multiple substrings that are like 'd|[0-9][0-9][0-9][0-9][0-9]' ie '(d|41519)'

here's a cte of his post for the adventurous;

i'm trying a lazy DelimitedSplit8k cross apply...

not sure how much help this would be.

the CTE below is just so I have a table that represents the data you provided.

only the select is the part you'd want...

Adam i think you just want to do wrap your query as a cte/subselect to get distinct logins with weak passwords, since your new logic allows multiple matches.

if '0001' and...

change your datatype to varchar(max).

http://technet.microsoft.com/en-us/library/ms176089.aspx

max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size is the actual length of the data entered + 2...

i have this saved in my snippets for auditing weak passwords;

basically i have a dictionary of known weak passwords to compare against, and also check if the password = loginname.

hope...

you are talking about the default trace?

if that's true, there's no way to modify that built in default trace.

however, you can script out that same trace,and create a duplicate of...

ok, in that case, the idea is kind of the same...minimize the data you are selecting from the remote server.

a join to a local tablre, like this:

FROM Customers T1

INNER JOIN...

can you try explicitly saving the document as excel 2003-2007?

i've had a similar situation where a csv or html file was saved with an xls extension, so it was not...

i deprecated my oldstyle maintenance plans in favor of TSQL scripts for the same steps. for example, i really liked Gianluca Sartori's version of capturing only relevant errors from DBCC...

Greg Edwards-268690 (1/29/2014)[hr

Wouldn't an Exception Join (NOT EXSISTS) actually be better?

Although a real gap could also be record updated.

Or maybe that never happens. 😀

Bottom line - spend the time...

balasach82 (1/29/2014)

---

We run a delete query which deletes 500-1000 records. But this takes more than 2hours to run.

We use Linked server between 2 SQL 2008 servers.

We delete rows...