Hi,

A database snapshot is not a backup, it is just an "empty" database that holds the changes in the source database pages and during time it grows as more transactions...

Hi,

Have you linked to the remote server?

If you haven't, then you should do it first. Check this reference: http://msdn.microsoft.com/en-us/library/ms190479.aspx

Regards

IgorMi

🙁

Question: How many rows are returned from the selects listed above?

Explanation: You cannot insert null values into a not nullable column.

Everyone knows that.

So what is the gain from this...

Hi,

I used your script and it failed on AdventureWorks2008R2.

The script supplied by chandu.ade works fine. I'm using it on more environments.

Thanks

Hi All,

If somebody was interested in this issue, I can contribute to it after experiencing on. After being searching the net for the concrete fix for the issue and finishing...

Hi GSquared,

Yes sure, if it was for a production I'd have gone with microsoft directly. This is, fortunately, not a problem on productions as their databases have same collation...

Hugo Kornelis (9/19/2012)

---

Nice question. I almost got it wrong, because I had first overlooked the TOP clause.

However, the official correct answer is still a bit questionable. The result of a...

SQL Kiwi (9/14/2012)

---

ChrisM@Work (9/14/2012)

---

[font="Courier New"]

Table Ind_level External Fragm(%) Avg Frag Size Page_count Internal Fragm(%) Ind_size (KB)

identity ...

Jeff Moden (9/12/2012)

---

alanspeckman (9/12/2012)

---

What prompted me to question this was my coworker said it was a best practice when showing me a database design. I remembered Paul's video from...

Hi,

Every BEGIN TRANSACTION must end up with COMMIT TRANSACTION or ROLLBACK TRANSACTION

I’ll try to insert something that causes primary key constraint violation (locally on my machine).

The first approach:

BEGIN TRY

...

DugyC (8/31/2012)

---

IgorMi (8/31/2012)

---

Nice question!

It is good to know the advantages and disadvantages of temp tables and temp variable tables

The following code will work fine:

create table #tmp(SlNo int identity, Name varchar(200))

INSERT...

Nice question!

It is good to know the advantages and disadvantages of temp tables and temp variable tables

The following code will work fine:

create table #tmp(SlNo int identity, Name varchar(200))

INSERT INTO #tmp(Name)...

Hi,

Try this:

begin

begin try

begin transaction

update fo_run_date

set fo_act_run_date = '123';-- <== this is int going into datetime field

commit transaction;

end try

begin catch

begin try

insert into perf_bench_fo_errors (proc_name, error_nbr, error_level, error_posn, error_msg, error_date)

values (

ERROR_PROCEDURE()

,ERROR_NUMBER()

,ERROR_SEVERITY()

,ERROR_LINE()

,ERROR_MESSAGE()

,GETDATE()

...

Hi,

In SSMS go to Server objects then to Linked servers and see your providers. May be you have to install a new one for office 2010, or to make some...

Nice question!

I joined your club 🙂

Regards

IgorMi