:w00t: 37 views Zero replies :w00t:

SQL Show (4/30/2013)

---

I had the same problem few years back, no space in ldf drive. But users were able to logon. We received error only when try to run dml...

Yup Sean, i missed to specify that.. thanks for correction 🙂

U can only script the Structures of Tables, Stored Procedure, Functions & Views & then run that script on 2000..

Regarding data.. just create a DB manually on 2000 same...

UNC pathnames

UNC stands for Universal (or Uniform, or Unified) Naming Convention and is a syntax for accessing folders and files on a network of computers. The syntax is

\\<computer name>\<shared...

UNC path

Universal/Uniform Naming Convention. A UNC path describes the location of a volume, directory, or file.

The format for a UNC path is \\server\volume\directory\file and is not case-sensitive. For example:

\\Shared1_svr\Shared1\WGroups\Network\Orders.xlsRather than...

John Mitchell-245523 (4/29/2013)

---

Once the rebuild of any index has used up space in your transaction log, that space won't be freed up again until the transaction log is backed up....

Gosh !!! thanks it worked.. will inform the user to use the updated script for his purpose 🙂

All went well at Migration... on server (XXX)

One issue i have encountered..

While scheduling the jobs on server (XXX) the jobs are scheduled properly from a local server machine.. & its...

Actually this was very instant requirenment.. i thought they will give me a day or two to do this..

But they asked me to do it in an hour :w00t:

Anyways thanks...

i have to migrate from Sql 2005 to Sql 2005..(Only 2 databases)

1) I will take a backup of two databases & then copy the backup file to new serevr

2) I...

Yes, my task is to Move databses from one instance sql 2005 to other instance sql 2005..

So what things i have to do & take care of...

in terms of Login...

I am stuck at the end part

please refer below link

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/75331/

I have everything uptill ---(Let's continue building the incremental load. )

I did build incremental load but new rows is...

My Task is mentioned belwo..

Copy all data from Source to destination DB

Every month only the updated or new data needs to be transffered to destination..

Will SSIS help in this?

Jeff, Yup The Srever & the Database would be different...

Why it would be overkill :w00t: explain me.. coz i am going to do it.. i dont know how to do...